logo  
Google
 

DB2 SQL-Error: -30030

SQLState: 57012

Short Description: C E SQL EXECUTION FAILED DUE TO UNAVAILABLE RESOURCES THAT WILL NOT AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR 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 reason-code identifies why the resource identified by the resource-type and resource-name is unavailable. The product, product level, and RDB are identified. Values for reason-code This is product specific and can be found in the remote server documentation. Values for resource-type Two byte hexadecimal number defined as follows: This is product specific and can be found in the remote server documentation. Values for resource-name Variable length field with alphanumeric characters and a maximum length of 35 bytes. Values for pppvvrrm Eight-byte field with alphanumeric characters defined as follows: ppp....... DSN for OS/390, ARI for SQL/DS SQL and QSQ for AS/400 (3 bytes) vv........ version number (2 bytes) rr........ release level (2 bytes) m......... modification level (1 byte) Values for rdbname Sixteen-byte field with 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. 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 reason code received.

 <-  BACK TO INDEX