|
View previous topic :: View next topic
|
| Author |
Message |
j_prameela2000
New User
.jpg)
Joined: 01 Jun 2005
Posts: 28
Location: Chennai
|
|
|
|
While I am compiling a CICS-COBOL-DB2 program I am getting return code as 8 and the error is in Binding where it shows the message as
DSNT500I - AD2 DSNTBCM2 RESOURCE UNAVAILABLE.
Please tell me why this error occurs.
When I execute the query in spufi for the same table that is used in the program, I am getting as 0 rows selected and with the sqlcode as -911 (deadlock or timeout).
Why is it so?
Please tell me why this error occurs. |
|
| Back to top |
|
 |
kvivek
New User
.jpg)
Joined: 09 May 2005
Posts: 51
Location: Singapore
|
|
|
|
There are two reasons
1) Some other user has locked the table explicitly
2) Tablespace or Index could be in check/copy pending
Regards,
Vivek |
|
| Back to top |
|
|
bonniem
New User
Joined: 09 Aug 2005
Posts: 67
|
|
|
|
| It could also happen if the query is too complex and uses many temporary tables (select as <name>). Also please make sure you have the where predicates in the order of the indexes. |
|
| Back to top |
|
|
j_prameela2000
New User
Joined: 01 Jun 2005
Posts: 28
Location: Chennai
|
|
|
|
Hi kvivek and bonniem,
Thanks.
Regards, |
|
| Back to top |
|
|
|
|
