DB2 - Problembeschreibung
Problem IC78852 | Status: Geschlossen |
NO ERROR RETURNED TO A .NET APPLICATION AFTER A ROLLBACK OF A QUERY DUE TO COMMANDTIMEOUT. | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 950 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * 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. * **************************************************************** | |
Local-Fix: | |
Increase the 'CommandTimeout' valus in the connection String. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 V9.5 FP9. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC79087 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.09.2011 27.04.2012 27.04.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP9 | |
Problem behoben lt. FixList in der Version | |
9.5.0.9 |