Defining alternate indexes

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 follows:

DEFINE ALTERNATEINDEX (parameters)
- [DATA(parameters)]
- [INDEX(parameters)]
- [CATALOG(subparameters)]

The syntax of the DEFINE ALTERNATEINDEX command.

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`]\|&cont; 0 0)]
	[KEYS(`length` `offset`\|64 0)]
	[MODEL(`entryname`[ `catname`])]
	[OWNER(`ownerid`)]
	[RECATALOG\|NORECATALOG]
	[RECORDSIZE(`average` `maximum`\|&cont; 4086 32600)]
	[REUSE\|NOREUSE]
	[SHAREOPTIONS(`crossregion`[ `crosssystem`]\|&cont; 1 3)]
	[SPEED\|RECOVERY]
	[TO(`date`)\|FOR(`days`)]
	[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`&cont; ])]
	[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`&cont; ])]
	[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.