+904 A RESOURCE IS UNAVAILABLE BUT PROCESSING CONTINUES. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name
Explanation
A resource was unavailable, but the processing of the SQL statement continues.
- 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
- The type of resource that the message identifies. For an explanation of the resource-type value, see Resource types..
- resource-name
- The name of the resource that the message identifies.
The value in resource-name depends on the remote server source of SQLCODE +904. See the following notes for more information.
- 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
reason for the SQL code.
IBM Db2 Analytics Accelerator for z/OS can return SQLCODE +904 on an SQL OPEN for certain accelerated queries when the CURRENT QUERY ACCELERATION WAITFORDATA special register is used to specify a delay wait time for the query. See the IBM Db2 Analytics Accelerator for z/OS documentation for information about when SQLCODE +904 is returned for an accelerated query.
System action
Processing of the SQL statement continues.
When SQLCODE +904 is issued by IBM Db2 Analytics Accelerator for z/OS, processing of the SQL statement continues on the accelerator.
Programmer response
No programmer response is needed.
See the IBM Db2 Analytics Accelerator for z/OS documentation for more information about the situations that can result in SQLCODE +904 being issued.
SQLSTATE
01687
