Symptom
During the backup runtime a transaction log full issue occurs.
The db2diag.log shows there is no space available.
2025-08-01-22.40.17.000000000000000000 LEVEL: Error
PID : XXXX TID : 10000000000000 PROC : db2sysc 0
INSTANCE: db2<sid> NODE : 000 DB : <SID>
APPHDL : 0-XXXXX APPID: *LOCAL.db2<sid>xxxxxxxxxxx
UOWID : X ACTID: XX
AUTHID : DB2<SID> HOSTNAME: xxxxxxxxxxxx
EDUID : 0000 EDUNAME: db2agent (<SID>) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, probe:XXXX
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
and/or
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::incrementCurrentInvocation, probe:1000
MESSAGE : ZRC=0xFFFFFC3C=-964
SQL0964C The transaction log for the database is full.
Read more...
Environment
Db2 LUW IBM
Keywords
reorganisation, activity, maintenance, when to reorg, table, index, large, long running, hours, duration, longer, performance, NUM_LOG_SPAN, MAX_LOG, ROLLBACK, RESTART , 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