13.10.4 Checking the status 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:

■ adbdbstatus command that is executed

adbdbstatus -c table              ...1
            -n ADBUSER01.TABLE01  ...2

Explanation:

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

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) Determining whether the table is non-updatable

[Figure]

To determine whether table ADBUSER01.TABLE01 is non-updatable:

Check the schema name and table identifier of the table.

Verify that the schema name (ADBUSER01) of the table is output in the column headed Schema_name (column 5 in the output results) and the table identifier (TABLE01) is output in the column headed Table_identifier (column 6 in the output results).
Determine whether the table is non-updatable.

If the table is non-updatable, non-updatable is displayed in the column headed Non-updatable (column 16 in the output results). To release the table from non-updatable status, re-execute the command displayed in the Rerun_command column (column 18 in the output results).

In this example, to release table ADBUSER01.TABLE01 from non-updatable status, the adbimport command must be re-executed.

Note

If the --shared-lock option is specified, no_check is displayed in the column headed Non-updatable (column 16 in the output results). Information about whether the table is non-updatable is not output. If you want to determine whether the table is non-updatable, do not specify the --shared-lock option.

[Figure]

To check the termination status of the command executed on table ADBUSER01.TABLE01:

Check the schema name and table identifier of the table.

Verify that the schema name (ADBUSER01) of the table is output in the column headed Schema_name (column 5 in the output results) and the table identifier (TABLE01) is output in the column headed Table_identifier (column 6 in the output results).
Check the termination status of the command executed on the table.

If the command must be re-executed on the table, abort is output in the column headed Command_status (column 17 in the output results). If abort is output, re-execute the command displayed in the column headed Rerun_command (column 18 in the output results).

In this example, the adbimport command must be re-executed for table ADBUSER01.TABLE01.

Note

If the --shared-lock option is specified, no_check is displayed in the column headed Command_status (column 17 in the output results). The command termination status is not output. If you want to check the termination status of the command executed on the table, do not specify the --shared-lock option.