13.1.2 Types of results output by the adbdbstatus command
The adbdbstatus command outputs three types of results: summary information, usage information, and information about the need for reorganization.
The following explains the contents of each type of information.
Summary information is further classified into four types, one for each type of analysis target. Usage information is further classified into two types.
- Summary information
-
-
Summary information for DB areas
The usage of DB areas is output. For details about the items that are output as summary information for DB areas, see 13.3 Items that are output as summary information for DB areas.
-
Summary information for tables
The usage and status of tables are output. For details about the items that are output as summary information for tables, see 13.4 Items that are output as summary information for tables.
-
Summary information for indexes
The usage and status of indexes are output. For details about the items that are output as summary information for indexes, see 13.5 Items that are output as summary information for indexes.
-
Summary information of archived chunks
The usage and status of chunks created in an archivable multi-chunk table are output. For details about the items that are output as summary information of archived chunks, see 13.6 Items that are output in the summary information of archived chunks.
-
- Usage information
-
-
Usage information for DB areas, tables, and indexes
Detailed usage information for DB areas, tables, and indexes is output.
Usage information for a multi-chunk table is output for each chunk in the table. For details about the items that are output as usage information for DB areas, tables, and indexes, see 13.7 Items that are output as usage information for DB areas, tables, and indexes.
-
Usage information of archived chunks
Detailed usage information of archived chunks created in an archivable multi-chunk table, and detailed usage information of archive files, which contain archived chunk data, corresponding to those chunks are output.
For details about the items that are output as usage information of archived chunks, see 13.8 Items that are output in the usage information of archived chunks.
-
- Information about the need for reorganization
-
Information about whether the column store table must be reorganized is output.
If the column store table is a multi-chunk table, information about the need for reorganization is output for each chunk in the table. However, information about deletion-pending chunks is not output. For details about the items that are output as information about the need for reorganization, see 13.9.2 List of items that are output as information about the need for reorganization.