13.10 Examples

This section explains by way of examples how to use the adbdbstatus command to check the database status.

In the output examples, the delimiters and some of the columns are omitted for readability.

Organization of this section

• 13.10.1 Checking the usage of the entire database (output of summary information for DB areas)

• 13.10.2 Checking the usage of a specific DB area (output of summary information for a DB area)

• 13.10.3 Checking the usage of a specific table (output of summary information for a table)

• 13.10.4 Checking the status of a specific table (output of summary information for a table)

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

• 13.10.6 Checking the status of a specific index (output of summary information for an index)

• 13.10.7 Finding the total size of all archive files corresponding to an archived chunk created in a specific table (outputting summary information of an archived chunk)

• 13.10.8 Checking the usage rate and usage of a DB area file in a specific DB area (output of usage information for DB areas, tables, and indexes)

• 13.10.9 Finding the file size of each archive file corresponding to an archived chunk created in a specific table (outputting usage information of an archived chunk)

• 13.10.10 Checking whether the column store table must be reorganized (output of information about the need for reorganization)

To Page Top