Symptom
The transaction log is either full with a DIA8309C error code, or monitoring of the log space shows the transaction log growing unexpectedly
2019-01-01-01.01.01.521852-300 I44283044E592 LEVEL: Error
PID : 12345 TID : 140574002767616 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-123 APPID: 10.96.10.1.21162.190103190446
AUTHID : SAPSID HOSTNAME: dbhostname
EDUID : 454 EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteLR, probe:6680
MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log File has reached its saturation point"
DIA8309C Log file was full.
After analysis from KBA 2141933 you find that the oldest application is
DB2ATS-Task: SAPTOOLS.DBH_DIAG_LOG_COLLECT
This application can be showing in a UOW Waiting or UOW Executing status
Optionally:
You may see that the db2sysc is consuming 100% of the CPU
Read more...
Environment
DB2 10.1 GA through DB2 10.1FP2
Product
Keywords
DBH_DIAG_LOG_COLLECT, DIA8309C, log full , 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.