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 IT03048 Status: Geschlossen

DATABASE SHUTS DOWN DURING ROLLBACK TO AN EXTERNAL SAVEPOINT IF AN IOE
PACKAGE HAS BEEN RECREATED IN THE TRANSACTION

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Rollback to an external savepoint would lead to database shut 
down if the package associated with an Index on Expression has 
been recreated since the external savepoint was declared. 
 
rollback to savepoint savepoint1 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL1034C  The database was damaged, so all applications 
processing the 
database were stopped.  SQLSTATE=58031 
 
From db2diag.log: 
 
2014-07-09-11.35.42.640851-240 I130990E985           LEVEL: 
Error 
PID     : 29473                TID : 46913369925952  KTID : 
29858 
PROC    : db2sysc 
INSTANCE: abc                NODE : 000            DB   : 
DB32BIT 
APPHDL  : 0-9                  APPID: *LOCAL.abc.140709153533 
AUTHID  : NEWTON               HOSTNAME: hotel73 
EDUID   : 308                  EDUNAME: db2agent (DB32BIT) 
FUNCTION: DB2 UDB, access plan manager, 
sqlra_cleanup_apm_using_svptid, probe:100 
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT 
          "SQLCA has already been built" 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -950   sqlerrml: 0 
 sqlerrmc: 
 sqlerrp : SQLRA04D 
 sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFEFC      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
<.....> 
 
2014-07-09-11.35.42.834780-240 I169898E975           LEVEL: 
Severe 
PID     : 29473                TID : 46913369925952  KTID : 
29858 
PROC    : db2sysc 
INSTANCE: abc                NODE : 000            DB   : 
DB32BIT 
APPHDL  : 0-9                  APPID: *LOCAL.abc.140709153533 
AUTHID  : NEWTON               HOSTNAME: hotel73 
EDUID   : 308                  EDUNAME: db2agent (DB32BIT) 
FUNCTION: DB2 UDB, relation data serv, sqlr_rollback_savept, 
probe:250 
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT 
          "SQLCA has already been built" 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -984   sqlerrml: 0 
 sqlerrmc: 
 sqlerrp : SQLRA04D 
 sqlerrd : (1) 0x801A006D      (2) 0xFFFFFC4A      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFEFC      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running DB2 v10.5 on platforms Linux, Unix and     * 
* Windows, and specifically using Index on Expression and      * 
* rollback to external savepoint.                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update DB2 to v10.5 Fix Pack 4.                              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
The problem was first fixed on DB2 v10.5 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.07.2014
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList