SAP Knowledge Base Article - Preview

2886759 - DB6: ADM1822W error holding transaction log open

Symptom

  • Transaction log utilization continues to grow or may be full
  • 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...

Environment

[Enter your Environment here...]

Product

SAP NetWeaver 7.5

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.