Start of change

-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
Modification (m) values have the following meanings:
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

End of change