|
Problem IT03048
|
Status: Closed |
DATABASE SHUTS DOWN DURING ROLLBACK TO AN EXTERNAL SAVEPOINT IF AN IOE PACKAGE HAS BEEN RECREATED IN THE TRANSACTION |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
The problem was first fixed on DB2 v10.5 Fix Pack 4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.07.2014
08.09.2014
08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
