13.10.5 Checking the usage of a specific index (output of summary information for an index)

This example outputs summary information for a specific index (ADBUSER01.INDEX01) and checks the following:

Usage amount (in kilobytes) of index ADBUSER01.INDEX01

■ adbdbstatus command that is executed

adbdbstatus -c index              ...1
            -n ADBUSER01.INDEX01  ...2
            -S K                  ...3
            --shared-lock         ...4

Explanation:

Specifies index as the range of summary information collection.
Specifies the name of the index (ADBUSER01.INDEX01) for which summary information is to be collected.
Specifies kilobytes as the units for displaying usage amounts.
Specifies the --shared-lock option so that information can be output even while another SQL statement or command is updating the database.

Note that if the --shared-lock option is specified, the usage of deletion-pending chunks for the indexes defined for a system table (base table) cannot be output.

When the adbdbstatus command is executed, summary information for index ADBUSER01.INDEX01 is output.

The following shows how to check the output results.

Organization of this subsection

(1) Checking the usage amount (in kilobytes) of an index

(1) Checking the usage amount (in kilobytes) of an index

[Figure]

To check the amount of index ADBUSER01.INDEX01 that is being used:

Check the schema name and index identifier of the index.

Verify that the schema name (ADBUSER01) of the index is output in the column headed Schema_name (column 5 in the output results) and the index identifier (INDEX01) is output in the column headed Index_identifier (column 6 in the output results).
Check the usage amount (in kilobytes) of the index.

Obtain the value of the KB_Used_pages column (col. 18 in the output results).

To Page Top