VSAM Interview Question:

How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgms?

Submitted by: Administrator

DEFINE ALTERNATEINDEX. Important paramters are RELATE where you specify the base cluster name, KEYS, RECORDSIZE,SHAREOPTIONS,UNIQUEKEY(or NONUNIQUEKEY), DATA(ds name for the data component), INDEX(ds name for the index component).

Then DEFINE PATH. Important paramters are NAME (ds name for the path), PATHENTRY (ds name of the alternate index name), UPDATE(or NOUPDATE) which specifies whether an alt index is updated when a update to the base cluster takes place.

Then BLDINDEX. Parameters are INDATASET(ds name of base cluster), OUTDATASET(ds name of AIX).

Using alternate indexes in batch pgms:

In the JCL, you must have DD stmts for the cluster and for the path(s). In the cobol pgm, SELECT .. ASSIGN TO ddname for base cluster RECORD KEY IS... ALTERNATE RECORD KEY IS..

Using alternate indexes in CICS pgms:

FCT entries must be created for both base cluster & the path. To read using the alternate index, use the dd name of the path in CICS file control commands.
Submitted by: Administrator