MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

VSAM Space Allocation

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
deepeshk79
Beginner


Joined: 20 Jun 2003
Posts: 112
Topics: 48
Location: Bangalore

PostPosted: Wed Oct 06, 2004 4:52 am    Post subject: VSAM Space Allocation Reply with quote

Hi,

I have to create a control card for a VSAM delete define. In doing this i have to allocate space for the VSAM. I know that for my VSAM file the

Total number of records expected = 932000
LRECL =650

Based on this i did the following calculation

======================================
LRECL= 650
TOTAL NO OF RECORDS = 932000
TOTAL BYTES REQUIRED = 932000*650 = 605800000.

ONE CYLINDER = 15 TRACKS = 15 * 55900 bytes = 838500 BYTES
TOTAL CYLINDERS THUS REQUIRED = 605800000 / 838500 = 723 CYLINDERS.

FOR VSAM FILES WE HAVE
PRIMARY + 255 * SECONDARY = TOTAL SPACE = 723

LET SECONDARY BE 2 CYLINDERS .....
THEN WE GET
PRIMARY + 255*2 = 723
==> PRIMARY = 723-510=213
HENCE WE CAN ALLOCATE THE SPACE AS (215,5) APPROXIMATELY.
========================================

Is this correct approach ??

Thanks,
Deepesh
Back to top
View user's profile Send private message AIM Address
sandip
Beginner


Joined: 28 Jul 2004
Posts: 18
Topics: 3

PostPosted: Wed Oct 06, 2004 5:31 am    Post subject: Reply with quote

Hi Deepesh,

For VSAM, you have to consider Key length, CI CA % and CISIZE also for better calculation.

Regards,
Sandip.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Wed Oct 06, 2004 6:48 am    Post subject: Reply with quote

Deepesh,

You approach is not right. You need to provide us with more details like CIsize, CI/CA percent, MIN/MAAX LRECL and keylength.

Download a free vsam space calculator from here.

http://www.talsystems.com/tsihome_html/techcorner.html

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
warp5
Intermediate


Joined: 02 Dec 2002
Posts: 429
Topics: 18
Location: Germany

PostPosted: Thu Oct 07, 2004 12:56 am    Post subject: Reply with quote

Why didn't you just allocate it in Records instead of Cylinders?
Back to top
View user's profile Send private message Visit poster's website
vapsvina
Beginner


Joined: 22 Mar 2005
Posts: 4
Topics: 2

PostPosted: Tue Mar 22, 2005 8:48 am    Post subject: VSAM Space Calculation Reply with quote

Hi All,

In contunation with above question ..I have some queries

I want to allocate one VSAM cluster with following parameters...
Can anyone tell me,How to calculate the optimised size in cylinders??

LRECL=6250
Key Length=7
No of records= 8,50,000
CISZ=12288

Thanks,
Vaps
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Mar 22, 2005 9:03 am    Post subject: Reply with quote

vapsvina,

Did you try using the vsam space calculator from the 3rd post in this topic?

If you haven't then here is the calculation.

Code:


KSDS on 3390
CISZ= 12288 
CI %  : 10
CA % : 10
Fixed
LRECL= 6250
Key =7
Number of Records:  850,000


Requires 13,282  Cylinders


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group