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

DB2 INSTANCE CRASHES WITH PACKET DESCRIPTOR CORRUPTION ON A CATALOG TABLE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
verfügbare FixPacks:
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

Lösung
Fixed in V95 FP6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC65721 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.11.2009
10.05.2011
10.05.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version