7.x to 9.x Performance issue in the extreme
Posted in 2003
Topics: Performance & Tuning, Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life
Greetings,
The problem: I run an identical program on Server A and Server B. On
Server A the program runs in 12 seconds. On Server B it takes 1.5
hours.
Server A: IBM RS/6000 H80, AIX 4.3.3.0.11, IBM IDS 7.31.UC7
Server B: IBM RS/6000 S80, AIX 4.3.3.0.9, IBM IDS 9.30.UC2
The only difference in the hardware on these 2 servers is Server A has
6 Gigabytes of RAM while Server B has 4. The SSA Disk subsystems are
identical.
Both servers use the 4J's "front end", installed and compiled on each
server in accordance with the 4J's installation guidelines.
Both servers are dedicated to running the IDS and the Application
software only. The application software is identical on both servers.
The application software resides on the same server as the IDS. Both
servers are pretty much running at the same load level ' not stressed
at all. Both appear to have plenty of available memory and plenty of
available CPU time. There is no I/O issue on either server. In short,
plenty of hardware for the task at hand.
The data in the DB is identical on both servers. The program that
generates the update statistics SQL is identical on both servers. The
indexes are identical on both servers. The total size of the database
after import is less than 2.5 Gig. The tables being accessed for this
report are all under 120 Meg.
The onconfig files are identical on both servers except for:
Variable: Server A: Sever B:
SHMVIRTSIZE 786432 524288
SHMADD 262144 393216
STACKSIZE 32 64
The program is a YTD Budget Report that takes a few parameters then
goes out to the database to collect the data and generate the report.
Nothing fancy. Nothing spectacular. Just your normal, everyday
accounting type report.
The speed on system B in all other areas is excellent. Normal "Finds"
against the largest tables, moving between screens,
adding/deleting/changing field data, etc all runs fine.
Given this info, where do I look for the problem?