DSNT500I csect-name RESOURCE UNAVAILABLE REASON reason-code TYPE resource-type NAME resource-name

Explanation

The requested function requires a resource that is currently unavailable.

csect-name
The name of the control section that issued the message.
reason-code
The Db2 reason code value that indicates the reason for the failure. For explanations of reason codes, see Db2 reason codes.
resource-type and resource-name
The type and name of the resource that the message identifies. For an explanation of resource-type and resource-name values, see Resource types.

System action

Additional messages and codes are issued to identify the system action and the action that should be taken by the installation or operator.

Operator response

Use the reason-code, resource-type, and resource-name values provided in the message to identify the source of the problem.

Problem determination

Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.

If resource-type is X'D00' or X'D01', use the following SQL statement to determine the table name:

SELECT CREATOR, NAME
   FROM SYSIBM.SYSTABLES
   WHERE DBID = dbid AND OBID = obid;

This statement can either fail or return an incorrect name if the table has been dropped.