SAP Knowledge Base Article - Preview

2141933 - DB6: How to initially trouble shoot transaction log full issue

Symptom

The database transaction log gets full. Following errors may show up in system log or db2diag.log file.

  • DIA8309C Log file was full.
  • SQL0964C The transaction log for the database is full
  • ADM1823E The active log is full and is held by application handle "<number>".

You want to do the initial trouble shooting.

Disclaimer

  • This article lists initial steps to trouble shoot transaction log full issue.
  • The data below has to be collected WHILE the problem exists.
  • The data below has to be collected several times (at least 3 times) with certain time interval.


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

SQL0964C, ADM1823E, DIA8309C, TRANSACTION LOG, FULL, ACTIVE LOG , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , How To

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.