2.3.2 When you want to check which chunks are to be archived based on a specified date range before actually executing chunk archive processing

Check which chunks are to be archived based on a specified date range before actually executing chunk archive processing, under the following conditions:

The base table TABLE01 is an archivable multi-chunk table.
The data type in the archive range column of the base table TABLE01 is DATE.
Among the chunks created in the base table TABLE01, check the chunk IDs of the chunks subject to archiving whose values in the archive range column contain data in the range from January 1st, 2011 to December 31st, 2011.

[Figure]

This example uses the following procedure to execute the adbarchivechunk command.

Procedure

Execute the adbarchivechunk command.
Check the KFAA80245-I message to see which chunks include data in the specified date range.

Using examples, the following subsections explain each of these steps.

Organization of this subsection

(1) Executing the adbarchivechunk command
(2) Using the KFAA80245-I message to check which chunks include data in the specified date range

(1) Executing the adbarchivechunk command

adbarchivechunk -u ADBUSER01              ...1
                -p '#HelloHADB_01'        ...2
                -r 2011/01/01-2011/12/31  ...3
                -t                        ...4
                TABLE01                   ...5

Explanation:

Specifies the authorization identifier of the HADB user who executes the adbarchivechunk command.
Specifies the password for the authorization identifier that was specified in the -u option.
Specify a date range of chunks to be archived.
Specify this option if you want to check the chunk IDs of chunks that will actually be archived before executing chunk archive processing.
Specifies the table to be processed.

To Page Top

(2) Using the KFAA80245-I message to check which chunks include data in the specified date range

See the KFAA80245-I message that is output after the adbarchivechunk command is executed with the -t option specified.

The KFAA80245-I message outputs the chunk IDs of chunks subject to archiving whose values in the archive range column include data in the specified date range (January 1st, 2011 to December 31st, 2011).

To perform chunk archive processing on these chunks, do not change any options other than the -t option, and execute the adbarchivechunk command with the -t option omitted. To revise which chunks are to be archived, correct the specified date range (in the -r option), and then execute the adbarchivechunk command.

To Page Top