Hitachi

Hitachi Advanced Database Messages


KFAA31371-E

The SQL statement cannot be executed because a required resource is locked. (name = aa....aa, object = bb....bb) (M+J+O)

The SQL statement cannot be executed because another SQL statement or command has locked a resource that the SQL statement needs to execute. <SQLSTATE: 52401>

aa....aa: Name of locked resource
  • DBAREA: DB area

  • TABLE: Table

bb....bb: Locked resource to be acquired
  • If aa....aa is DBAREA

    "cc....cc"

  • If aa....aa is TABLE

    "dd....dd"."ee....ee"

cc....cc:

DB area name

dd....dd:

Schema name

ee....ee:

Table name

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Wait for the other SQL statement or command that has locked the resource to terminate, and then re-execute the SQL statement. For details about locked resources acquired during SQL statement and command execution, see Locked resources that are reserved and their lock modes in the HADB Setup and Operation Guide.