suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT29231 Status: Closed

UNSUSTAINABLE TRAP CAN OCCUR AFTER A SUSTAINED TRAP IF THERE TEMP TABLES
ARE USED BY TRANSACTIONS

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
If this trap occurs, the stack will contain sqldUnlinkTCB and
sqldTrapCleanup. For example:


-----Frame------ ------Address----- ------Function +
Offset------
0x00001022F3FECAE0 0x0000100004653E14 sqldUnlinkTCB(sqeAgent*,
sqeLocalDatabase*, SQLD_TCB*) + 0x0630
( = offset 0x42E3E14 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FECD70 0x00001000043F6CD0 sqldDropTable(sqeAgent*,
SQLB_GLOBALS*, SQLD_TCB*, int) + 0x1580
( = offset 0x4086CD0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FED110 0x00001000043F4164 sqldTableDrop(sqeAgent*,
unsigned short, unsigned short, unsigned char, int, char*, int,
char*, int) + 0x19e4
( = offset 0x4084164 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FED740 0x0000100004697E0C
sqldDropAllTempByAppID(sqeAgent*, sqeLocalDatabase*,
SQLZ_APP_HDL*) + 0x047c
( = offset 0x4327E0C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEDBC0 0x00001000046D0DA0
`sqldTrapCleanup(sqeAgent*)` + 0x06b0
( = offset 0x4360DA0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEDCB0 0x000010000BCDBDF4
( = offset 0xB96BDF4 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEE030 0x000010000BCDB0EC
sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) + 0x015c
( = offset 0xB96B0EC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEE120 0x000010000B328780 sqeAgent::RunEDU() +
0x0b60
( = offset 0xAFB8780 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEE2F0 0x000010001082FEFC sqzEDUObj::EDUDriver() +
0x025c
( = offset 0x104BFEFC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEE3B0 0x000010001082FC7C sqlzRunEDU(char*, unsigned
int) + 0x001c
( = offset 0x104BFC7C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEE3D0 0x000010000E276118 sqloEDUEntry + 0x09c8
( = offset 0xDF06118 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001022F3FEE790 0x0000100000088AF4
( = offset 0x8AF4 in /lib64/libpthread.so.0)
0x00001022F3FEEA10 0x0000100016CC8814 clone + 0x00e4
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade the product to  DB2 LUW Version 11.5 fix pack 1      *
****************************************************************
Local Fix:
N/A
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.05.2019
04.07.2019
30.10.2019
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)