MVSFORUMS.com

Siddheart22 · Posted: Tue Aug 16, 2005 6:03 pm Post subject: DSNT500I

Hi,

When I try to BIND my COBOL-DB2 program, the program fails with the following error:
DSNT500I RESOURCE UNAVAILABLE
TYPE: 00000801

The reason in the error describes the problem as DEADLOCK, but this is development environment and I am certain of no one using this database.

I tried to access same tables through the QMF and I could, which implies that actually the resource is available.

I checked the table status and its in READ/WRITE status, which looks good to me.

I was able to BIND my program till yesterday, and now, I can't resolve this error. Could someone please advice?

Hoping for some quick assistance.
Cheers,
Sid.

kolusu · Posted: Tue Aug 16, 2005 6:22 pm Post subject:

siddheart22,

It would have helped if you also posted the reason code. It is not your Table which is unavailable , it is your PACKAGE that is not available. TYPE: 00000801 is related to packages.

Do you have Explain(YES) on your Bind card? If so make sure that you have the plan table existed before binding the program. Just check if your plan table is dropped.

Also try binding with EXPLAIN(NO) and see if it works . Btw what is your DB2 version?

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Siddheart22 · Posted: Wed Aug 17, 2005 11:04 am Post subject:

Here is the complete error with the reason code.

DSNT500I -DDD2 DSNTBCM2 RESOURCE UNAVAILABLE
REASON 00E30083
TYPE 00000801

By the way, the problem got resolved on its own. Smile

Best Regards,