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.