10.9.4 Checking the status and usage of a text index
When you acquire summary information for index by using the adbdbstatus command, you can check the status and usage of a text index.
- Organization of this subsection
(1) Checking whether a text index is in unfinished status
To check whether a text index is in unfinished status, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for text index ADBUSER01.TIDX1.
adbdbstatus -d summary -c index -n ADBUSER01.TIDX1
Executing the adbdbstatus command outputs summary information for text index ADBUSER01.TIDX1 to the standard output.
Check the value output under Unfinished in the summary information for the index. If unfinished is output, the text index is in unfinished status.
To release the text index from unfinished status, see 15.10.1 Steps to take when unfinished status is applied to a text index.
(2) Checking the usage of a text index
To check the usage of a text index, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for text index ADBUSER01.TIDX1.
adbdbstatus -d summary -c index -n ADBUSER01.TIDX1 -S M --shared-lock
Executing the adbdbstatus command outputs summary information for text index ADBUSER01.TIDX1 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 text index data stored in the DB area.