RE: 7.x to 9.x Performance issue in the extreme

Try running onstat -g ses SESSION_ID for the session that is taking so long. Assuming you are correct about the hardware resources being adequate, I'd look for this session or the application process that started the session to be waiting on some condition. Maybe a lock or some other shared resource. Regards, Bill Dare > -----Original Message----- > From: tlowrie@munis.com [SMTP:tlowrie@munis.com] > Sent: Thursday, October 02, 2003 11:37 AM > To: informix-list@iiug.org > Subject: 7.x to 9.x Performance issue in the extreme > > 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? sending to informix-list