43.3.1 When unarchiving chunks that include specific date range data

Unarchive chunks that were created in a table, that include specific date range data, 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, unarchive chunks 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

Create an unarchive chunk option file.
Execute the adbunarchivechunk command.

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

Organization of this subsection

(1) Creating an unarchive chunk option file
(2) Executing the adbunarchivechunk command

(1) Creating an unarchive chunk option file

Create an unarchive chunk option file, and specify unarchive chunk options in that file. In this example, the number of processing real threads used for executing the adbunarchivechunk command is specified.

Example of specifying an unarchive chunk option file

set adb_unarcv_rthd_num = 2
      :

To Page Top

(2) Executing the adbunarchivechunk command

adbunarchivechunk -u ADBUSER01                                  ...1
                  -p '#HelloHADB_01'                            ...2
                  -z /home/adbmanager/unarchive_file/env01.txt  ...3
                  -r 2010/01/01-2010/12/31                      ...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.
Specifies the absolute path name of the unarchive chunk option file created in (1) Creating an unarchive chunk option file.
Uses dates to specify a range of chunks to be unarchived.
Specifies the table to be processed.

To Page Top