home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList