Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Calculation of free space available in a VSAM File

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

Active User


Joined: 14 Dec 2008
Posts: 103
Location: India

PostPosted: Fri May 21, 2010 10:22 am    Post subject: Calculation of free space available in a VSAM File
Reply with quote

Hi All,

We have a set of many VSAM files in our application. There will be online and batch updates to these VSAM files everyday. I am assigned to develop a tool or a job which can tell the percentage of space the VSAM file has used.

I found a post in IBMMAINFRAMES that the below formula from the information from IDCAMS for a VSAM file:

(HI-U-RBA/HI-A-RBA)*100

gives the usage percentage. But this will give the usage for one extent only. Can someone please let me know how to go about finding the exact way to approach this? I apologize if this is a repost, i didnt find a previous post on this.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri May 21, 2010 11:43 am    Post subject:
Reply with quote

Why do you say that the statistics are for one extent only
Back to top
View user's profile Send private message
hiravibk
Warnings : 1

Active User


Joined: 14 Dec 2008
Posts: 103
Location: India

PostPosted: Fri May 21, 2010 11:59 am    Post subject: Reply to: Calculation of free space available in a VSAM File
Reply with quote

I checked with the Storage management group here and this is the reply I got from them. They were not very generous to let me know how exactly to go about the approach icon_smile.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri May 21, 2010 12:03 pm    Post subject:
Reply with quote

Then all I can say is that your storage management should not be allowed to manage the storage environment.
In fact they do not sound bright enough to be allowed to go to the toilet unsupervised.

Take a good look at the output from a listcat and see what you can find.
Back to top
View user's profile Send private message
hiravibk
Warnings : 1

Active User


Joined: 14 Dec 2008
Posts: 103
Location: India

PostPosted: Fri May 21, 2010 12:16 pm    Post subject: Reply to: Calculation of free space available in a VSAM File
Reply with quote

Hi expat,

So are you saying that the formula that I have given is correct for a KSDS VSAM file?

Below is the LISTCAT info for one of the files:

Code:
IDCAMS  SYSTEM SERVICES                                     
       SPACE-TYPE------CYLINDER     HI-A-RBA-----12510904320
       SPACE-PRI-----------1100     HI-U-RBA-----12432752640
       SPACE-SEC------------550                             


Please let me know if I need to consider any other options from LISTCAT. I also need to add that a REORG is done on a weekly basis to all the VSAM files in our system.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2442
Location: Netherlands, Amstelveen

PostPosted: Fri May 21, 2010 12:29 pm    Post subject:
Reply with quote

Redbook "VSAM Demystified" will give you some nice information.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri May 21, 2010 12:45 pm    Post subject:
Reply with quote

It's the very same one that I have used for 20+ years with no problems.

As for reorganising the file on a weekly basis - is it really worth it. Almost certainly not from a performance view. Possibly from a space reclamation view.
Back to top
View user's profile Send private message
hiravibk
Warnings : 1

Active User


Joined: 14 Dec 2008
Posts: 103
Location: India

PostPosted: Fri May 21, 2010 12:52 pm    Post subject: Reply to: Calculation of free space available in a VSAM File
Reply with quote

Thanks expat, I will go ahead and use the same formula.
Thank you Peter for the document, it looks really good.

Code:
STATISTICS                                             
  REC-TOTAL---------916195     SPLITS-CI----------13333
  REC-DELETED-------169187     SPLITS-CA------------290
  REC-INSERTED------369899     FREESPACE-%CI---------15
  REC-UPDATED------2679357     FREESPACE-%CA---------15
  REC-RETRIEVED--655260325     FREESPC--------288489472
  USER-DATA-SIZE-----------------------------1191053500

Code:
STATISTICS                                             
  REC-TOTAL------------694     SPLITS-CI------------290
  REC-DELETED------------0     SPLITS-CA--------------6
  REC-INSERTED-----------0     FREESPACE-%CI----------0
  REC-UPDATED---------2760     FREESPACE-%CA----------0
  REC-RETRIEVED---------69     FREESPC-----------428032


I also see two 'FREESPC' in the listcat entry. Will this parameter help in anyway or is it something else. Also, I am confused why we have two entries with different values for this.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2442
Location: Netherlands, Amstelveen

PostPosted: Fri May 21, 2010 12:56 pm    Post subject:
Reply with quote

I guess one is for the data component and one is for the index component?
Back to top
View user's profile Send private message
hiravibk
Warnings : 1

Active User


Joined: 14 Dec 2008
Posts: 103
Location: India

PostPosted: Fri May 21, 2010 4:29 pm    Post subject: Reply to: Calculation of free space available in a VSAM File
Reply with quote

I have not worked on REXX, can comeone help me with the REXX code for this.

Thanks!
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri May 21, 2010 4:48 pm    Post subject: Re: Reply to: Calculation of free space available in a VSAM
Reply with quote

hiravibk wrote:
I have not worked on REXX, can comeone help me with the REXX code for this.
Well, that is rather a little handicap - not having worked with REXX before.

At the top of the CLIST / REXX forum is a sticky with links to all of the manuals that you are likely ever to need for REXX. Have a read and a try yourself and we will be happy to help those that try to help themselves.
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 Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us