Unable to BIND: Resource Unavailable

blpraveen123 · New User Joined: 26 Apr 2007 Posts: 12 Location: Mysore

Hi all,
when i try to bind the COBOL-DB2 Program using IKJEFT01 the step return code was 8 and the Bind was unsuccessful the follwing error mesage displayed.

Resource Unavailable
Reason 00D70014
Type 00000220

What is the error?

guptae · Posted: Mon Sep 24, 2007 5:41 pm

Hi there,

Does it show which resource is not availbale?

enrico-sorichetti · Posted: Mon Sep 24, 2007 5:45 pm

posting the full job sysout might be of more help to analyze the failure

regards

e.s

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

Hi praveen,

According to Reason code (00D70014 ) and Resource type (00000220 - VSam dataset ) , the VSAM datasets which is corresponds to your tablespace reached max extents .

Note :

123 - is max extents for single volume VSAM dataset
255 - is Max extents for Multivolume datasets

Please use ISPF 3.4 option , to the check the max extents of the VSAM datasets for the tablespace . You can get the name of the datset from the joblog of your job .

Ask your DBA , to Alter the tablespace with more value of priqty and secqty . After that ask him to REORG the table space also .
This will resove the issue .

Regards
Senthil

Mahesh-Frame · New User Joined: 06 Sep 2007 Posts: 3 Location: Noida

Hi,

The table might have got corrupted.

We had the same issue , and we raised a request to DBA team
to delete and create the table.This time with larger space.

Mahesh

mbr_raja · Posted: Wed Sep 26, 2007 5:29 pm

The problem is due to space is not available within the tablespace of indexspace. You can try to use the option 3.4 and give the underlaying DB2 Vsam dataset and press f11 key (Function key F11). It will show you the free space, number of extents. Check the no. of extents if goes above 251 in both tablespace and indexspace.

The solution to this problem is to do alter tablespace to increasing primary and secondary quantity and do the Reorg utility inorder to reclaim the space.