I know this is a little frustrating but bear with me. I'm only trying to help isolate when the activation group disappears.
I take it from your answer that the QSQCLI activation group is there after SQLExecDirect executes, at least the first time.
Can your diagnostic process check to see if the QSQCLI activation group is in the activation group list before and after running SQLExecDirect? Maybe something within CLI is closing down the activation group. What is the CLI state code when the crash occurs.
When your job locks up do you have enough time to get it into debug from another session?
APARs SE34144 (V6R1) and SE46188 (V7R1) might be of interest to you.
Gary Monnier
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Wednesday, February 01, 2012 1:48 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQLCLI problems: Now we know that the QSQCLI purge is not the cause.
Monnier, Gary wrote:
Is it there right after SQLExecDirect executes?
What does SQLExecDirect return?
If the QSQCLI activation group hasn't been corrupted, then it returns either SQL_SUCCESS (0), SQL_SUCCESS_WITH_INFO (1), SQL_NO_DATA_FOUND (100), SQL_ERROR (-1), or SQL_INVALID_HANDLE (-2). None of which would indicate that the activation group is on the verge of becoming corrupted. And if the return code is negative, then my program spits out a dump of the SQL statement that caused the error, and some diagnostics.
If it's been corrupted, it throws an exception instead of returning, the job locks up, my program abends, and the QSQCLI activation group dies.
--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
