-30040 EXECUTION FAILED DUE TO UNAVAILABLE RESOURCES THAT WILL NOT AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR 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 product identifier (PRDID) value is an 8-byte character value in pppvvrrm format, where: ppp is a 3-letter product code; vv is the version;rr is the release; and m is the modification level. In Db2 12 for z/OS®, the modification level indicates a range of function levels:
  • DSN12015 for V12R1M500 or higher.
  • DSN12010 for V12R1M100.
Start of changeFor more information, see Product identifier (PRDID) values in Db2 for z/OS.End of change
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 identify 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

57012