43.3.2 When you want to check which chunks are to be unarchived based on a specified date range before actually executing chunk unarchive processing

Check which chunks are to be unarchived based on a specified date range before actually executing chunk unarchive 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 to be unarchived whose values in the archive range column contain data in the range from January 1st, 2010 to December 31st, 2010.

[Figure]

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

Procedure

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

Using an example, the following subsections explain each of these steps.

Organization of this subsection

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

(1) Executing the adbunarchivechunk command

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

Explanation:

Specifies the authorization identifier of the HADB user who executes the adbunarchivechunk command.
Specifies the password for the authorization identifier that was specified in the -u option.
Uses dates to specify a range of chunks to be unarchived.
This option is specified in order to check the chunk IDs of chunks that will actually be unarchived before executing chunk unarchive 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 adbunarchivechunk command is executed with the -t option specified.

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

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

To Page Top