Previous Topic: Using KEYNAME=*SETR to Recount Records and Update CXXNext Topic: Rebuilding an Index Area


How to Use

When using the RETIX function to rebuild the data space index, the MUF must be active. This utility function executes only in the MUF. The database need not be disabled nor the User Requirements Tables closed. Use the following format for this function:

►►─ RETIX ─┬────────┬─DBID=n ─┬─ ,KEYNAME=*DATA ─┬────────────────────►◄
           └ AREA=a,┘         ├─ ,KEYNAME=*RTSN ─┤
                              └─ ,KEYNAME=*SETR ─┘

Command

RETIX

Invokes the function to rebuild a data space index or Index Area.

Required Keywords

,DBID=

At the database level, DBID= can repeat. Each occurrence can specify one or more valid database IDs or a range of DBIDs nnnn-mmmm (a range, for example, 100-250).

Valid Entries:

One or more valid database IDs or a range of DBIDs as already described

Default Value:

(No default)

,KEYNAME=

Use KEYNAME=*DATA to specify that the data space index be rebuilt. For more information about *DATA, see MUF Connection when KEYNAME=*DATA or KEYNAME=*SETR.

Use KEYNAME=*RTSN to detect and correct the high URI number. For more information about *RTSN, see Resetting the TSN.

Use KEYNAME=*SETR to specify that records by recounted. For more information about *SETR, see Using KEYNAME=*SETR to Recount Records and Update CXX.

Valid Entries:

*DATA, *RTSN, *SETR

Default Value:

(No default)

Optional Keywords

AREA=

Identifies the data area for which the data space index is to be rebuilt. This keyword can omitted to cause action for every area in the database.

Valid Entries:

DATACOM-NAME of the area

Default Value:

All areas in the database.