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

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

■ adbdbstatus command that is executed

adbdbstatus -S M

Explanation:

If the adbdbstatus command is executed with the -d, -c, and -n options all omitted, summary information for all DB areas is output.
Specifies megabytes as the units for displaying usage amounts.

The following shows how to check the output results.

Organization of this subsection

(1) Checking the usage rate of each DB area

[Figure]

To check the usage rate of each DB area:

Check the DB area names.

Check the DB area names output in the column headed DBarea_name (column 3 in the output results).
Check the segment usage rate of each DB area.

Check the DB area segment usage rates (%) that are output in the column headed Used_ratio (column 16 in the output results). If a row's 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 each DB area:

Check the DB area names.

Check the DB area names output in the column headed DBarea_name (column 3 in the output results).
Check the usage amount (in megabytes) of each DB area.

Obtain the value of the MB_Used_segments column (col. 17 in the output results) for each row (each DB area).