VSAM Alternate Index: How to Use it

VSAM alternate index merits
Image courtesy|Gettyimages.in

The alternate index in VSAM to access records other than the base key defined on the dataset is called a base cluster.

Advantages

  • Can be defined for both KSDS and ESDS
  • reduce data redundancy
  • Can have duplicates
  • Easy to define using IDCAMS
  • allow datasets to be accessed by both sequentially and randomly

Disadvantages

  • Performance degradation
  • Complex update logic

Click here for VSAM alternate index example.

Also Read:

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.