DSNU703I csect-name INVALID INDEX SPECIFICATION. INDEX=iiii
Explanation
All tables referenced by the indexes in the CHECK or REBUILD utility must be in the same table space. Index 'iiii' is not over a table in the same table space as the prior indexes listed in the index name list.
System action
Utility processing is discontinued.
User response
Correct the index name and/or the TABLESPACE parameters such that a single table space is involved, and rerun the utility job.
Problem determination
To CHECK or REBUILD ALL INDEXES in a table space, use the TABLESPACE keyword, but do not use the list option. This is one way to correct this error. If you want to correct the list of indexes specified in the index name list, the following procedure will locate the table space name related to the index 'iiii'.
The index name 'iiii' reported in the message is of the form 'creator.name'. Obtain the TBCREATOR and TBNAME columns from the Db2 catalog table SYSIBM.SYSINDEXES, where columns CREATOR and NAME have the values reported in the message. Obtain the DBNAME and TSNAME columns from the Db2 catalog table SYSIBM.SYSTABLES, where columns CREATOR and NAME have the values obtained from TBCREATOR and TBNAME of SYSIBM.SYSINDEXES.
The values for DBNAME and TSNAME must be the same for all indexes specified in the index name list and must be the same as the table space name specified on the TABLESPACE keyword if provided.
Severity
8 (error)