DB2 CONNECT / DB2CONNCT / 950 - DB2

Even after a rollback of a query due to CommandTimeout of End 
Chain statement in .NET applications or End compound statement 
in CLI applications, no error is returned to the application. 
On Command Timeout, the CLI sends a SQLCancel() interrupt to the 
server. 
 
Irrespective of Interrupt  Enabled/Disabled at zOS server, upon 
Command Timeout CLI invokes SQlCancel() and rollbacks the 
transaction, but CLI rely on the server for interrupt error 
(-952). If no error is returned by the server, CLI also fails to 
return the error to the application.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V9.5 CLI/.NET applications.                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* No error message is returned to the application after        * 
* rollback of a query due to CommandTimeout of END CHAIN       * 
* statement in .NET applications or END COMPOUND statements in * 
* CLI applications.                                            * 
*                                                              * 
* On Command Timeout, the CLI sends a SQLCancel() interrupt to * 
* the server.                                                  * 
* Irrespective of INTERRUPT Enabled or Disabled at zOS server, * 
* upon Command Timeout CLI invokes SQlCancel() and rollbacks   * 
* the transaction, but CLI rely on the server for interrupt    * 
* error (-952). If no error is returned by the Z/OS server due * 
* to INTERRUPT disabled, CLI also fails to return the error to * 
* the application.                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.5 FP9.                                     * 
****************************************************************

Increase the 'CommandTimeout' valus in the connection String.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 V9.5 FP9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC79087 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.09.2011
27.04.2012
27.04.2012

9.5.FP9