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)] | |
[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.