-30041 EXECUTION FAILED DUE TO UNAVAILABLE RESOURCES THAT WILL AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS AND SQL STATEMENTS. REASON reason-code TYPE OF RESOURCE resource-type RESOURCE NAME resource-name PRODUCT ID product-identifier RDBNAME rdbname
Explanation
The SQL statement or command requires a non-RDB resource that is currently unavailable.
- 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.
- product-identifier
- An alphanumeric string that identifies the
product.The format of product identifier values is pppvvrrm, where ppp is a 3-letter product code (such as DSN for DB2), vv is the version, rr is the release, and m is the modification level. For example, DSN10015 identifies DB2 10 in new-function mode, the value is ‘DSN10015'. The product code (ppp) is one of the following values:
- AQT for IBM® DB2 Analytics Accelerator for z/OS®
- ARI for DB2 Server for VSE & VM
- DSN for DB2 for z/OS
- JCC for IBM Data Server Driver for JDBC and SQLJ
- QSQ for DB2 for i
- SQL for DB2 for Linux, UNIX, and Windows
- 0 - 1
- Modification levels in conversion and enabling-new-function mode from DB2 Version 8 (CM8, CM8*, ENFM8, and ENFM8*)
- 2 - 3
- Modification levels in conversion and enabling-new-function mode from DB2 9 (CM9, CM9*, ENFM9, and ENFM9*)
- 4
- Not used.
- 5 - 9
- Modification levels in new-function mode.
- rdbname
- A sixteen-byte string that identifies the RDBNAME.
System action
The statement cannot be processed. The local DB2 is disconnected from the remote server.
Programmer response
Verify the identity of the resource that was not available. The reason the resource is unavailable is identified by the reason-code value:
Collect
the following diagnostic items to help determine the cause of the
unavailable resource.
- Console output from the system identified by RDBNAME, and a listing of SYSLOG data set for the period of time spanning the failure.
- Information described for the reason code received.
SQLSTATE
57013