DB2 FOR LUW / DB2FORLUW / A50 - DB2

1. Rollforward might fail with the following messages in the 
db2diag.log if the logs are compressed and the number of log 
files required for Rollforward is higher than 264 
 
EDUID   : 8822                 EDUNAME: db2lfr.0 (W1P) 0 
FUNCTION: DB2 UDB, data protection services, 
sqlpgRetrieveStartUse, probe:190 
DATA #1 : <preformatted> 
WARNING: No room for retrieved log number 731930 in 
retrieveArray. Index 18446744073709551615 entryCount 264 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x0900000015C3C4CC pdLogPrintf + 0x28 
  [1] 0x09000000123FC008 
sqlpgRetrieveStartUse__FP14sqlpMasterDbcbUiUsPUlUlPCcCUlT5 + 
0x86C 
  [2] 0x0900000011E09630 
sqlpgOpenLogExtentAndUncompress__FP9SQLP_DBCBPCcPP9SQLP_LECBCUiU 
l + 0x678 
  [3] 0x0900000012400E30 
sqlplfrFMOpenLog__FP12SQLPLFR_DBCBUiP21SQLPLFR_REQ_SCAN_NEXTUlPU 
lPP9SQLP_LECB + 0x15B4 
  [4] 0x0900000011E28434 
sqlplfrFMReadLog__FP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQL 
PLFR_SCAN_DATA + 0x4008 
  [5] 0x0900000015A0F8D0 RunEDU__9sqpLfrEduFv + 0xB38 
  [6] 0x09000000159DD8E4 RunEDU__9sqpLfrEduFv + 0x864 
 
2. Crash recovery might fail with the following: 
 
EDUID   : 33                   EDUNAME: db2lfr.0 (RON) 
FUNCTION: DB2 UDB, data protection services, sqlpRenameStartUse, 
probe:190 
MESSAGE : ZRC=0x071000EA=118489322=SQLPG_EXT_COMPRESSED 
          "Log extent is compressed." 
DATA #1 : <preformatted> 
sqlpRenameStartUse error 
 
EDUID   : 33                   EDUNAME: db2lfr.0 (RON) 
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent, 
probe:7140 
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic 
Error" 
          DIA8526C A fatal error occurred in data protection 
services. 
 
 
EDUID   : 33                   EDUNAME: db2lfr.0 (RON) 
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:390 
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic 
Error" 
          DIA8526C A fatal error occurred in data protection 
services. 
DATA #1 : <preformatted> 
LFR Scan Num            = 3 
LFR Scan Caller's EDUID = 3182 
Open error on log extnum 266. 
 
EDUID   : 33                   EDUNAME: db2lfr.0 (RON) 
FUNCTION: DB2 UDB, data protection services, 
sqlpgRetrieveStartUse, probe:190 
DATA #1 : <preformatted> 
 
WARNING: No room for retrieved log number 266 in retrieveArray. 
Index 18446744073709551615 entryCount 264 
 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x00002B8BC1FA96BA pdLogVPrintf + 0x1B8 
  [1] 0x00002B8BC1FA9ABF pdLogPrintf + 0xF3 
  [2] 0x00002B8BC5DA9C07 
_Z21sqlpgRetrieveStartUseP14sqlpMasterDbcbjtPmmPKctm + 0x1439 
  [3] 0x00002B8BC5EBC676 
_Z18sqlpgOpenLogExtentP9SQLP_DBCBPKcPP9SQLP_LECBjm + 0x482 
  [4] 0x00002B8BC5F4D505 
_Z16sqlplfrFMOpenLogP12SQLPLFR_DBCBjP21SQLPLFR_REQ_SCAN_NEXTmPmP 
P9SQLP_LECB + 0x262F 
  [5] 0x00002B8BC5F2D12A 
_Z16sqlplfrFMReadLogP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQ 
LPLFR_SCAN_DATA + 0x424 
  [6] 0x00002B8BC5F3EEAF 
_Z28sqlplfrPrefetchNextFMReadLogP12SQLPLFR_DBCBmP21SQLPLFR_REQ_S 
CAN_NEXT + 0x117 
  [7] 0x00002B8BC5F38C09 
_Z17sqlplfrDoScanNextP12SQLPLFR_DBCBP11SQLPLFR_REQ + 0x24A5 
  [8] 0x00002B8BC5F3C4D7 _Z10sqlplfrEduP9sqpLfrEdu + 0xB1B 
  [9] 0x00002B8BC6172122 _ZN9sqpLfrEdu6RunEDUEv + 0x90 
  [10] 0x00002B8BC849E80C _ZN9sqzEDUObj9EDUDriverEv + 0x17C 
  [11] 0x00002B8BC849E434 _Z10sqlzRunEDUPcj + 0x26 
  [12] 0x00002B8BC5C2222D sqloEDUEntry + 0x971 
  [13] 0x00002B8BBFDD2193 /lib64/libpthread.so.0 + 0x6193 
  [14] 0x00002B8BCF4F10DD __clone + 0x6D 
 
Conditions to hit this problem: 
In both scenarios 
a) Recovery requires more than 265 logs 
b) Logical logs are compressed 
 
For Crash recovery failure 
 
c) logical logs have been manually copied into the primary path 
(still compressed) and the number of logs is higher than 264 
d) Infinite logging is enabled 
 
 
For rollforward failure 
e) If the overflowlogpath configuration parameter (or the 
"OVERFLOW LOG PATH" on the rollforward command) points to an 
archive log directory that contains compressed archived log 
files and the number of logs is higher than 264.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

DB2 will decompress logs as needed if the number of logs to 
decompress is higher than 264 issue the rollforward/ crash 
recovery again.

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.04.2017
29.09.2017
29.09.2017

9.0.