DB2 SQL-Error: -30041

Short Description: EXECUTION FAILED DUE TO UNAVAILABLE RESOURCES THAT WILL AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS AND SQL STATEMENTS REASON TYPE OF RESOURCE RESOURCE NAME PRODUCT ID RDBNAME

The SQL statement or command requires a non RDB resource that is currently unavailable. The identifies why the resource identified by the and is unavailable. The product, product level, and RDB are identified. Values for Four byte binary number that is product specific. This can be found in the remote server documentation. Values for Two byte hexadecimal number that is product specific. This can be found in the remote server documentation. Values for Variable length field with alphanumeric characters and a maximum length of 35 bytes. Values for Eight byte field with alphanumeric characters defined as follows: ppp....... DSN for DB2, ARI for SQL/DS, SQL for OS/2 and QSQ for AS/400 (3 bytes) vv........ version number (2 bytes) rr........ release level (2 bytes) m......... modification level (1 byte) Values for Sixteen byte field with the RDBNAME.System action: The statement cannot be executed. 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. Collect the following diagnostic items to help determine the cause of the unavailable resource. v Console output from the system identified by RDBNAME, and a listing of SYSLOG data set for the period of time spanning the failure. v Information described for the received.

 <-  BACK TO INDEX