10.9.5 Checking the status and usage of range indexes
When you acquire summary information for index by using the adbdbstatus command, you can check the status and usage of a range index.
- Organization of this subsection
(1) Checking whether a range index is in unfinished status
To check whether a range index is in unfinished status, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for range index ADBUSER01.RIDX1.
adbdbstatus -d summary -c index -n ADBUSER01.RIDX1
Executing the adbdbstatus command outputs summary information for range index ADBUSER01.RIDX1 to the standard output.
Check the value output under Unfinished in the summary information for the index. If unfinished is output, the range index is in unfinished status.
To release the range index from unfinished status, see 15.11.1 Steps to take when unfinished status is applied to a range index.
(2) Checking the usage of a range index
To check the usage of a range index, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for range index ADBUSER01.RIDX1.
adbdbstatus -d summary -c index -n ADBUSER01.RIDX1 -S M --shared-lock
Executing the adbdbstatus command outputs summary information for range index ADBUSER01.RIDX1 to the standard output.
Check the value output under MB_Used_pages in the summary information for the index. You can determine the size of the area (in megabytes) being used by the range index data stored in the DB area.
(3) Checking the page group size of the range index
To check the page group size of a range index, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for range index ADBUSER01.RIDX1.
adbdbstatus -d summary -c index -n ADBUSER01.RIDX1 -S M --shared-lock
Executing the adbdbstatus command outputs summary information for range index ADBUSER01.RIDX1 to the standard output.
Check the value output under Pagegroup_size in the summary information for the index. The value output under Pagegroup_size is the page group size (pages).