10.9.1 Checking the database usage
This subsection explains how to use the adbdbstatus command to check the HADB database status and its usage.
- Example of the command to be executed
-
This example outputs summary information for all DB areas:
adbdbstatus -d summary -c dbarea -S M
Executing this command outputs summary information for all DB areas to the standard output. The following are the items to be checked in the results that are output by the adbdbstatus command:
- Organization of this subsection
(1) Checking the usage rate of each DB area
Using a value output under DBarea_name as a key, check the associated value output under Used_ratio. If the value output under Used_ratio is close to 100%, consider one of the following corrective measures based on the type of DB area file.
- When the DB area file is a block special file
-
If you continue to store data when the value is close to 100%, the DB area file might become full. Therefore, consider allocating free space on the disk that stores block special files based on the explanation in 15.3.1 When a free space shortage is caused by an increase in the size of the DB area files.
- When the DB area file is a regular file
-
If you continue to store data when the value is close to 100%, the DB area will be extended automatically. When automatic extension occurs, the size of the DB area will automatically increase, but the performance of update processing while DB area file expansion is underway will decline. If DB area automatic extension fails, see 15.3.2 When a free space shortage is caused by failed DB area automatic extension.
(2) Checking the usage of each DB area
Using the value output under DBarea_name, check the value output under MB_Used_segments. You can determine the size of the area (in megabytes) that is being used to store data in each DB area.