13.5.2 List of items that are output as summary information for indexes

The table below lists and describes the titles and contents of the items (columns) that are output as summary information for indexes. The columns are output in the order listed in this table. For details about the output rules for summary information for indexes, see 13.12 Output rules for the adbdbstatus command.

Table 13‒18: Columns output as summary information for indexes
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of information that is output: `Index`: Summary information for an index `Index(Shared_lock)`: Summary information for an index (if the `--shared-lock` option is specified)	N
2	`Timestamp`	Timestamp when the `adbdbstatus` command was executed: The date and time the `adbdbstatus` was executed are output in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss"`^#1	Y
3	`DBarea_name`	Name of the DB area where the index is stored	Y
4	`DBarea_ID`	DB area ID of the DB area where the index is stored	N
5	`Schema_name`	Schema name of the index: The schema name for an index defined for a dictionary table (base table) or system table (base table) is always `HADB`.	Y
6	`Index_identifier`	Index identifier	Y
7	`Index_ID`	Index ID	N
8	`Index_type`	Index type: `B-tree`: B-tree index `text`: Text index `range`: Range index	N
9	`Schema_name`	Schema name of the table for which the index is defined	Y
10	`Table_identifier`	Table identifier of the table for which the index is defined	Y
11	`Table_ID`	Table ID of the table for which the index is defined	N
12	`Unique_constraint_violated`	Uniqueness constraint violation: `unique_constraint_violated`: A uniqueness constraint violation occurred on a unique index. `unknown`: Whether a uniqueness constraint violation occurred on a unique index cannot be determined. `no_check`: This is output if the `--shared-lock` option is specified. Information about uniqueness constraint violation cannot be acquired. In any other case, no value is output.	N
13	`Page_size`	Page size (bytes)	N
14	`Segment_size`	Segment size (pages)	N
15	`Unfinished`	Whether the index is in unfinished status: `unfinished`: This is output if the index is in unfinished status. `no_check`: This is output if the `--shared-lock` option is specified. Information about whether the index is in unfinished status cannot be acquired. In any other case, no value is output.	N
16	`Pagegroup_size`	Page group size for a range index (pages): No value is output for B-tree indexes or text indexes. For a range index that was defined by a version earlier than 02-02, the segment size is output.	N
17	`Used_segments`^#2	Number of segments in use by the index^#3^{, #4}: The number of segments being used by the index^#3^{, #4} is output.	N
18	`Used_pages`^#2	Number of pages in use by the index^#3^{, #4}: The number of pages being used by the index^#3^{, #4} is output.	N
19	`Rsv`	--	--

Legend:

--: No value is output.

Y: The output value is enclosed in a pair of enclosing characters.

N: The output value is not enclosed in the enclosing character.

#1

The year (YYYY) is output as four digits. The month (MM), day (DD), hour (hh), minute (mm), and second (ss) are each output as two digits. If there are not enough digits, leading zeros are added. Δ indicates a single-byte space.

#2

When the display units for usage amounts are changed by specifying the -S option, the column titles for the usage amount output items are also changed to match the selected display units. For details about the display units and column titles, see Table 13‒2: Display units and column titles for usage amount output items in (3) Explanation of options in 13.2.1 Explanation of the specification format and options (outputting summary information or usage information).

#3

The -S option enables you to change the display units for usage amount output items to kilobytes, megabytes, or gigabytes.

#4

If the --shared-lock option is specified, the values output for Used_segments and Used_pages (number of segments and number of pages in use by the index) of the following tables do not include the values relating to deletion-pending chunks:

Index defined for a system table (base table)
Index defined for a table for which the adbmergechunk command is being executed

To Page Top