Let's understand Mainframe
Home Tutorials Interview Q&A Quiz Mainframe Memes Contact us About us

Module 4: Alternate INDEX


Alternate INDEX - Overview

  • Alternate indexes (AIXs) allows logical records of a KSDS or of an ESDS base cluster to be accessed sequentially and randomly by more than one key field.
  • The Alternate Index enables one or more secondary index structures (other than the primary key) to be created for a VSAM object based on data in the records.
  • This capability allows for a Key Sequenced dataset to be accessed in a different order other than the primary key and also allows the creation of an index for a non-indexed object, such as an Entry Sequenced cluster.
  • Example, There is “Employee details” KSDS VSAM file, containing fields EMP-ID (Primary key), EMP-NAME, EMP-AGE, and EMP-SALARY. In this case we can access records sequentially or randomly using primary key field, but what if we want to retrieve data based on EMP-NAME. In this case, we can create EMP-NAME as alternate index field which will allow us to access records randomly based on EMP-NAME too.

When Alternate INDEX required?

  • KSDS file can be accessed using primary key field but we have requirement to access the file randomly with another key field too.
  • To access ESDS file randomly based on some field.

In upcoming articles we have covered:



Advertisements






© copyright mainframebug.com
Privacy Policy