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

This example outputs summary information for a specific table (ADBUSER01.TABLE01) and checks the following:

• Usage amount (in kilobytes) of table ADBUSER01.TABLE01

■ adbdbstatus command that is executed

adbdbstatus -c table              ...1
            -n ADBUSER01.TABLE01  ...2
            -S K                  ...3
            --shared-lock         ...4

Explanation:

1. Specifies table as the range of summary information collection.

2. Specifies the name of the table (ADBUSER01.TABLE01) for which summary information is to be collected.

3. Specifies kilobytes as the units for displaying usage amounts.

4. Specifies the --shared-lock option so that information can be output even while another SQL statement or command is updating the database.

   Note that if the --shared-lock option is specified, the usage of deletion-pending chunks in a system table (base table) cannot be output.

When the adbdbstatus command is executed, summary information for table ADBUSER01.TABLE01 is output.

The following shows how to check the output results.

Organization of this subsection

• (1) Checking the usage amount (in kilobytes) of a table