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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am
No new posts Occurrence of various strings within ... TS70363 JCL & VSAM 1 Thu Apr 27, 2017 8:18 pm


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