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
 

 

Estimating the size of a VSAM file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Estimating the size of a VSAM file
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: 190
Location: hyderabad

PostPosted: Mon Mar 21, 2005 4:27 pm    Post subject: Re: Estimating the size of a VSAM file
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

http://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    Post subject: Re: Estimating the size of a VSAM file
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

http://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    Post subject:
Reply with quote

Pratheep
You can download free VSAM space caluculator from here.
http://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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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