Program delays (Pro*C)

From: Dilan <dilan_a_at_example.net>
Date: Thu, 15 May 2003 06:31:05 GMT
Message-ID: <JuGwa.11428$6q6.2667014@news2.telusplanet.net>

We have been experiencing some delays in a transaction intensive OLTP program written in COBOL running under Win2K. After narrowing it down to an embedded sql statement EXEC SQL COMMIT WORK END-EXEC., to get more clarity I re-wrote the program in C. I was able to reproduce the delay in a block of code that the Pro*C pre-compiler generated for the embedded SQL directive
"EXEC SQL COMMIT WORK." The line reads

"sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);".

Looks harmless, but has anyone seen anything like this before. Are there any name resolution operations, potential timeouts around this function call. The longest delay I have seen is about 62 seconds.

TIA
Dilan Received on Thu May 15 2003 - 01:31:05 CDT