Reporting index information

Use the Index Report window to get information about one or more indexes. You can use the report to find the names of all the indexes in a referential structure. You can also use the report in planning for recovery since it provides information necessary for recovering spaces. You can request report information for LOCALSITE or RECOVERYSITE, or both. The report that is produced denotes entries added by non-COPY utilities in the SYSIBM.SYSCOPY catalog table with asterisks. The report can also be used on the DB2 catalog and directory.

Authorities and privileges

To obtain a report on an index:

  1. Open the Index Report window.

  2. Specify a radio button under Data set selected or for partitioned table spaces only, Partition selected to include all data set or partition information or information on only a particular data set or partition.

  3. Specify one of the three radio buttons under Archive log to specify whether the report should include data set 1 only or data set 2 only or both archive log data sets.
  4. If you want the report to Start from last recoverable point, select the check box.

  5. To get a summary of the volume serial numbers (for data sets) or partitions (for partitioned table spaces), select the Report summary of volume serial numbers check box.

  6. Select the check box to Use catalog table SYSIBM.SYSCOPY records from a local site.

  7. Select the check box to Use catalog table SYSIBM.SYSCOPY records from a recovery site.

  8. Click OK to begin the report processing.