DEFINE ALTERNATEINDEX

The DEFINE ALTERNATEINDEX command defines an alternate index. Use it to show attributes for the alternate index as a whole and for the components of the alternate index. The syntax of the DEFINE ALTERNATEINDEX command is:
  • DEFINE ALTERNATEINDEX (parameters) -
    • [DATA(parameters)] -
    • [INDEXparameters)] -
    • [CATALOG(subparameters)]
Command Parameters
DEFINE ALTERNATEINDEX
    (NAME(entryname)
    RELATE(entryname)
    {CYLINDERS(primary[ secondary])|
     KILOBYTES(primary[ secondary])|
     MEGABYTES(primary[ secondary])|
     RECORDS(primary[ secondary])|
     TRACKS(primary[ secondary])}
    VOLUMES(volser[ volser...])
    [BUFFERSPACE(size)]
    [CONTROLINTERVALSIZE(size)]
    [DATACLASS(class)]
    [ERASE|NOERASE]
    [EXCEPTIONEXIT(entrypoint)]
    [FILE(ddname)]
    [FREESPACE(CI-percent[ CA-percent]| 0 0)]
    [KEYS(length   offset|64 0)Start of change|End of changeStart of changeALTKEYS(End of changeStart of changekeyname1,A|D...End of changeStart of changekeynamen,A|D)End of changeStart of change|End of change Start of changeALTKEYSU(End of changeStart of changekeyname1,A|D...End of changeStart of changekeynamen,A|D)End of change ]
    [MODEL(entryname[ catname])]
    [OWNER(ownerid)]
    [RECATALOG|NORECATALOG]
    [RECORDSIZE(average   maximum| 4086 32600)]
    [REUSE|NOREUSE]
    [SHAREOPTIONS(crossregion[ crosssystem]| 1 3)]
    [SPEED|RECOVERY]
  [UNIQUEKEY|NONUNIQUEKEY]
    [UPGRADE|NOUPGRADE]
    [WRITECHECK|NOWRITECHECK])
  [DATA (
    {CYLINDERS(primary[ secondary])|
     KILOBYTES(primary[ secondary])|
     MEGABYTES(primary[ secondary])|
     RECORDS(primary[ secondary])|
     TRACKS(primary[ secondary])}
    [VOLUMES(volser[ volser...])]
    [ATTEMPTS(number)]
    [AUTHORIZATION(entrypoint[ string])]
    [BUFFERSPACE(size)]
    [CODE(code)]
    [CONTROLINTERVALSIZE(size)]
    [ERASE|NOERASE]
    [EXCEPTIONEXIT(entrypoint)]
    [FILE(ddname)]
    [FREESPACE(CI-percent[ CA-percent])]
    [KEYS(length  offset)]
    [MODEL(entryname [ catname ])]
    [NAME(entryname)]
    [OWNER(ownerid)]
    [RECORDSIZE(average  maximum)]
    [REUSE|NOREUSE]
    [SHAREOPTIONS(crossregion[ crosssystem])]
    [SPEED|RECOVERY]
    [UNIQUEKEY|NONUNIQUEKEY]
    [WRITECHECK|NOWRITECHECK])]
  [INDEX (
    {CYLINDERS(primary[ secondary])|
     KILOBYTES(primary[ secondary])|
     MEGABYTES(primary[ secondary])|
     RECORDS(primary[ secondary])|
     TRACKS(primary[ secondary])}
    [VOLUMES(volser[ volser...])]
    [ATTEMPTS(number)]
    [AUTHORIZATION(entrypoint[ string])]
    [CODE(code)]
    [CONTROLINTERVALSIZE(size)]
    [EXCEPTIONEXIT(entrypoint)]
    [FILE(ddname)]
    [MODEL(entryname[ catname ])]
    [NAME(entryname)]
    [OWNER(ownerid)]
    [REUSE|NOREUSE]
    [SHAREOPTIONS(crossregion[ crosssystem])]
    [WRITECHECK|NOWRITECHECK])]
  [CATALOG(catname)]
   

DEFINE can be abbreviated: DEF

Restriction: If IMBED, KEYRANGE, ORDERED, or REPLICATE is specified, it is ignored.