How to define PATH

PATH establishes a relation between the base cluster and the alternate index. Its not a data set and does not occupy any space. It does not contain any records. It is justa a entry in the catalog, which establishes a link between the base cluster and the alternate index cluster. //PATHDEF JOB (ACCT),’DEFINE PATH’ //DEFPATH…

Details

How to define Alternate Index

Alternate Index is a cross reference to a base table. The JCL to allocate the Alternate Index is as shown below. //AIXDEF JOB (ACCT),’AIX DEFINE’ //ALLOCATE EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSIN DD * DEFINE AIX – (NAME(STUDENT.KSDS.AIX.CLUSTER) – (RELATE(STUDENT.KSDS.CLUSTER) – VOLUMES(XXXXXX) – CYLINDERS(5,1) – CONTROLINTERVALSIZE(2048) – FREESPACE(10,20) – KEYS(10,6) – NONUNIQUEKEY – UPGRADE –…

Details