10.9.2 Checking the status and usage of a base table
If you acquire table summary information by using the adbdbstatus command, you can check the status and usage of a base table.
- Organization of this subsection
(1) Checking whether a base table is non-updatable
To check whether a base table is non-updatable, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for table ADBUSER01.T1.
adbdbstatus -d summary -c table -n ADBUSER01.T1
Executing the adbdbstatus command outputs summary information for table ADBUSER01.T1 to the standard output.
In the table summary information, check the value output under Non-updatable. If non-updatable is output, the base table cannot be updated.
To release the base table from non-updatable status, check the values output under Command_status and Rerun_command, and re-execute the command that is output under Rerun_command.
(2) Checking the usage of a base table
To check the usage of a base table, execute the following adbdbstatus command.
- Example of the command to be executed
-
This example outputs summary information for table ADBUSER01.T1.
adbdbstatus -d summary -c table -n ADBUSER01.T1 -S M --shared-lock
Executing the adbdbstatus command outputs summary information for table ADBUSER01.T1 to the standard output.
In the table summary information, check the value output under MB_Used_pages. You can determine the size of the area (in megabytes) that is being used by the base table data stored in the DB area.