-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name
Explanation
The SQL statement could not be executed because a required resource was not available.
- 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.
When resource-type is 402, the value of resource-name is the z/OS® Security Server return and reason codes for the unavailable resource.
System action
The SQL statement cannot be processed.
If the SQL statement being processed was a cursor FETCH, DB2 closes the cursor. Subsequent attempts to use that cursor without first opening it receive an SQLCODE -501.
Programmer response
Verify the identity of the resource that was not available. To determine why the resource was unavailable, refer to the specified reason-code.
If resource-name identifies the optimum buffer pool, either define the buffer pool with that name or create the table in a table space that is defined with that buffer pool.
SQLSTATE
57011