The program has been re-compiled and all packages have been rebound.
The program is a cobol program that does some thinking, grabs a record set, does more thinking, grabs another record set, and so on it goes. Interlaced in the thinking it may make updates based on its thinking.
I have tried to capture SQL statements with occasional snapshots, but I guess I am not taking the picture when it grabs the goods. I believe the program builds SQL statements as needed as determined in its thinking.
I have thought about trying to do a trace on the user connection, but my understanding is that may be difficult to actually use that.
Try re-booting the server. But do not do immediate restart.
2) disconnect power
3) disconnect UPS
4) make sure all lights are out on the front and back of the server
5) make sure none of the hard disks are still spinning (listen intently)
6) make sure none of the blower fans are running (wet your finger and hold next to the fan)
7) re-connect power
8) IPL the server
the procedure above will be just as helpful as reorg, runstats, rebind ....