HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide

[Contents][Glossary][Index][Back][Next]

5.10.6 Import group definition

An import group definition defines an import group as an execution unit when a table-based import method (table-based partitioning method, key range-based partitioning method, or hash partitioning method) is used for parallel execution of import processing on the groups. You can define a maximum of 128 import groups. For details about the specification of field names, authorization identifiers, and table identifiers, see 5.10.1 Definition rules.

Organization of this subsection
(1) Format
(2) Explanation of the operands
(3) Grouping by the import group definition
(4) Rules for specifying key range partitioning
(5) Notes

(1) Format

[{{ group import-group-name
  by [authorization-identifier.]table-identifier[{{,[authorization-identifier.]
table-identifier }} ...]
/**** Definition of key range-based partitioning method ****/
  [{{[ in 'target-FES's-host-name'/'target-FES's-server-identifier'
                [/'target-FES's-port-number']]
   [ having key-range-partitioning-condition-statement[{{,key-range-partitioning-condition
-statement}} ...]|other ]
  }} ...]
/**** Definition of hash partitioning method ****/
  [{{ hash
   { in 'target-FES's-host-name'/'target-FES's-server-identifier'
                  [/'target-FES's-port-number']
[(RDAREA-name {{,RDAREA-name}} ...|other)]
    [{{ ,'target-FES's-host-name'/'target-FES's-server-identifier'
                 [/'target-FES's-port-number'] ]
[(RDAREA-name {{,RDAREA-name}} ...|other)]
    |divide into SQL-process-segments-count }
  }} ...]]

(2) Explanation of the operands

  1. Specify other at the end of the last in clause.
    Correct:
    in 'host1'/'fes1'(rdarea1,rdarea2),
    'host2'/'fes2'(rdarea3,rdarea4),
    'host3'/'fes3'(other)
    Wrong:
    in 'host1'/'fes1'(rdarea1,rdarea2),
    'host2'/'fes2'(other),
    'host3'/'fes3'(rdarea5,rdarea6)
    In the example of a wrong specification, you can avoid the error by swapping lines 2 and 3.
  2. other cannot be specified together with another RDAREA.
    Wrong (1):
    in 'host1'/'fes1'(rdarea1,rdarea2),
    'host2'/'fes2'(rdarea3,rdarea4),
    'host3'/'fes3'(rdarea5,other)
    In the example of wrong specification (1), you can avoid the error by deleting other.
    Wrong (2):
    in 'host1'/'fes1'(rdarea1,rdarea2),
    'host2'/'fes2'(rdarea3,other),
    'host3'/'fes3'(rdarea5,rdarea6)
    In the example of wrong specification (2), you can avoid the error by swapping lines 2 and 3 and deleting other.

Unlike a key range, the hash option cannot be used to exclude an unspecified range from import processing. The omitted RDAREAs are applied to the last FES specification. Therefore, we recommend that you define all RDAREA names in your FES specifications without omitting any of them.

(3) Grouping by the import group definition

When an import group definition is specified, the target Datareplicator divides the import processing into the specified groups and executes them in parallel. You can use an import group definition to create a maximum of 128 import groups. The table below explains the use of an import group definition to create import groups. Note that if you are defining a target group that employs key range-based partitioning or hash range partitioning, make sure that PURGE TABLE is not executed on the table.

Table 5-20 Use of an import group definition to create import groups

Classification of import processing Creation of import groups during import processing
Importing data into the table specified in the import group definition Datareplicator creates groups according to specifications in the import group definition.
Importing data into a table that is not specified in the import group definition Datareplicator creates one group for all tables subject to import processing that are not specified in the import group definition.
Importing with a UOC routine Datareplicator creates a group for each UOC routine and automatically assigns group names in the range UOC001 to UOC128.

(4) Rules for specifying key range partitioning

The following are the rules for specifying key range partitioning conditions:

#: In the case of date data, Datareplicator only checks to determine whether the date is after the last date of the month. Datareplicator does not check for a leap year.

(5) Notes

If you modify an import group definition while import processing is stopped for a reason other than normal termination or event termination, a loss of conformity might occur in the import processing between before and after the modification.

[Contents][Back][Next]

[Trademarks]

All rights reserved. Copyright (C) 2007, 2013, Hitachi, Ltd.