DB2 - Problem description
Problem IT23032 | Status: Closed |
DB2 MIGHT TRY TO READ LOG RECORDS THAT DO NO LONGER EXIST AFTER LOG FILE TRUNCATION | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
It may happen that Db2 wants to perform a rollback with the use of log records that no longer exist: 2017-09-21-10.30.43.537525+000 I73458A13104 LEVEL: Error PID : 9175218 TID : 105437 PROC : db2sysc 0 INSTANCE: db2jkl NODE : 000 DB : JKL APPHDL : 0-37321 APPID: 165.131.135.142.29701.170921103031 AUTHID : SAPR3 HOSTNAME: server EDUID : 105437 EDUNAME: db2agent (JKL) 0 FUNCTION: DB2 UDB, data protection services, sqlptudo, probe:1010 MESSAGE : ZRC=0x87100048=-2028994488=SQLP_BADLSO "Invalid LSO value." DIA8546C An invalid log sequence offset (LSO), the value was "". DATA #1 : String, 34 bytes undolso / TEntryp / agtCB / dpsAcb DATA #2 : unsigned integer, 8 bytes 108027041854878 DATA #3 : SQLP_TENTRY, PD_TYPE_SQLP_TENTRY, 11856 bytes pSuccTid = a000204af104280 pPrevTid = a000204af01ba80 succ_lsn = 0 pre_lsn = 0 succ_undoLsn = 0 pre_undoLsn =0 logSpace = 1736 ICushionContribution = 0 logSpaceSaved = 0 extraReserved = 18264 totalReservedLogSpace = 246943 mrtPenlist Address = 0 Pending List Address = 0 Pending List End Address = 0 First Pending list entry for update MRT = 0 tsp_to_repair = 0 tsp_repaired = 0 Table Space List Address = 0 Transaction Entry State = 6: SQLP_TSAVEPOINT tflag = 00000000 tflag2 = 00000200 The root cause for this issue is unknown. This APAR will add debugging code that provide additional information for future root cause analysis. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 10.5 FP 10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT23033 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.11.2017 12.07.2018 12.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |