Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Unable to BIND: Resource Unavailable

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
blpraveen123
Currently Banned

New User


Joined: 26 Apr 2007
Posts: 12
Location: Mysore

PostPosted: Mon Sep 24, 2007 5:40 pm    Post subject: Unable to BIND: Resource Unavailable
Reply with quote

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?
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Sep 24, 2007 5:41 pm    Post subject:
Reply with quote

Hi there,

Does it show which resource is not availbale?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10255
Location: italy

PostPosted: Mon Sep 24, 2007 5:45 pm    Post subject: Reply to: Unable to BIND.
Reply with quote

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

regards

e.s
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Tue Sep 25, 2007 10:44 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Mahesh-Frame

New User


Joined: 06 Sep 2007
Posts: 3
Location: Noida

PostPosted: Tue Sep 25, 2007 12:24 pm    Post subject:
Reply with quote

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
icon_biggrin.gif
Back to top
View user's profile Send private message
mbr_raja

New User


Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India

PostPosted: Wed Sep 26, 2007 5:29 pm    Post subject: Reply to: Unable to BIND: Resource Unavailable
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Limit CICS CPU resource vasanthz CICS 0 Tue Jan 31, 2017 7:09 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us