Displaying reports about indexes

Use the Display All Indexes or Display Index window to view a report about indexes.

To display an index report:

Open the Display All Indexes or Display Index window.
You can customize the report by specifying the:
- Type of information included in the report
- Type of index spaces included in the report
- Number of messages returned:
  1. Select the Maximum number of messages check box.
  2. Specify a value in the text field. The default value is 50.
Click Display to view the output for the report in the Output generated for the index spaces field. You can change the options and click the Display push button again to produce different output.
Click Close to close the window.

Related information

Specifying the type of information

To specify the type of information that you want to include:

Select radio buttons in the Space information to be displayed box to specify the type of information that DB2 should include in the report.

Default displays information about the status of index spaces.

Usage displays information about:

The applications and subsystems of the database or space that has internal DB2 resources allocated.
The applications and subsystems of the database or space on whose behalf locks for the space are held or waited upon.
The connection IDs, correlation IDs, and authorization IDs for all applications allocated to spaces and partitions whose status is displayed.
The LUWID and location of any remote threads accessing the local database.

Locks displays information about :

The applications and subsystems on whose behalf locks are held, waited upon, or retained for the database or space.
The transaction locks for all table spaces, tables, index spaces and partitions whose status is displayed.
The connection IDs, correlation IDs, and authorization IDs for all applications allocated to spaces whose status is displayed.
The LUWID and location of any remote threads accessing the local database.
The drain locks for a resource held by running jobs.
The logical partitions that have drain locks and the drain locks associated with them.
The retained locks for a resource.
The page set or partition physical locks (P-locks) for a resource.

Current claims displays information about:

The claims on all table spaces, index spaces and partitions whose status is displayed.
The LUWID and location of any remote threads accessing the local database.
The connection IDs, correlation IDs, and authorization IDs for all applications allocated to spaces whose status is displayed.
The logical partitions that have logical claims and the claims associated with them.

Logical page list entries displays a list of pages that cannot be referenced by applications until the pages are recovered. The page is in 'logical error' because there might be nothing wrong with the media (coupling facility or DASD) itself. Usually a connection to the media has been lost.

Write error page range displays information about physical write errors.

Specifying the type of index spaces

To specify the type of index spaces that you want to include:

Select check boxes in the Options box to limit the type of index spaces that DB2 includes in the report:

Display only index information

Limits the display to index information only. If you specify the Locks radio button, DB2 displays tables with table locks.

Active index spaces

Limits the display to:

Table spaces or index spaces that have had internal DB2 resources allocated to applications and that are in a started state.
Databases that contain such spaces.

Restricted index spaces

Limits the display to databases, table spaces, or indexes in a restricted status. This set includes page sets that have logical page list entries.

Advisory information

Limits the display to spaces that allow read/write access, but for which some action is recommended.