IBM Support

Log Gap between Primary and Standby

Troubleshooting


Problem

After a recycle on DB2 instance, Standby and Primary lost synch on the logging, causing a huge log gap between the servers.

Symptom

Check for db2diag.log to observe messages such as:

2015-11-16-10.28.38.221177-360 I17311256866A831     LEVEL: Info
PID     : 10944996             TID : 5913           PROC : db2sysc 0
INSTANCE: db2inst1              NODE : 000           DB   : GDGPDB1
HOSTNAME: hostnameex
EDUID   : 5913                 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMReadLog, probe:1000
DATA #1 : SQLPLFR_SCAN_ID, PD_TYPE_SQLPLFR_SCAN_ID, 8 bytes
LFR Scan Num            = 4
LFR Scan Caller's EDUID = 14137
MESSAGE : lfrScanStartLso past last page of truncated log setting
          SQLPLFR_SNO_START_AFTER_TRUNCPAGE.
DATA #2 : String, 71 bytes
lfrScanStartLso / pageLso / lfrScanNextFlagsOut (prior to setting flag)
DATA #3 : unsigned integer, 8 bytes
2752448411626
DATA #4 : unsigned integer, 8 bytes
2752448411625
DATA #5 : Hex integer, 8 bytes
0x0000000000000000

2015-11-16-10.28.38.221712-360 I17311257698A639     LEVEL: Info
PID     : 10944996             TID : 5913           PROC : db2sysc 0
INSTANCE: db2inst1              NODE : 000           DB   : GDGPDB1
HOSTNAME: hostnameex
EDUID   : 5913                 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrDoScanNext, probe:2400
DATA #1 : SQLPLFR_SCAN_ID, PD_TYPE_SQLPLFR_SCAN_ID, 8 bytes
LFR Scan Num            = 4
LFR Scan Caller's EDUID = 14137
MESSAGE : HADR: finished disk scan, next pages read from memory
DATA #2 : String, 26 bytes
lfrReadBeforeAfterXhdrFlag
DATA #3 : Hex integer, 8 bytes
0x0000000000000000

2015-11-16-10.28.38.222118-360 I17311258338A833     LEVEL: Info
PID     : 10944996             TID : 5913           PROC : db2sysc 0
INSTANCE: db2inst1              NODE : 000           DB   : GDGPDB1
HOSTNAME: hostnameex
EDUID   : 5913                 EDUNAME: db2lfr.0 (DB1) 0
FUNCTION: DB2 UDB, recovery manager,
sqlplfrDoScanNextForHadrRemoteLogs, probe:4000
DATA #1 : SQLPLFR_SCAN_ID, PD_TYPE_SQLPLFR_SCAN_ID, 8 bytes
LFR Scan Num            = 4
LFR Scan Caller's EDUID = 14137
MESSAGE : HADR: Received log gap, reading from disk.
DATA #2 : unsigned integer, 8 bytes
2752448411626
DATA #3 : unsigned integer, 8 bytes
2752539951808
DATA #4 : unsigned integer, 8 bytes
22458
DATA #5 : unsigned integer, 8 bytes
2752448408925
DATA #6 : unsigned integer, 8 bytes
2752448413001
DATA #7 : Hex integer, 8 bytes
0x0000000000106008

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - HADR","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21971335

Page Feedback