|
Problem IC64737
|
Status: Closed |
DB2 INSTANCE CRASHES WITH PACKET DESCRIPTOR CORRUPTION ON A CATALOG TABLE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
Problem Description :
This particular trap will occur anytime we're getting the packed
descriptor in the engine for a catalog table.
For regular tables, if they have this corruption, you will
simply get the -901.
DB2 instance crashes with Packet Descriptor corruption on a
catalog table with the entry such as :
----------------------------------------------------------------
2009-11-02-09.13.10.632373+060 I16743721A874 LEVEL: Severe
PID : 24521 TID : 2199383959888PROC :
db2sysc 0
INSTANCE: db2iapx NODE : 000 DB : APXDB
APPHDL : 0-15 APPID:
*LOCAL.db2iapx.091102080625
AUTHID : DB2IAPX
EDUID : 17 EDUNAME: db2agent (APXDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 50
sqlerrmc: Corrupt PD->length in table "SYSIBM "."SYSCHECKS"
sqlerrp : SQLRL2EF
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF38 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
----------------------------------------------------------------
--------
with the stack trace as :
0000020001E8F01E sqloCrashOnCriticalMemoryValidationFailure +
0x002e
(/home/db2iapx/sqllib/lib64/libdb2e.so.1)
0000020001E915E8 sqlofmblkEx + 0x0104
(/home/db2iapx/sqllib/lib64/libdb2e.so.1)
000002000270DA3C
_Z8sqlrlgtiP8sqlrr_cbPhiS1_iPtS2_S1_S2_PS1_iS3_iS3_PjS3_PsS3_S5_
i +
The instance crash occurs because of free memory block failure.
Instead of having graceful error handling by getting a -901, we
get a -901 dumped in the db2diag.log, followed by a trap.
It just happens to be one of the callers of the sqlrlgti
function amongst others e.g. SYSIBM.SYSCHECKS |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All user prior to DB2 V95 FP6 *
****************************************************************
* PROBLEM DESCRIPTION: *
* This particular trap will occur anytime we're getting the *
* packed *
* descriptor in the engine for a catalog table. *
* *
* For regular tables, if they have this corruption, you will *
* *
* simply get the -901. *
* *
* DB2 instance crashes with Packet Descriptor corruption on a *
* *
* catalog table with the entry such as : *
* *
* *
* *
* --------------------------------------------------------------
* *
* *
* *
* 2009-11-02-09.13.10.632373+060 I16743721A874 LEVEL: *
* Severe *
* PID : 24521 TID : 2199383959888PROC : *
* *
* db2sysc 0 *
* *
* INSTANCE: db2iapx NODE : 000 DB : *
* APXDB *
* APPHDL : 0-15 APPID: *
* *
* *LOCAL.db2iapx.091102080625 *
* *
* AUTHID : DB2IAPX *
* *
* EDUID : 17 EDUNAME: db2agent (APXDB) 0 *
* *
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, *
* *
* probe:300 *
* *
* DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes *
* *
* sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: *
* 50 *
* sqlerrmc: Corrupt PD->length in table "SYSIBM "."SYSCHECKS" *
* *
* sqlerrp : SQLRL2EF *
* *
* sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) *
* 0x00000000 *
* (4) 0x00000000 (5) 0xFFFFFF38 (6) *
* 0x00000000 *
* sqlwarn : (1) (2) (3) (4) (5) *
* (6) *
* (7) (8) (9) (10) (11) *
* *
* sqlstate: *
* *
* --------------------------------------------------------------
* *
* -------- *
* *
* with the stack trace as : *
* *
* *
* *
* 0000020001E8F01E sqloCrashOnCriticalMemoryValidationFailure *
* + *
* 0x002e *
* *
* (/home/db2iapx/sqllib/lib64/libdb2e.so.1) *
* *
* 0000020001E915E8 sqlofmblkEx + 0x0104 *
* *
* (/home/db2iapx/sqllib/lib64/libdb2e.so.1) *
* *
* 000002000270DA3C *
* *
* _Z8sqlrlgtiP8sqlrr_cbPhiS1_iPtS2_S1_S2_PS1_iS3_iS3_PjS3_PsS3_S
* *
* i + *
* *
* *
* *
* *
* *
* The instance crash occurs because of free memory block *
* failure. *
* Instead of having graceful error handling by getting a -901, *
* we *
* get a -901 dumped in the db2diag.log, followed by a trap. *
* *
* *
* *
* It just happens to be one of the callers of the sqlrlgti *
* *
* function amongst others e.g. SYSIBM.SYSCHECKS *
****************************************************************
* RECOMMENDATION: *
* Local Fix: *
* Avoid accessing that catalog table in any way. Even avoiding *
* DDL if possible. e.g. opearions like executing runstats. *
* *
* *
* Permanent Fix : *
* Please upgrade to DB2 V95 FP6 and above *
****************************************************************
DB2 INSTANCE CRASHES WHEN PACKED DESCRIPTOR CORRUPTION IS
DETECTED ON A CATALOG TABLE |
| Local Fix: |
Avoid accessing that catalog table in any way. Even avoiding DDL
if possible. e.g. opearions like executing runstats. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in V95 FP6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC65721
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.11.2009
10.05.2011
10.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
