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