Sybase 12.5 - SQR Report - Program Problems

[Manoj Sooka]

Hello All

We are running Sybase 12.5 on a Unix 11i Server, model 9000/800/L3000-5x.
We are currently experiencing a problem with a C program.
The program was compiled with the +DAportable option and is basically a report spooler.
It polls the database every 5 or so minutes to see if there are any reports that need to be run
(depending on a number of factors), and these are executed, if there are any, using SQR/BRIO Server6.2
There are basically two problems being experienced.
The first one is that the update back to the database does not always happen.
But the bigger and more serious problem is that the program seemingly goes into a "hang".
By this we mean that the program is running, and there are reports that should be executed,
but nothing happens. We also experience a lot of defuncts where the relevant report has completed,
but the defunct remains indefinitely until we stop and start the C program.

The same C program runs on the Test environment perfectly. The only difference is that the Test server is HP-Unix 11.

Any assistance would be greatly appreciated