DBA > Job Interview Questions > Virtual Storage Access Method (VSAM) Interview Questions

How do you define an ALTINDX ? How do you use AL

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS program's ?

DEFINE ALTERNATEINDEX. Impartant parameters are RELATE where you specify the base cluster name, KEYS, RECORDSIZE, SHAREOPTION, 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 vase cluster takes place. Then BLDINDEX. Paramters are INDATASET (DS name of base cluster), OUTDATASET (DS name of AIX).

(Continued on next question...)

Other Job Interview Questions