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) |