The next step is to map the path to CICS® VT using a supplied batch utility. This step applies to both unique and non-unique indexes. Every alternate index has a unique DIM and DDM. When you manually map an alternate index, you specify a unique DIM name in the VIDPATHJ utility. Sample JCL is provided in member VIDPATHJ of the my.SVIDSAMP.custom library. The JCL looks like this:
//INDEX EXEC PGM=VIDPATHM
//STEPLIB DD DSN=VID.SVIDLODE,DISP=SHR
// DD DSN=DB2.SDSNLOAD,DISP=SHR
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSABEND DD SYSOUT=*
//SYSIN DD *
PATHMAP BASENAME=VIDKSDS,PATHNAME=KSDSAIX
PATHKEYS=VIDM0006
The parameters in the SYSIN cards have the following meaning:
Parameter | Description |
---|---|
PATHMAP | This indicates that the SYSIN parameters are to map an alternate index. |
BASENAME | The name of the CICS VT DIM that corresponds to the base VSAM cluster. |
PATHNAME | The user-specified DIM name that corresponds to the PATH. The length of the name should not exceed 7 characters. |
PATHKEYS | The CICS VT field name for the alternate key. If there are multiple fields because the alternate key maps to multiple DB2® columns, separate them using commas. For example, PATHKEYS=VIDM0006, VIDM0007, VIDM0008. |
The batch job creates all of the mapping information that CICS VT needs and should end with return code 0000. The following message is produced:
PROCESSING COMPLETE FOR PATH pathname
ON BASE basename
You must run the VIDPATHJ utility for every alternate index on a base data set.
If the number of fields in the alternate index cannot be specified in a single PATHKEYS statement, you must specify the PATHKEYS keyword on every subsequent line. Here are two examples for the same alternate index:
PATHMAP BASENAME=mydim,PATHNAME=myaix
PATHKEYS=VIDFL007
PATHKEYS=VIDFL008
PATHKEYS=VIDFL009
PATHKEYS=VIDFL010
PATHKEYS=VIDFL011
PATHKEYS=VIDFL012
PATHKEYS=VIDFL013
PATHKEYS=VIDFL014
PATHKEYS=VIDFL015
PATHKEYS=VIDFL016
PATHKEYS=VIDFL017
PATHKEYS=VIDFL018
PATHKEYS=VIDFL019
PATHMAP BASENAME=mydim,PATHNAME=myaix
PATHKEYS=VIDFL007,VIDFL008,VIDFL009,VIDFL0010,VIDFL011,VIDFL0012
PATHKEYS=VIDFL013,VIDFL014,VIDFL015,VIDFL0016,VIDFL017,VIDFL0018
PATHKEYS=VIDFL019