MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

To get number or % of extents left of a VSAM file.

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
baansal
Beginner


Joined: 05 Jun 2007
Posts: 5
Topics: 4
Location: bangalore

PostPosted: Mon Jun 25, 2007 1:46 am    Post subject: To get number or % of extents left of a VSAM file. Reply with quote

Could you please help me out from the problem.

I am using LISTC for getting the properties of the VSAM file in SYSOUT in JCL. It is giving all the information allocated to the that VSAM file like allocated extents, storage, primary and secondary storage etc.

But my problem is that I want to get the information on the number of extent left or % left and also storage left or % storage left for the particular VSAM file.


Thanks (in advance)
_________________
Cheers
----------
Baansal
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Mon Jun 25, 2007 7:12 am    Post subject: Reply with quote

baansal,

If your shop has File-aid then from the main menu of file-aid

1. select
Code:

3     UTILITIES      - File-AID/SPF extended utilities

2. on the next screen select
Code:

5     VSAM             - Allocate, display,

3. on the next screen give the vsam cluster name and press ENTER

4. On the next screen press ENTER once again and on the right side you will see the percentage allocated/used

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
baansal
Beginner


Joined: 05 Jun 2007
Posts: 5
Topics: 4
Location: bangalore

PostPosted: Mon Jun 25, 2007 7:31 am    Post subject: Reply with quote

Hi Kolusu,


I appreciated your answer, but as i have written, i need to show the required information in the sysout dataset of the JCL. I need to get the information through JCL.
_________________
Cheers
----------
Baansal
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Mon Jun 25, 2007 7:57 am    Post subject: Reply with quote

baansal,

Search for the following fields in your Listcat output

Code:

High Used RBA      = HI-U-RBA
High Allocated RBA = HI-A-RBA


The formula for calcuating the VSAM Percent free is

Code:

(High Allocated RBA - High Used RBA) \ High Allocated RBA.


The formula for calcuating the VSAM Percent used is

Code:

High Used RBA \ High Allocated RBA.


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group