Troubleshooting
Problem
How to capture SQL1224 error code in your DB2 environment.
Symptom
On some occasions, DB2 may report SQL1224N when performing an insert, update or a delete on a database table causing the operation to terminate and the transaction to be rolled back. In these cases, DB2 will not write a message in the db2diag.log when this error is generated which makes diagnosing the problem a little bit harder for the DBA. Below is the description for SQLCODE -1224:
SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032
SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","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.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.7, 9.5, 10.1, 10.5
Operating system(s):
AIX, HP-UX, Linux, Solaris
Document number:
525495
Modified date:
01 May 2025
UID
swg21695711
Manage My Notification Subscriptions