The automated mapping facility generates DIMs and DDMs for each alternate index path. The module names use the first four characters of the base cluster DIM name, followed by X01 for the first alternate index DIM, X02 for the second and so on.
ASSOCIATIONS
DATA-----VID.VIDKSDS.DATA
INDEX----VID.VIDKSDS.DATA.INDEX
AIX------VID.VIDKSDS.DATA.ZIP
AIX------VID.VIDKSDS.DATA.NAME
AIX------VID.VIDKSDS.DATA.ADDRESS
There are three
paths defined for this data set. The list catalog command shows
these in the order that they were defined. If the DIM name for the
base cluster is VIDKSDS, the DIM names generated for the alternate
index paths are as follows: Name | Function |
---|---|
VIDKX01 | The DIM for the ZIP path. |
VIDKX02 | The DIM for the NAME path. |
VIDKX03 | The DIM for the ADDRESS path. |
If two base cluster DIMs have the same first four characters and have alternate indexes, SQL code -803 occurs in the PATHMAP step. In this case, choose an alternative DIM name.
There are two methods for choosing an alternate index
DIM name:
Read Automated mapping commands for information on the SAVE command.