how to calculate used space(cylinders) in vsam and ps file

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

hi ,

I am trying to find out used cylinders in one of my vsam file, for this I am looking into listcat entries.

but I am not able to calculate the exactly used cylinders in that file. Could any one please help me out with calculaton.

below are few details from listcat entries.
allocated cylinders:

Bill O'Boyle · Posted: Fri Mar 08, 2013 9:50 am

Download IBM Redbook VSAM Demystified -

www.redbooks.ibm.com/abstracts/sg246105.html

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

hi bill,

thanks for your link,

I am going thru it but not getting exact formula for used space calculation, can you please provide me formula for used cylinders in vsam file using provided information in my first post.

thanks ,
pavan

Anuj Dhawan · Posted: Fri Mar 08, 2013 12:06 pm

You'll do a lot good for yourself if you get enganged with that manual, however, here is a shortcut:

www.talsystems.com/tsihome_html/techcorner.html

Bill Woodger · Posted: Fri Mar 08, 2013 1:02 pm

Pavankumar.m,

Why do you want to do this for a VSAM file?

Do you, like your title, what to do it for a PS as well? Why? What problem do you have?

expat · Posted: Fri Mar 08, 2013 1:11 pm

The formula I use is, and is reasonably accurate

(HURBA / HARBA) = ratio used
total cyls * ratio used = actual used

HERE is a link to a REXX solution if you have lots of files to look at

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

hi bill,

In my shop we were allocated many files with cylinder space, irrespective of how much actually needed,

due to this we were getting dasd space issue.
here im trying to calculate actual cylinders used by each of the file.
so that I can reallocate those files.

in my shop we use mostly vsam files more , so I specfied the vsam in my post.

thanks,
pavan.

expat · Posted: Fri Mar 08, 2013 1:59 pm

You may wish to discuss this problem with your storage management team, perhaps to use free space release for files that are grossly over allocated.

Why use readily available automatic solutions when you can waste time and do it manually

Pavankumar.m · New User Joined: 28 Nov 2010 Posts: 53 Location: Mumbai

hi expat,

I followed your formula as below.

file attributes:-
space -pri : 1
space-sec : 10

max-lrecl: 14000
total rec: 7

hi-a-rba: 829440
hi-u-rba: 829440

using above listcat entries I did below falcon:

total cylinders allocated: 1+10*15 :151

hurba/harba :ratio
829440/829440 : 1

used cylinders: 1 * 151 : 151 cyls

in my input file I have only 7 records. I don't think 7 records can use this much space.

please correct me if my calculation is wrong..if wrong please provide me correct calculation.

thanks,
pavan.

Pete Wilson · Posted: Fri Mar 08, 2013 2:48 pm

What a file has allocated is just that, it is what space it is using. It is irrelevent how many or how large the records in it may be. If there are only a few small records in the file it just means that space within the allocated space is not being used, but as it is still allocated space it is not available for other files to be allocated in.

In the example you provided, HARBA = 5529600000, which is the total number of bytes allocated to the dataset. Just divide this by 1024 for KB, again by 1024 for MB and so on.

You might want to have a look at using ISMF to get your figures in Kilobytes rather than trying to calculate them from cylinders.

However a simple basic calculation in Excel is: =(cyls*15)*56664 /1024/1024 which will give you a Megabyte figure for the number of cylinders you're dealing with. (The 56664 is track capacity in bytes) This is not 100% accurate but sufficient for your needs I suspect.

You need to talk to your Storage Team. They should have all sort of utilities to use to get the information.

And if files are being grossly overallocated that is an education issue for the User community to understand properly what they need and request just that. You might want to investigate using more Compression through your Dataclases as well. If that doesn't help it's a capacity issue, i.e. buy more DASD.

expat · Posted: Fri Mar 08, 2013 3:07 pm

From the figures given, the file has ONE cylinder allocated.

Where on earth did 151 cylinders suddenly appear from

Bill Woodger · Posted: Fri Mar 08, 2013 3:13 pm

expat · Posted: Fri Mar 08, 2013 3:49 pm

Bill, methinks this is going round in circles not helped by the fact that the OP has posted a completely different set of figures in the second example.