DB2 - Problem description
Problem IT24863 | Status: Closed |
INCORRECT LOG COMPENSATION BEHAVIOUR CAN LEAD TO DATABASE CORRUPTION WHEN USING LOAD ON A TABLE WITH AN XML COLUMN | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Due to incorrect log write serialization between load and XML, logs can be incorrectly compensated leading to corrupt objects. Dialog messages: FUNCTION: DB2 UDB, buffer pool services, sqlbCheckSMP4ObjDel, probe:4093 MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected" DIA8501C A buffer pool logic error has occurred. DATA #1 : String, 16 bytes Found mixed bits FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::ForceDBShutdown, probe:16553 MESSAGE : Regular agent EDU doing ForceDBShutdown. Force DB shutdown agent ID is: DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes 0-15415 DATA #2 : sqeApplication_acbInfo, PD_TYPE_sqeApplication_acbInfo, 4 bytes x0 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F902995D78E _ZN16sqeLocalDatabase15ForceDBShutdownEi + 0x88E [1] 0x00007F902641C672 _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi + 0xF92 [2] 0x00007F90264B42BE _Z13sqldTableDropP8sqeAgenttthiPciS1_i + 0xAEE [3] 0x00007F902C5E9B55 sqlrlDataPartDrop + 0x145 [4] 0x00007F902C73AB0B _Z8sqlrldtcP8sqlrr_cbP23SQLKD_RQST_REPLY_FORMATisP13SQLR_RPC_DTO K + 0x20B [5] 0x00007F902C736561 _Z20sqlrl_rpc_dms_routerP8sqlrr_cbP23SQLKD_RQST_REPLY_FORMATiP15 SQLR_RPCMESSAGE + 0xC21 [6] 0x00007F902BCAFF2B _Z16sqlrr_rpc_routerP8sqlrr_cb + 0x119B [7] 0x00007F902BCADACE _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xFBE [8] 0x00007F90298413BD /db2home/db2edwp1/sqllib/lib64/libdb2e.so.1 + 0x532C3BD [9] 0x00007F902983FCAA _Z21sqleProcessSubRequestP8sqeAgent + 0x3DA [10] 0x00007F90298734AB _ZN8sqeAgent6RunEDUEv + 0x5AB [11] 0x00007F902D0338F6 _ZN9sqzEDUObj9EDUDriverEv + 0x116 [12] 0x00007F902B683EB8 sqloEDUEntry + 0x578 [13] 0x0000003959807AA1 /lib64/libpthread.so | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Load and XML * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v105fp10 or newer * **************************************************************** | |
Local Fix: | |
No local fix available. Need to upgrade to latest fixpack | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.04.2018 11.07.2018 11.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |