IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Estimating the size of a VSAM file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Pratheep

New User


Joined: 20 Mar 2005
Posts: 3
Location: singapore

PostPosted: Sun Mar 20, 2005 9:06 am
Reply with quote

Hi,
Our cics regions have files defined with lot of space without considering the reqrment, so that now we are running short of DASD space. So I would like to redefine/reorganize all the files.

Now, my question is how to estimate the optimized primary/secondary spaces reqd for these files.
For example I have a file 'abc' with record length 3850 and having 1 million (10,00,000) records in it. So the file size may be = (rec len x no.of records)/bytes per cylinder.
So i will get the space needed for the file in cylinder unit (file size).
Now, assume I give x/y as the primary/sec space in cylinders for the file. So the size will be x + (y x 123), (which is the no, of extends).

Now which will be the most optimized way to decide x and y.?

Assume I will give freespace(20,20). CISize(8192)

Can somebody help me.. eagerly looking for some answers... don't worry about the example above. its only a sample for you to understand the problem. Real thing is how to estimate.
Back to top
View user's profile Send private message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 191
Location: hyderabad

PostPosted: Mon Mar 21, 2005 4:27 pm
Reply with quote

Hi Pradeep


there is a vsam spacer tool available with mainframe cd which may help you.


Check the below site this may help you

www.circle4.com/jaqui/pouvsm92/pouvsm92.html


Thanks
Siva
Back to top
View user's profile Send private message
Pratheep

New User


Joined: 20 Mar 2005
Posts: 3
Location: singapore

PostPosted: Mon Mar 21, 2005 9:20 pm
Reply with quote

Hi Siva,
Thank you very much for the detailed document. I am sure this will help me.

What I am doing now is, i got another tool for calculating the file size in cylinders. And the information i got from various sources so far, says that, deciding primary and secondary most optimized spaces is not possible with tools or formulae.
So I am in the process of deciding the most optimized size for each files by looking at the size, type and growth rate of the files.

Anyway, thank you very much for the information provided. It really good.

Regards
Pratheep


sivatechdrive wrote:
Hi Pradeep


there is a vsam spacer tool available with mainframe cd which may help you.


Check the below site this may help you

www.circle4.com/jaqui/pouvsm92/pouvsm92.html


Thanks
Siva
Back to top
View user's profile Send private message
somasundaran_k

Active User


Joined: 03 Jun 2003
Posts: 134

PostPosted: Wed Mar 23, 2005 4:08 am
Reply with quote

Pratheep
You can download free VSAM space caluculator from here.
www.talsystems.com/tsihome_html/techcorner.html

hth
-Som
Back to top
View user's profile Send private message
Pratheep

New User


Joined: 20 Mar 2005
Posts: 3
Location: singapore

PostPosted: Wed Mar 23, 2005 5:06 pm
Reply with quote

Hi Som,
Thanks for the reply.

This is the same link as Siva provided.

Thanks again

Pratheep
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Is there a way to close VSAM files us... CICS 2
No new posts File Aid Batch IBM Tools 7
No new posts To replace jobname in a file with ano... SYNCSORT 12
No new posts Converting fixed length file to excel... IBM Tools 7
No new posts Extract record using 2 input file int... JCL & VSAM 2
Search our Forums:

Back to Top