-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.
When reason-code is 00E7000E and
resource-type is 00001080, SQLCODE -904 was issued by IBM® Db2 Analytics Accelerator for z/OS, and resource-name is
message text from the accelerator that indicates the cause of the failure.
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
Collect a listing of the
SYSLOG data set for the period of time that spans the failure. Search the SYSLOG data set for
messages that are related to the error.
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.
If SQLCODE -904 was issued by IBM Db2 Analytics Accelerator for z/OS, contact IBM Support for IBM Db2 Analytics Accelerator for z/OS, and provide them with the
resource-name message text.
SQLSTATE
57011