DSNT501I csect-name RESOURCE UNAVAILABLE
CORRELATION-ID = correlation-id
CONNECTION-ID = connection-id
LUW-ID = luw-id
REASON = reason-code
TYPE = resource-type
NAME = resource-name
Explanation
The requested function requires a resource that is unavailable. This message is issued with other messages that identify the system action and the action that the installer or operator should take.
In some cases, Db2 can recover from this situation where a resource is not available and can complete successfully. One example is during the setup of a performance enhancement during bind time for execution time. If Db2 recovers successfully, no action is necessary.
- correlation-id
- The correlation identifier of the thread that is associated with the requester of the resource.
- connection-id
- The connection identifier of the requester.
- luw-id
- The logical-unit-of-work identifier (LUW-ID) of the thread that is associated with the requester of the resource. An asterisk (*) indicates that the thread does not have a LUW-ID. If the LUW-ID is not an asterisk, the value is a logical-unit-of-work-id that is assigned to the thread. This value is followed by an equal sign (=) and a token value, which can be used in place of logical-unit-of-work-id in any Db2 command that accepts logical-unit-of-work-id as input.
- reason-code
- The reason code that tells why the resource is unavailable.
- 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.
For some situations, Db2 issues message DSNT501I one time and then suppresses it until the resource becomes available again. Examples include the following situations:
- For REASON=00c90090, DSNTI501 is suppressed at the Db2 subsystem level until a lock request is accepted for the page set or partition.
- For TYPE=905, REASON=00C90092, and NAME=IRLM, DSNTI501 is suppressed at the Db2 subsystem level until the IRLM out-of-storage condition is relieved.
- For REASON=00C900E2 or 00C900E3, DSNTI501 is suppressed for the current page set or partition until a successful OPEN occurs.
- For REASON=00C90081.
Operator response
Note the values for reason-code, resource-type, and resource-name.
System programmer response
Look up the reason code for more information about why the resource was unavailable and possible actions to correct the problem. For example, if the reason code is 00C900A6, you must migrate the catalog to the current release. To do so, run DSNTIJTC.
Problem determination
- 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.