DB2 - Problembeschreibung
Problem IC85989 | Status: Geschlossen |
A ROLLBACK DURING EXECUTION OF AN ANONYMOUS BLOCK REPORTS SQLCODE -804 (INVALID MODE), INSTEAD OF SQLCODE -911 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Under certain circumstances, the SQL compiler can report error SQL0804N in response to a rollback, instead of the expected error SQL0911N. This can happen during compilation of any SQL procedure, compiled SQL function, or compiled trigger, but it is most likely to occur during execution of a SQL PL compiled compound statement, or PL/SQL anonymous block. You will also see 'invalid mode' entries in db2diag.log, similar to the following: 2011-09-16-17.51.39.952576-240 I2027A547 LEVEL: Error PID : 1175556 TID : 1544 PROC : db2sysc INSTANCE: devinst NODE : 000 DB : DB2 APPHDL : 0-7 APPID: *LOCAL.devinst.110916215119 AUTHID : DEVINST EDUID : 1544 EDUNAME: db2agent (DB2) FUNCTION: DB2 UDB, relation data serv, sqlrr_spec_mode, probe:150 MESSAGE : Invalid mode 1 is not supported for request 2. DATA #1 : Hexdump, 4 bytes 0x070000000EBEF220 : 801A 006D The SQL0804N error does not represent a functional problem in and of itself, except that it can mask the actual error and make it more difficult for you to determine why a compilation has failed. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
None. If you see error SQL0804N, consider the possibility that the error might be masking a deadlock condition (SQL0911N) instead. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
This problem is first fixed in DB2 Version 9.7 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC88629 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.08.2012 20.10.2012 20.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |