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

VSAM Alter Command - Cylinder Extent changes


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Need2Know

New User


Joined: 22 Sep 2020
Posts: 2
Location: South Africa

PostPosted: Tue Sep 22, 2020 3:02 pm
Reply with quote

Hi All,


How or where do I alter the VSAM KSDS file space allocation cylinder extents?

As an example - I want to change CYL (10 50 ) to CYL (50 50) as I summize that this is part of the cause of my CI/CA splits.
Back to top
View user's profile Send private message
Joerg.Findeisen

Active User


Joined: 15 Aug 2015
Posts: 471
Location: Bamberg, Germany

PostPosted: Tue Sep 22, 2020 3:11 pm
Reply with quote

How about Unload/Reload using IDCAMS REPRO? Also see FSPC values defined for the Cluster.
Back to top
View user's profile Send private message
Need2Know

New User


Joined: 22 Sep 2020
Posts: 2
Location: South Africa

PostPosted: Tue Sep 22, 2020 4:01 pm
Reply with quote

Hi Joerg.Findeisen,

Thanks for the suggestion, I will test it. I changed the FreeSpace attribute from ( 0 0 ) to (10 5), but get the exact amount of CI and CA splits.

I am still building an understanding of how all these attributes fit together, so it's all trial and error.
Back to top
View user's profile Send private message
Pete Wilson

Active User


Joined: 31 Dec 2009
Posts: 499
Location: London

PostPosted: Tue Sep 22, 2020 6:11 pm
Reply with quote

The dataset has to be redefined to change the SPACE allocation. At this time it gives the opportunity to also change the Dataclas which can enable things like Compression, Extended Format & Addressibility, Space Constraint Relief and Extent Constraint Relief, all of which could be beneficial.

Getting the FREESPACE right is not always easy. First you need to decide if you need it. Generally it's only necessary if large numbers of inserts are being made in a short period. Once CI/CA split overheads have occurred then the freespace is inserted into the areas it's needed so splits are not always a bad thing.

It's important to make sure your CISIZE is a good fit for the record size(s). For example if your RECSZ is 398 then a CISIZE(4096) is reasonable fit as only a few bites are left unused within the CI after 10 records are inserted. But, CISIZE also has an effect on DASD usage, so ones nearer a half track size are more efficient for DASD usage. But the application usage of the dataset does come into play as well. The bigger the CISIZE the larger the amount of data is being transferred in an I/O operation. Depending on performance requirements that can require a balance between DASD usage and performance with a compromise on CISIZE.

The FREESPACE percentage needs to equate to one or more of the RECSZ. For CISIZE 4096 a 10% CI freespace figure would be ~ 409 bytes which would fit a 398 byte record quite comfortably. CA freespace is sometimes difficult to gauge until the dataset is loaded or in use for a while and the number of CA splits becomes evident.

One thing to note about FREESPACE specified on a DEFINE Cluster is that it is included in the initial allocation of space taken by the dataset, so can significantly increase the size.

In any case be guided by the IBM manuals called 'VSAM Demystified' or 'Using Data Sets' which will be much more accurate than what I have put here.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts VSAM file Storage Calculation JCL & VSAM 3
No new posts Alter User LOGON Script Parameters CLIST & REXX 11
No new posts Command line placement in DB2I panels TSO/ISPF 2
No new posts A command to change LRECL of an exist... JCL & VSAM 7
No new posts FILE STATUS - 39 ON VARIABLE LENGTH V... COBOL Programming 2
Search our Forums:

Back to Top