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.
SAP Knowledge Base Article - Preview