SAP Knowledge Base Article - Preview

3585136 - DB6: "Log needed for read is no longer in the active log space."

Symptom

The db2diag.log reports the following error

2025-03-10-06.29XXXXXXXXXXXXXXXXX       LEVEL: Error
PID     : XXXXX           TID : 50000         PROC : db2sysc 0
INSTANCE: XXXXXX             NODE : 000           DB   : XXXX
APPHDL  :XXXXX         APPID: XXXXXXXXXXXXXXXXXXXXXXX
UOWID   : XXXXX                ACTID: X              
AUTHID  : XXXXXX             HOSTNAME:XXXXXX
EDUID   : XXXX                EDUNAME: db2agent (XXXXX) 0
FUNCTION: DB2 UDB, data protection services, sqlpgrlgSearchSharedReadBufferAndActiveLogs, probe:XXXX
MESSAGE : ZRC=0x82100101=-2112880383=SQLP_LOG_NOT_ACTIVE
 "Log needed for read is no longer in the active log space."
DATA #1 : String, 50 bytes
iLookForLso / lookForLso / logStreamId / ownerTid:
DATA #2 : unsigned integer, 8 bytes
XXXXXXXXXXXXXXXX
DATA #3 : unsigned integer, 8 bytes
XXXXXXXXXXXXXXXXX
DATA #4 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
X
DATA #5 : SQLP_DBTID, PD_TYPE_SQLP_DBTID, 16 bytes
XXXXXXXXXXXXXXXXXXXXX

2025-03-10-06.29XXXXXXXXXXXXXXXXX       LEVEL: Error
PID     : XXXXX           TID : 50000         PROC : db2sysc 0
INSTANCE: XXXXXX             NODE : 000           DB   : XXXX
APPHDL  :XXXXX         APPID: XXXXXXXXXXXXXXXXXXXXXXX
UOWID   : XXXXX                ACTID: X            
AUTHID  : XXXXXX             HOSTNAME:XXXXXX
EDUID   : XXXX               EDUNAME: db2agent (XXXXX) 0
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, probe:XXXX
MESSAGE : ZRC=0x82100101=-2112880383=SQLP_LOG_NOT_ACTIVE
"Log needed for read is no longer in the active log space."


Read more...

Environment

Db2 LUW 11.5

Keywords

logging, log stream, log_dir, active log, directory, buffer, read, missing. , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.