SAP Knowledge Base Article - Preview

2737637 - Diag Log collector holds transaction log open

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

SAP Supply Chain Management 7.0

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.