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
 

 

How to find out how much free space is left in a vsam file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Fri Oct 30, 2009 2:33 am    Post subject: How to find out how much free space is left in a vsam file
Reply with quote

I am trying to find out the amount of space used so far and the amount of space left in case of a vsam file.

Please let me know how to determine that.
Back to top
View user's profile Send private message

Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Fri Oct 30, 2009 2:47 am    Post subject:
Reply with quote

After the file is CLOSED, run a LISTCAT and check the difference in HARBA and HURBA amounts.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Oct 30, 2009 2:49 am    Post subject:
Reply with quote

Hello,

How might this be a jcl question?

You might do a bit of research on LISTDSI. . . The forum search would be a good place to start.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8054
Location: East Dubuque, Illinois, USA

PostPosted: Fri Oct 30, 2009 3:08 am    Post subject:
Reply with quote

The High Allocated RBA (HARBA) in a LISTCAT output gives the number of bytes allocated (technically, the offset to the highest allocated byte). The High Used RBA (HURBA) in a LISTCAT output gives the offset of the highest used byte; the difference is the amount of free space in the file. Is the free space usable? Good question with no easy answer. Maybe -- depending on (average) record length, CI size, CI free space percentage and CA free space percentage. Worst case is that none of the free space is usable -- for example, the record length is 1050 bytes (fixed), the CI size is 4096 and the CI free space percent is 20 percent -- which gives just over 800 bytes per CI free but it is not enough to write a record so none of the free space will be used.

The "amount of space left" in a VSAM file depends -- potentially a VSAM file can be 4 GB if not extended format, much larger if extended format. But the actual amount of space left (i.e., potentially allocatable space) can be affected by the number of extents already used, the number of disk packs the file is on, how many disk packs are candidate volumes, and so forth.

There is an excellent redbook on VSAM called VSAM Demystified that is well worth the time to go through.
Back to top
View user's profile Send private message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Fri Oct 30, 2009 4:19 am    Post subject: Reply to: How to find out how much free space is left in a v
Reply with quote

thanks a lot for the help on this topic. Also i apologize for posting the question in the section.
Back to top
View user's profile Send private message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Fri Oct 30, 2009 4:19 am    Post subject: Reply to: How to find out how much free space is left in a v
Reply with quote

Wrong section
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8054
Location: East Dubuque, Illinois, USA

PostPosted: Fri Oct 30, 2009 4:45 am    Post subject:
Reply with quote

Glad to hear it helped -- and I've moved the topic.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 11 Tue May 16, 2017 2:20 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am


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