Thursday 28 May 2009

start ODBC control panel

odbccp32.cpl

Package deployment

We were hesitating last night to deploy a package on a server that had active SBS jobs running.  We were doing a UA package and saw that there were PD SBS jobs running.

It seems that you can do this, supporting (and not so supporting) documentation is below about the 812 package deployment process.

SBS running

An active subsystem job that is constantly running with a processing status is seen by the deployment as a job that it can not put on hold.  This requires end users to manually stop any 'processing' subsystem jobs so that a package deployment can be successfully completed.  A full lock on the files being changed by the deployment is required and this requires a hold on all jobs in the queue and kernel processes on the logic server.

Recoverable failed deployments

Good news is that the package can be redeployed at anytime (they are on 8.96.1.5)

This issue is fixed in BUG:8356917 (Tools Release 8.96.1.3 or higher) in which user do not need to restart services in order to unlock the server. If the Package deployment hangs due to certain interuptions e.g. long running business functions,subsystem jobs, UBEs currently running, etc, user can resubmit the Package Deployment UBE R98825D by clicking the Deploy button in Package Deploy application after those interuptions has fininshed and the system will do a clean up to unlock the locks and re-deploy the package.

Package deploy notes.

The solution is based on the existing process of how the server deployment process works.  Once the R98825D is kicked off, the deployment process signals all kernels on the server to go into a wait status.  Any job or process currently running will continue to process to completion, however, any process or job that is in the queue will be put on hold.
The end effect on end users is that they will ultimately not be able to process anything that uses the logic server (i.e. BSFNS mapped to the server, UBE jobs, Scheduled Jobs) during the time it takes for the deployment to finish.  Update packages would be much faster and full packages can take more time depending on hardware speed and disk I/O.
With this effect occurring, it is not recommended that clients deploy packages during normal hours of operation in a production environment.  The effect on changes to the specs and business libraries on dependent processes still waiting in the queue for after the deploy finishes could cause unexpected results.  For instance, if a transaction requires 5 functions to run and they are dependent on each other in the process then it would be possible that a deployment submitted while the first function is running could change the outcome of the remaining functions based on changes to the objects being used.   For this reason, it is recommended that production deployments be scheduled during a down time or during a slow period where end users are limited or doing read only type processes.
A true 24/7 shop may require a unique or custom solution to hot swap the servers to provide minimal downtime.  This is not supported by GSC officially and should be referred to our field support or business partners for official support of these types of solutions.  Even with a hot swap type solution, ultimately end users will be impacted and transactional processes may be impacted.
Clients that are the least affected by deployments to a logic server are those running a true fat client setup which is supported through the 8.10 release.  A Citrix or Terminal Server setup has the same negative impact on end users like HTML users normally since OCMs would default business functions to run on the server.  Running business functions locally in a terminal server setup can make your end users less impacted by deployment but will also negatively impact performance and the total number of users that can run concurrently on those machines.  HTML users, which is the only option in 8.11 and above will always be negatively impacted by deployments and this is the reason why the subject ofdeployment recommendations has more recently become an important topic with the EnterpriseOne client base.
Other ideas to help minimize impact on a production system include using multifoundation or separate logic servers for DV and PY versus a PD system.  The deployment of a package to DV on the same machine as PD sharing the same port would have the same effect of locking down all kernels and negatively impacting productions users.  The use of separate ports on the same logic server can effectively separate a production pathcode from deployment events occurring in other pathcodes.
Some enhancements to the deployment process seen in 8.96_A1 and above is the ability for a deployment process that is hung due to long running business functions to be resubmitted and recover any held kernel processes.  This will help minimize the need to refresh services if a deployment process hangs or fails due to network failures.  Simply rerunning the R98825D will accomplish this in 8.96_A1 and above.
Update 2/7/08 -- Two new SARs have been entered to address issues with the new requirements around the package deployment.

Tuesday 26 May 2009

EE or SE, to enterprise or not to enterprise

To determine if your oracle DB is enterprise or not, run the following SQL:

select product, version from product_component_version;

Standard will reveal:

Oracle Database 10g enterprise edition for EE

Oracle Database 10g for SE

you can do a select from DBA_FEATURE_USAGE_STATISTICS to see how much people have been using things they should not be using.

Thursday 14 May 2009

ActiveX controls

More information on the activeX controls. How to find out what version a user is using. I could write a script that could tell you all of this too?


JDE ActiveX controls:

There are two main activeX controls that JDE uses:

Name

desc

8.96.E vers

8.96.4.0 vers

Jdeexepimp

Import and export

9,2003,5,30

8960,2008,2,17

Jdewebctls

Rich text editing

8960,2006,6,8

8960,2006,6,8

Jdeexepimp

Jdewebctls

So, only the import and export OCX has changed between the tools releases.

In internet explorer, you can see the registered add-ons by going to internet options, programs and then choosing manage add ons.

clip_image001

The above screen is ie6 with both activeX controls loaded.

How do I tell what version I have:

Run regedit and search for jdewebctls.inf under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Code Store Database\Distribution Units

To see what version is on your machine, you need to look at the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Code Store Database\Distribution Units

Search for jdeweb, then look at the installed version under that path:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Code Store Database\Distribution Units\{B1D21FC5-A742-4261-86F2-C7B7F1A31C5D}\InstalledVersion

clip_image002

The value \{B1D21FC5-A742-4261-86F2-C7B7F1A31C5D}\ can be found by looking at the following registry entries:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\ModuleUsage\C:/WINNT/Downloaded Program Files/jdewebctlsU.ocx

{B1D21FC5-A742-4261-86F2-C7B7F1A31C5D}

Note that if this was manually installed last time, the update will not come from the website, it will need to be manually updated.  This can be done with an admin running the following:

remember that they are stored in the axctls dir under webclient.war for your webserver.  Make a dir on the dep server that everyone has access to, and then create a script.

Manual job to copy them up:

xcopy /Y \\deployment\E812\OCXInstall %windir%

regsvr32.exe %windir%\jdeexpimpU.ocx

regsvr32.exe %windir%\jdewebctlsU.ocx

pause

Tuesday 12 May 2009

Tiered deployment locations

This is a fairly easy thing to set up, it’s especially good if you have central objects that are remote to your production server and deployment server.

When I say this is easy, there is one little thing that I’ve forgotten before and has created no end of grief. 

Sure you can go into the pathcode master and change the location of the central objects, and seemingly you are nearly there…  Do the same in the planner environment, or ESU’s won’t go on right.

The thing that you need to remember to do is UPDATE object librarian F9861 before you apply any ESU’s and before anything is checked in, otherwise you will start to get duplicates – and this is a little hard to fix after a few months.

select simkey, count(1) from ol812.f9861 where sipathcd = 'PY812' and sistce = '1' group by simkey

The above SQL will ensure that there is currently only one name being used as a deployment location.  Then update the old with the new and you should be fine.

Things to remember when renaming an ent server 8.12 edition

This is by no means an exhaustive list, but the things I generally forget.

F96511 for machine name and active package / data source information

Remember LDAP changes for security server, if it was/is a security server - F00928

Default queues for batch jobs - F986130

default printer – add one

JDE.INI changes & JAS.INI changes

Thursday 7 May 2009

Basic linux script to document system

!#/usr/bin/ksh
echo '#####date'
date
echo "#####system name kernel info"
uname -a
echo "#####name and version OS"
head -n1 /etc/issue
#echo "#####Partitions registered"
#cat /proc/partitions
echo "#####MEMORY Info"
grep MemTotal /proc/meminfo
echo "#####CPU info"
grep "model name" /proc/cpuinfo
echo "#####filesystem mounts"
mount | column -t
echo "#####uptime"
uptime
echo "#####disk information"
hdparm -i /dev/sda
echo "#####file system capacity"
df -k
echo "ipconfig"
ifconfig

unix commands

Command
Description


apropos whatis
Show commands pertinent to string. See also threadsafe


man -t man | ps2pdf - > man.pdf
make a pdf of a manual page

which command
Show full path name of command

time command
See how long a command takes


time cat
Start stopwatch. Ctrl-d to stop. See also sw


nice info
Run a low priority command (The "info" reader in this case)


renice 19 -p $$
Make shell (script) low priority. Use for non interactive tasks

dir navigation


cd -
Go to previous directory


cd
Go to $HOME directory

(cd dir && command)
Go to dir, execute command and return to current dir


pushd .
Put current dir on stack so you can popd back to it

file searching


alias l='ls -l --color=auto'
quick dir listing


ls -lrt
List files by date. See also newest and find_mm_yyyy


ls /usr/bin | pr -T9 -W$COLUMNS
Print in 9 columns to width of terminal

find -name '*.[ch]' | xargs grep -E 'expr'
Search 'expr' in this dir and below. See also findrepo

find -type f -print0 | xargs -r0 grep -F 'example'
Search all regular files for 'example' in this dir and below

find -maxdepth 1 -type f | xargs grep -F 'example'
Search all regular files for 'example' in this dir

find -maxdepth 1 -type d | while read dir; do echo $dir; echo cmd2; done
Process each item with multiple commands (in while loop)


find -type f ! -perm -444
Find files not readable by all (useful for web site)


find -type d ! -perm -111
Find dirs not accessible by all (useful for web site)


locate -r 'file[^/]*\.txt'
Search cached index for names. This re is like glob *file*.txt


look reference
Quickly search (sorted) dictionary for prefix


grep --color reference /usr/share/dict/words
Highlight occurances of regular expression in dictionary

archives and compression

gpg -c file
Encrypt file

gpg file.gpg
Decrypt file

tar -c dir/ | bzip2 > dir.tar.bz2
Make compressed archive of dir/

bzip2 -dc dir.tar.bz2 | tar -x
Extract archive (use gzip instead of bzip2 for tar.gz files)

tar -c dir/ | gzip | gpg -c | ssh user@remote 'dd of=dir.tar.gz.gpg'
Make encrypted archive of dir/ on remote machine

find dir/ -name '*.txt' | tar -c --files-from=- | bzip2 > dir_txt.tar.bz2
Make archive of subset of dir/ and below

find dir/ -name '*.txt' | xargs cp -a --target-directory=dir_txt/ --parents
Make copy of subset of dir/ and below

( tar -c /dir/to/copy ) | ( cd /where/to/ && tar -x -p )
Copy (with permissions) copy/ dir to /where/to/ dir

( cd /dir/to/copy && tar -c . ) | ( cd /where/to/ && tar -x -p )
Copy (with permissions) contents of copy/ dir to /where/to/

( tar -c /dir/to/copy ) | ssh -C user@remote 'cd /where/to/ && tar -x -p'
Copy (with permissions) copy/ dir to remote:/where/to/ dir

dd bs=1M if=/dev/sda | gzip | ssh user@remote 'dd of=sda.gz'
Backup harddisk to remote machine

rsync (Network efficient file copier: Use the --dry-run option for testing)

rsync -P rsync://rsync.server.com/path/to/file file
Only get diffs. Do multiple times for troublesome downloads

rsync --bwlimit=1000 fromfile tofile
Locally copy with rate limit. It's like nice for I/O

rsync -az -e ssh --delete ~/public_html/ remote.com:'~/public_html'
Mirror web site (using compression and encryption)

rsync -auz -e ssh remote:/dir/ . && rsync -auz -e ssh . remote:/dir/
Synchronize current directory with remote one

ssh (Secure SHell)

ssh $USER@$HOST command
Run command on $HOST as $USER (default command=shell)


ssh -f -Y $USER@$HOSTNAME xeyes
Run GUI command on $HOSTNAME as $USER

scp -p -r $USER@$HOST: file dir/
Copy with permissions to $USER's home directory on $HOST

ssh -g -L 8080:localhost:80 root@$HOST
Forward connections to $HOSTNAME:8080 out to $HOST:80

ssh -R 1434:imap:143 root@$HOST
Forward connections from $HOST:1434 in to imap:143

wget (multi purpose download tool)


(cd dir/ && wget -nd -pHEKk http://www.pixelbeat.org/cmdline.html)
Store local browsable version of a page to the current dir

wget -c http://www.example.com/large.file
Continue downloading a partially downloaded file

wget -r -nd -np -l1 -A '*.jpg' http://www.example.com/dir/
Download a set of files to the current directory

wget ftp://remote/file[1-9].iso/
FTP supports globbing directly


wget -q -O- http://www.pixelbeat.org/timeline.html | grep 'a href' | head
Process output directly

echo 'wget url' | at 01:00
Download url at 1AM to current dir

wget --limit-rate=20k url
Do a low priority download (limit to 20KB/s in this case)

wget -nv --spider --force-html -i bookmarks.html
Check links in a file

wget --mirror http://www.example.com/
Efficiently update a local copy of a site (handy from cron)

networking (Note ifconfig, route, mii-tool, nslookup commands are obsolete)

ethtool eth0
Show status of ethernet interface eth0

ethtool --change eth0 autoneg off speed 100 duplex full
Manually set ethernet interface speed

iwconfig eth1
Show status of wireless interface eth1

iwconfig eth1 rate 1Mb/s fixed
Manually set wireless interface speed


iwlist scan
List wireless networks in range


ip link show
List network interfaces

ip link set dev eth0 name wan
Rename interface eth0 to wan

ip link set dev eth0 up
Bring interface eth0 up (or down)


ip addr show
List addresses for interfaces

ip addr add 1.2.3.4/24 brd + dev eth0
Add (or del) ip and mask (255.255.255.0)


ip route show
List routing table

ip route add default via 1.2.3.254
Set default gateway to 1.2.3.254


tc qdisc add dev lo root handle 1:0 netem delay 20msec
Add 20ms latency to loopback device (for testing)


tc qdisc del dev lo root
Remove latency added above


host pixelbeat.org
Lookup DNS ip address for name or vice versa


hostname -i
Lookup local ip address (equivalent to host `hostname`)


whois pixelbeat.org
Lookup whois info for hostname or ip address


netstat -tupl
List internet services on a system


netstat -tup
List active connections to/from system

windows networking (Note samba is the package that provides all this windows specific networking support)


smbtree
Find windows machines. See also findsmb

nmblookup -A 1.2.3.4
Find the windows (netbios) name associated with ip address

smbclient -L windows_box
List shares on windows machine or samba server

mount -t smbfs -o fmask=666,guest //windows_box/share /mnt/share
Mount a windows share

echo 'message' | smbclient -M windows_box
Send popup to windows machine (off by default in XP sp2)

text manipulation (Note sed uses stdin and stdout. Newer versions support inplace editing with the -i option)

sed 's/string1/string2/g'
Replace string1 with string2

sed 's/\(.*\)1/\12/g'
Modify anystring1 to anystring2

sed '/ *#/d; /^ *$/d'
Remove comments and blank lines

sed ':a; /\\$/N; s/\\\n//; ta'
Concatenate lines with trailing \

sed 's/[ \t]*$//'
Remove trailing spaces from lines

sed 's/\([`"$\]\)/\\\1/g'
Escape shell metacharacters active within double quotes


seq 10 | sed "s/^/      /; s/ *\(.\{7,\}\)/\1/"
Right align numbers

sed -n '1000p;1000q'
Print 1000th line

sed -n '10,20p;20q'
Print lines 10 to 20

sed -n 's/.*<title>\(.*\)<\/title>.*/\1/ip;T;q'
Extract title from HTML web page

sed -i 42d ~/.ssh/known_hosts
Delete a particular line

sort -t. -k1,1n -k2,2n -k3,3n -k4,4n
Sort IPV4 ip addresses


echo 'Test' | tr '[:lower:]' '[:upper:]'
Case conversion


tr -dc '[:print:]' < /dev/urandom
Filter non printable characters


history | wc -l
Count lines

set operations (Note you can export LANG=C for speed. Also these assume no duplicate lines within a file)

sort file1 file2 | uniq
Union of unsorted files

sort file1 file2 | uniq -d
Intersection of unsorted files

sort file1 file1 file2 | uniq -u
Difference of unsorted files

sort file1 file2 | uniq -u
Symmetric Difference of unsorted files

join -a1 -a2 file1 file2
Union of sorted files

join file1 file2
Intersection of sorted files

join -v2 file1 file2
Difference of sorted files

join -v1 -v2 file1 file2
Symmetric Difference of sorted files

math


echo '(1 + sqrt(5))/2' | bc -l
Quick math (Calculate φ). See also bc


echo 'pad=20; min=64; (100*10^6)/((pad+min)*8)' | bc
More complex (int) e.g. This shows max FastE packet rate


echo 'pad=20; min=64; print (100E6)/((pad+min)*8)' | python
Python handles scientific notation


echo 'pad=20; plot [64:1518] (100*10**6)/((pad+x)*8)' | gnuplot -persist
Plot FastE packet rate vs packet size


echo 'obase=16; ibase=10; 64206' | bc
Base conversion (decimal to hexadecimal)


echo $((0x2dec))
Base conversion (hex to dec) ((shell arithmetic expansion))


units -t '100m/9.69s' 'miles/hour'
Unit conversion (metric to imperial)


units -t '500GB' 'GiB'
Unit conversion (SI to IEC prefixes)


units -t '1 googol'
Definition lookup


seq 100 | (tr '\n' +; echo 0) | bc
Add a column of numbers. See also add and funcpy

calendar


cal -3
Display a calendar


cal 9 1752
Display a calendar for a particular month year


date -d fri
What date is it this friday. See also day


[ $(date -d "tomorrow" +%d) = "01" ] || exit
exit a script unless it's the last day of the month


date --date='25 Dec' +%A
What day does xmas fall on, this year


date --date='@2147483647'
Convert seconds since the epoch (1970-01-01 UTC) to date


TZ=':America/Los_Angeles' date
What time is it on West coast of US (use tzselect to find TZ)

echo "mail -s 'get the train' P@draigBrady.com < /dev/null" | at 17:45
Email reminder


echo "DISPLAY=$DISPLAY xmessage cooker" | at "NOW + 30 minutes"
Popup reminder

locales


printf "%'d\n" 1234
Print number with thousands grouping appropriate to locale


BLOCK_SIZE=\'1 ls -l
get ls to do thousands grouping appropriate to locale


echo "I live in `locale territory`"
Extract info from locale database


LANG=en_IE.utf8 locale int_prefix
Lookup locale info for specific country. See also ccodes


locale | cut -d= -f1 | xargs locale -kc | less
List fields available in locale database

recode (Obsoletes iconv, dos2unix, unix2dos)


recode -l | less
Show available conversions (aliases on each line)

recode windows-1252.. file_to_change.txt
Windows "ansi" to local charset (auto does CRLF conversion)

recode utf-8/CRLF.. file_to_change.txt
Windows utf8 to local charset

recode iso-8859-15..utf8 file_to_change.txt
Latin9 (western europe) to utf8

recode ../b64 < file.txt > file.b64
Base64 encode

recode /qp.. < file.txt > file.qp
Quoted printable decode

recode ..HTML < file.txt > file.html
Text to HTML


recode -lf windows-1252 | grep euro
Lookup table of characters


echo -n 0x80 | recode latin-9/x1..dump
Show what a code represents in latin-9 charmap


echo -n 0x20AC | recode ucs-2/x2..latin-9/x
Show latin-9 encoding


echo -n 0x20AC | recode ucs-2/x2..utf-8/x
Show utf-8 encoding

CDs

gzip < /dev/cdrom > cdrom.iso.gz
Save copy of data cdrom

mkisofs -V LABEL -r dir | gzip > cdrom.iso.gz
Create cdrom image from contents of dir

mount -o loop cdrom.iso /mnt/dir
Mount the cdrom image at /mnt/dir (read only)

cdrecord -v dev=/dev/cdrom blank=fast
Clear a CDRW

gzip -dc cdrom.iso.gz | cdrecord -v dev=/dev/cdrom -
Burn cdrom image (use dev=ATAPI -scanbus to confirm dev)

cdparanoia -B
Rip audio tracks from CD to wav files in current dir

cdrecord -v dev=/dev/cdrom -audio *.wav
Make audio CD from all wavs in current dir (see also cdrdao)

oggenc --tracknum='track' track.cdda.wav -o 'track.ogg'
Make ogg file from wav file

disk space (See also FSlint)


ls -lSr
Show files by size, biggest last


du -s * | sort -k1,1rn | head
Show top disk users in current dir. See also dutop


df -h
Show free space on mounted filesystems


df -i
Show free inodes on mounted filesystems


fdisk -l
Show disks partitions sizes and types (run as root)


rpm -q -a --qf '%10{SIZE}\t%{NAME}\n' | sort -k1,1n
List all packages by installed size (Bytes) on rpm distros


dpkg-query -W -f='${Installed-Size;10}\t${Package}\n' | sort -k1,1n
List all packages by installed size (KBytes) on deb distros


dd bs=1 seek=2TB if=/dev/null of=ext3.test
Create a large test file (taking no space). See also truncate


> file
truncate data of file or create an empty file

monitoring/debugging


tail -f /var/log/messages
Monitor messages in a log file


strace -c ls >/dev/null
Summarise/profile system calls made by command


strace -f -e open ls >/dev/null
List system calls made by command


ltrace -f -e getenv ls >/dev/null
List library calls made by command


lsof -p $$
List paths that process id has open


lsof ~
List processes that have specified path open


tcpdump not port 22
Show network traffic except ssh. See also tcpdump_not_me


ps -e -o pid,args --forest
List processes in a hierarchy


ps -e -o pcpu,cpu,nice,state,cputime,args --sort pcpu | sed '/^ 0.0 /d'
List processes by % cpu usage


ps -e -orss=,args= | sort -b -k1,1n | pr -TW$COLUMNS
List processes by mem usage. See also ps_mem.py


ps -C firefox-bin -L -o pid,tid,pcpu,state
List all threads for a particular process


ps -p 1,2
List info for particular process IDs


last reboot
Show system reboot history


free -m
Show amount of (remaining) RAM (-m displays in MB)


watch -n.1 'cat /proc/interrupts'
Watch changeable data continuously

system information (see also sysinfo) ('#' means root access is required)


uname -a
Show kernel version and system architecture


head -n1 /etc/issue
Show name and version of distribution


cat /proc/partitions
Show all partitions registered on the system


grep MemTotal /proc/meminfo
Show RAM total seen by the system


grep "model name" /proc/cpuinfo
Show CPU(s) info


lspci -tv
Show PCI info


lsusb -tv
Show USB info


mount | column -t
List mounted filesystems on the system (and align output)


grep -F capacity: /proc/acpi/battery/BAT0/info
Show state of cells in laptop battery

#
dmidecode -q | less
Display SMBIOS/DMI information

#
smartctl -A /dev/sda | grep Power_On_Hours
How long has this disk (system) been powered on in total

#
hdparm -i /dev/sda
Show info about disk sda

#
hdparm -tT /dev/sda
Do a read speed test on disk sda

#
badblocks -s /dev/sda
Test for unreadable blocks on disk sda

interactive (see also linux keyboard shortcuts)


readline
Line editor used by bash, python, bc, gnuplot, ...


screen
Virtual terminals with detach capability, ...


mc
Powerful file manager that can browse rpm, tar, ftp, ssh, ...


gnuplot
Interactive/scriptable graphing


links
Web browser


xdg-open http://www.pixelbeat.org/
open a file or url with the registered desktop application

miscellaneous


alias hd='od -Ax -tx1z -v'
Handy hexdump. (usage e.g.: • hd /proc/self/cmdline | less)


alias realpath='readlink -f'
Canonicalize path. (usage e.g.: • realpath ~/../$USER)


set | grep $USER
Search current environment

touch -c -t 0304050607 file
Set file timestamp (YYMMDDhhmm)


python -m SimpleHTTPServer
Serve current directory tree at http://$HOSTNAME:8000/

Wednesday 6 May 2009

basic linux printer management

lpstat will give you a list of outstanding printer jobs

There are various switches for this command, I use –a (all) and –l (long listing) and –d (destination) a lot. 

lp will print somethinglp –d

cancel will anti lp something

Tuesday 5 May 2009

64 bit oracle, 64 bit windows, what are the limitations

This took me a long time to find.  I don’t really know why…  Perhaps I’m a little thick…

Anyway, I wanted to find something that would unequivocally tell me that I can have an SGA of 32GB (or some other very large number) using oracle 10G 64 bit with windows 64bit OS.  I could not find it anywhere, until…  I found it on a blog…  Doh.

Let me know if you know where I can get it from the horses mouth (so to speak).

General Memory Limits

32-bit

64-bit

Total Virtual Address Space

4 GB

16 TB

Virtual Address Space per 32-bit process

2GB (3 GB if system is booted with /3gb switch)

4GB if compiled with /LARGEADDRESSAWARE 2GB otherwise

Virtual Address Space per 64-bit process

Not applicable

8 TB

Paged Pool

470 MB

128 GB

Non-Paged Pool

256 MB

128 GB

System Cache

1 GB

1 TB

Physical Memory and CPU Limits

32-bit

64-bit

Windows Compute Cluster Server 2003

NA

32 GB / 1-4 CPUs

Windows Server 2003 Standard Edition

4 GB / 1-4 CPUs

32 GB / 1-4 CPUs

Windows Server 2003 Enterprise Edition

64 GB / 1-8 CPUs

1 TB / 1-8 CPUs

Windows Server 2003 Datacenter Edition

64 GB / 1-32 CPUs

1 TB / 1-64 CPUs

EnterpriseOne ie6 freeze processing

Client machines need the following setting if they are using ie and are freezing their sessions with the “processing” graphic…  It’s not processing…

1. Open regedit.exe
2. Navigate to [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
3. Add a new DWORD entry named "MaxConnectionsPerServer"
4. Set the value of this new key to Decimal "10" or Hexadecimal "a"
5. Add a new DWORD entry named "MaxConnectionsPer1_0Server"
6. Set the value of this new key to Decimal "10" or Hexadecimal "a"
7. Close "regedit.exe" and restart you browser

You also might want to look at what the virus scanner is doing in the browser, look at the scanner output while you are browsing through JDE, make sure it’s not going crazy.

Also make sure that you have fixpack 21 for WAS 6.1 – especially for the plugins.  This prevents a plethora of HTTP 500 and HTTP 400 errors