CICS VSAM Transparency for z/OS, Version 1.2


Mapping the alternate index paths

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:

Figure 1. Sample JCL for CICS VT utility to map an alternate index
//INDEX   EXEC PGM=VIDPATHM                            
Start of change//STEPLIB  DD DSN=VID.SVIDLODE,DISP=SHREnd of change         
//         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.

Mapping alternate indexes with multiple fields

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:

Example 1:
		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  
		
Example 2:
		PATHMAP BASENAME=mydim,PATHNAME=myaix
		PATHKEYS=VIDFL007,VIDFL008,VIDFL009,VIDFL0010,VIDFL011,VIDFL0012
		PATHKEYS=VIDFL013,VIDFL014,VIDFL015,VIDFL0016,VIDFL017,VIDFL0018
		PATHKEYS=VIDFL019
		




Last updated: November 9, 2012 20:42:45