View previous topic :: View next topic |
Author |
Message |
deepeshk79 Beginner
Joined: 20 Jun 2003 Posts: 112 Topics: 48 Location: Bangalore
|
Posted: Wed Oct 06, 2004 4:52 am Post subject: VSAM Space Allocation |
|
|
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 |
|
 |
sandip Beginner
Joined: 28 Jul 2004 Posts: 18 Topics: 3
|
Posted: Wed Oct 06, 2004 5:31 am Post subject: |
|
|
Hi Deepesh,
For VSAM, you have to consider Key length, CI CA % and CISIZE also for better calculation.
Regards,
Sandip. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
warp5 Intermediate

Joined: 02 Dec 2002 Posts: 429 Topics: 18 Location: Germany
|
Posted: Thu Oct 07, 2004 12:56 am Post subject: |
|
|
Why didn't you just allocate it in Records instead of Cylinders? |
|
Back to top |
|
 |
vapsvina Beginner

Joined: 22 Mar 2005 Posts: 4 Topics: 2
|
Posted: Tue Mar 22, 2005 8:48 am Post subject: VSAM Space Calculation |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Tue Mar 22, 2005 9:03 am Post subject: |
|
|
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 |
|
 |
|
|