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.