Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
VSAM Alter Command - Cylinder Extent changes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: VSAM Alter Command - Cylinder Extent changes
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: 343
Location: Bamberg, Germany

PostPosted: Tue Sep 22, 2020 3:11 pm    Post subject:
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    Post subject:
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: 488
Location: London

PostPosted: Tue Sep 22, 2020 6:11 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts RPLDDDD field for extended VSAM - ESDS amitsjcntl JCL & VSAM 0 Tue Sep 22, 2020 1:45 pm
No new posts Am I missing something on "FREE ... rodferrn CLIST & REXX 10 Fri Sep 04, 2020 6:51 am
No new posts DFDSS msg ADR485E when restoring VSAM... Alan Playford JCL & VSAM 5 Sat Aug 29, 2020 9:33 pm
No new posts How to use CICS command CEBR on sdsf ... wang_f_y1 CICS 1 Fri Aug 28, 2020 10:35 pm
No new posts Sync logic between VSAM files and DB2... murali.andaluri COBOL Programming 9 Tue Aug 25, 2020 1:01 pm

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us