I am supporting an Informix application that has a number of
interfaces written in C with embedded SQL. One interface in
particular has been experiencing a problem in that it will
intermittently fail on a COMMIT WORK statement. Since there have been
problems with the one interface in particular, debugging has been
turned on and indicates that the transaction gets into a commit
transaction function. However, the COMMIT WORK statement does not
complete as the debug would indicate either the success or failure of
the COMMIT WORK statement along with showing the exit from the
function. However, the debug simply stops after displaying the debug
statement indicating the entry into the commit transaction function.
As a result, both the interface and online users will begin
experiencing –243 (Could not position with table) and –245 (Could not
position within index) errors. Ultimately, the interface must be
manually terminated to free the resources held by the transactions
hung COMMIT WORK statement. Can anyone tell me why a commit would
fail and have any recommendations to correct the situation?

Informix Dynamic Server Version 9.30.FC2 on HP-UX 11.0

Any assistance is greatly appreciated.