IBM Support

Detail about the lock holder on SQL0913 failures

News


Abstract

Detail about the lock holder on SQL0913 failures

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Database Engineer (DBE) Enhancements > Detail about the lock holder on SQL0913 failures

Additional detail will appear in the joblog for some SQL0913 failures

The CPD6DEF diagnostic message contains detail about the lock holder and will appear just prior to the SQL0913.

Use this message to identify to lock holder for failed ALTER TABLE, DELETE, INSERT, UPDATE, MERGE, SELECT INTO, & VALUES INTO statements

Example:

image-20200117131403-1

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11167922