33.3.2 Merging any chunks (other than the current chunk)

This example merges under the following conditions any chunks other than the current chunk into a new chunk:

CHUNK is specified when table TABLE01 is defined (table TABLE01 is a multi-chunk table).
B-tree, text, and range indexes are defined for table TABLE01.
Data was imported into table TABLE01 by applying the background-import facility twice.
Table TABLE01 has chunks with chunk IDs 1, 2, and 3.
The chunk ID of table TABLE01's current chunk is 3.

[Figure]

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

Procedure

Create a merge chunk option file.
Execute the adbmergechunk command.

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

Organization of this subsection

(1) Creating a merge chunk option file
(2) Executing the adbmergechunk command

(1) Creating a merge chunk option file

This example creates a merge chunk option file and specifies merge chunk options in that file.

Example of a merge chunk option file

set adb_mergechunk_rthd_num = 3
set adb_mergechunk_scan_buff_size = 2
      :

To Page Top

(2) Executing the adbmergechunk command

adbmergechunk -u ADBUSER01                                       ...1
              -p '#HelloHADB_01'                                 ...2
              -z /home/adbmanager/merge_file/mergechunk_opt.txt  ...3
              -m 'January 2014'                                  ...4
              -c 1,2                                             ...5
              TABLE01                                            ...6

Explanation:

Specifies the authorization identifier of the HADB user who executes the adbmergechunk command.
Specifies the password for the authorization identifier that is specified in the -u option.
Specifies the absolute path name of the merge chunk option file created in (1) Creating a merge chunk option file.
Specifies a comment to be set in the merge-target chunk.
Specifies the merge-source chunk IDs.

This example merges chunks with chunk IDs 1 and 2. After the adbmergechunk command has executed, the chunk with chunk ID 3 remains as the current chunk.
Specifies the table to be processed (TABLE01).

To Page Top