SAP Knowledge Base Article - Preview

2886759 - DB6: ADM1822W error holding transaction log open

Symptom

  • Transaction log utilization continues to grow or may be full
  • ADM1822W can halt log archiving resulting in log_dir file system space filling up
  • System performance is degraded
  • db2diag.log is filled with ADM1822W error messages:

2020-01-01-01.01.15.692003-180 E849055802E620 LEVEL: Warning
PID : 17730 TID : 139947956758272 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-1234 APPID: 10.27.0.0.55144.200114180329
UOWID : 707777 ACTID: 3
AUTHID : SAPSID HOSTNAME: db2hostname
EDUID : 5565 EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:1660
MESSAGE : ADM1822W The active transaction log is being held by dirty pages.
Database performance may be impacted.


Read more...

Product

SAP NetWeaver 7.5

Keywords

ADM1822W , dirt pages , KBA , BC-DB-DB6-DBA , Database Administration , 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.