[Db2] How to solve transaction log for the databases is full (SQL0964C)

Question & Answer

Question

SQL requests fail with message "The Transaction log for the database is full". How can I solve it?

[message (sample)]

DB21034E The command was processed as an SQL statement because it was not
a valid Command Line Processor command. During SQL processing it returned:
SQL0964C The transaction log for the database is full. SQLSTATE=57011

[db2diag.log output]

FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860 
MESSAGE : ADM1823E 
          The active log is full and is held by application handle "<appl_hdl>". 
          Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.5;9.7;10.1;10.5;11.1;11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

F5086ACC4565317D492577D80019C028

Was this topic helpful?

Document Information

Modified date:
30 April 2025

UID

ibm11074358

Tips