2.3.1 When archiving chunks that include specific date range data

Archive 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, archive chunks 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

Create an archive chunk option file.
Execute the adbarchivechunk command.

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

Organization of this subsection

(1) Creating an archive chunk option file
(2) Executing the adbarchivechunk command

(1) Creating an archive chunk option file

Create an archive chunk option file, and specify archive chunk options in that file.

Example of an archive chunk option file

set adb_arcv_rthd_num = 9         ...1
set adb_arcv_scan_buff_size = 64  ...2

Explanation:

Specifies the number of processing real threads to be used for executing the adbarchivechunk command.
Specifies the size of the buffer to be used for retaining table data search results.

To Page Top

(2) Executing the adbarchivechunk command

adbarchivechunk -u ADBUSER01                                ...1
                -p '#HelloHADB_01'                          ...2
                -z /home/adbmanager/archive_file/env01.txt  ...3
                -r 2011/01/01-2011/12/31                    ...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.
Specifies the absolute path name of the archive chunk option file created in (1) Creating an archive chunk option file.
Specify a date range of chunks to be archived.
Specifies the table to be processed.

To Page Top