Joined: 17 Oct 2004 Posts: 190 Location: hyderabad
Explanation: An attempt to create a DB2 thread by the subtask servicing
the DB2 request failed. The installed DB2CONN specifies
THREADERROR(N906D) or THREADERROR(ABEND).
If THREADERROR(N906D) is specified in the DB2CONN, processing continues. A -906 sqlcode is returned to the application and a transaction dump is taken with abend code AD2U.
THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE THIS FUNCTION IS DISABLED DUE TO A PRIOR ERROR
the requested function had been disabled by a prior error. This situation can arise if the application program has intercepted an abend (for instance, by an ON ERROR condition in a PL/I program) and continued to execute SQL statements. This situation may also arise if a DB2 CICS transaction encountered a create thread error yet continued to issue SQL requests without issuing a SYNCPOINT ROLLBACK first.
In general, an application program should terminate upon receipt of this return code. All subsequent attempts by the application to execute other SQL statements will also fail with the same return code. In the case of a DB2 CICS transaction, if the SQLERRP field in the SQLCA contains the module name DSNCEXT1, the transaction may issue a SYNCPOINT ROLLBACK and continue processing. If the transactions chooses to ROLLBACK and continue processing, it must be capable of correcting the situation that caused the create thread error to occur originally.