DB2 CONNECT / DB2CONNCT / 970 - 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:                                              * 
* DB2 CLI                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Error Description                                        * 
****************************************************************

Increase the 'CommandTimeout' valus in the connection String.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

See Error Description

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.10.2011
05.06.2012
05.06.2012