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

This example outputs summary information for DB area DBAREA01 and checks the following:

■ adbdbstatus command that is executed

adbdbstatus -c dbarea           ...1
            -n DBAREA01         ...2
            -S M                ...3

Explanation:

Specifies DB area as the range of summary information collection.
Specifies the name of the DB area (DBAREA01) for which summary information is to be collected.
Specifies megabytes as the units for displaying usage amounts.

When the adbdbstatus command is executed, summary information for DB area DBAREA01 is output.

The following shows how to check the output results.

Organization of this subsection

(1) Checking the usage rate of a DB area

[Figure]

To check the usage rate of DB area DBAREA01:

Check the DB area name.

Verify that DB area name DBAREA01 is displayed in the column headed DBarea_name (column 3 in the output results).
Check the usage rate of the DB area.

The segment usage rate (%) of the DB area is output in the column headed Used_ratio (column 16 in the output results). If the segment usage rate is close to 100%, consider taking the following actions according to the type of DB area file:
- If the DB area files are block special files
  
  If you continue to store data, the DB area files might become full. Consider providing more free space on the disk where the block special file is stored based on the explanation in When a free space shortage is caused by an increase in the size of the DB area files in the HADB Setup and Operation Guide.
- If the DB area files are regular files
  
  If you continue to store data, the DB area will be extended automatically. When a DB area is extended automatically, its capacity increases, but the efficiency of update processing will decrease when the DB area's files are expanded. If a DB area automatic extension has failed, see When a free space shortage is caused by failed DB area automatic extension in the HADB Setup and Operation Guide.

[Figure]

To check the usage amount (in megabytes) of a DB area:

Check the DB area name.

Verify that DB area name DBAREA01 that you specified in the adbdbstatus command is displayed in the column headed DBarea_name (column 3 in the output results).
Check the usage amount (in megabytes) of the DB area.

Obtain the value of the MB_Used_segments column (col. 17 in the output results).