DB2 FOR LUW / DB2FORLUW / B50 - DB2

This is a problem when log files are manually copied from
archive to active or overflow log path for ROLLFORWARD
and these log files were compressed during archiving (that
is, the LOGARCHCOMPR1 /LOGARCHCOMPR2 database
configuration parameter is set to YES). In addition, these
log files were archived to different log chain subdirectories.

The following is an example of the corresponding command:
db2 "rollforward db JKL to end of logs overflow log path (
/overflow/log/path ) NORETRIEVE".  The ROLLFORWARD
command fails with SQL1042C error.

The following is sample db2diag.log message associated
with this error.

2019-05-14-03.00.00.225357+120 I2042287E2555         LEVEL:
Error
PID     : 303                  TID : 139937382917888 PROC :
db2sysc 0
INSTANCE: db2jkl               NODE : 000            DB   : JKL
HOSTNAME: hal9001
EDUID   : 406                  EDUNAME: db2logmgr (JKL) 0
FUNCTION: DB2 UDB, data protection services,
sqpLogMgrEdu::sqlpgRetrieveLogFile, probe:6097
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
Error"
          DIA8526C A fatal error occurred in data protection
services.
DATA #1 : String, 105 bytes
Unexpected condition!!! Log chain ID from log file does not
match the expected log chain ID for recovery.
DATA #2 : unsigned integer, 4 bytes
4
DATA #3 : SQLPG_XHDR, PD_TYPE_SQLPG_XHDR, 2048 bytes
Validity Check 1 = 9
Format Version = 14
xhdrAlVersion = V:11 R:1 M:4 F:4 I:a SB:0
Log Extent State = 0x01038011
                                   - SQLPG_State_Init
                                   - SQLPG_State_Retrieved
                                   - SQLPG_State_Closed
                                   -
SQLPG_State_FileEntryNum1_Valid
                                   -
SQLPG_State_FileEntryNum2_Valid
                                   -
SQLPG_State_Registration_Required
Signature = IBMLOG
Partition = 0
Log Stream = 0
Topology Life ID = 1441467570
2015-05-13-03.39.30.000000 GMT
Compression Mode = 0 (OFF)
Segment Size = 0
Extent Number = 142483
Extent Size = 524288
Number of Pages = 9288
Previous Extent ID = 4294967295         SQLPG_IGNORE_PID
Database Log ID = 1298725973
2011-02-26-13.12.53.000000 GMT
Current Extent ID = 1567032133
2019-08-28-22.42.13.000000 GMT
firstLso = 110789652322865 maps to 00006541CC1E4010
minTruncOffset = 110789652322865
fileEntryNum1 = 429751
fileEntryNum2 = 429752
logFileChainId = 5

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5 m3 fp0 or later                          *
****************************************************************

not known / see Local fix

forerunner  : IT30257 
follow-up : 

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

12.09.2019
24.04.2020
24.04.2020