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).
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.
