13.10.7 Finding the total size of all archive files corresponding to an archived chunk created in a specific table (outputting summary information of an archived chunk)

The total size (units: bytes) of all archive files corresponding to the archived chunk created in a specific table (ADBUSER01.TABLE01) is found by outputting summary information from the archived chunk.

▪ Example of executing the adbdbstatus command

adbdbstatus -c archivechunk           ...1
            -n ADBUSER01.TABLE01      ...2
            -r 2015/01/01-2015/12/31  ...3

Explanation:

Archived chunks are specified as a range from which to obtain summary information.
The table name (ADBUSER01.TABLE01) from which to obtain summary information about archived chunks is specified. The archivable multi-chunk table must be specified at this time.
A range of dates (2015/01/01-2015/12/31) for which to output chunk information is specified based on the values of the archive range columns corresponding to the chunks.

The data type in the archive range column is DATE.

When the adbdbstatus command is executed, the summary information of archived chunks created in the table ADBUSER01.TABLE01 is output.

In the following procedure, the total size (units: bytes) of all archive files corresponding to the archived chunks is found based on the output results.

[Figure]

Procedure

Check the table schema name and table identifier.

Verify that the schema name (ADBUSER01) of the table is output in the column headed Schema_name (column 3 in the output results) and the table identifier (TABLE01) is output in the column headed Table_identifier (column 4 in the output results).
Find the total size (units: bytes) of all archive files corresponding to the archived chunks.

Find the value of the Archive_file_size column (15th column in the output results).

To Page Top