00C2026B

Explanation

Db2 is unable to obtain a physical lock (P-lock), because another member holding the lock has had logging suspended for an extended amount of time. The logging has been suspended because the active logs are full, or because there is an outstanding SET LOG SUSPEND command.

System action

SQLCODE -904 (resource not available) is returned to the user. This reason code, as well as the resource name, are returned in the cursor table (CT) and made available to the user in the SQLCA.

Problem determination

Check the other members of the data sharing group to find the one that has logging suspended. Then take the appropriate action by either issuing the SET LOG RESUME command or freeing up the active log data sets. Resubmit the failing application after the logging situation is resolved.