Question & Answer
Question
「トランザクション・ログがいっぱいです」というエラーが表示され SQL 処理が失敗します。対応方法について教えてください。
[エラー・メッセージ出力例]
DB21034E コマンドが、有効なコマンド行プロセッサー・コマンドではないため、SQLステートメントとして処理されました。SQL処理中に、そのコマンドが返されました。
SQL0964C データベースのトランザクション・ログがいっぱいです。 SQLSTATE=57011
[db2diag.log の出力例 (抜粋)]
MESSAGE: ADM1823E The active log is full and is held by application handle "番号".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.
RETCODE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
"Log file has reached its saturation point"
DIA8309C Log file was full.
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmcAAE","label":"Recovery-\u003ELogging"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
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
jpn1J1003917