Linkage to HiRDB Datareplicator and HiRDB Dataextractor

Linking to HiRDB Datareplicator and HiRDB Dataextractor allows you to use the replication facility. The replication facility provides the ability to duplicate the content of a distributed database into another database. Using the replication facility, you can duplicate information from one database into another database on a different system, which helps support the management of data in a distributed system environment. The replication facility includes the following two modes:

Data linkage facility
Database extraction/reflection service facility

Organization of this subsection: (1) Data linkage facility; (2) Database extraction/reflection service facility; (3) Example of using the replication facility; (4) Products required for replication facility; (5) Setting the HiRDB environment when the data linkage facility is used

(1) Data linkage facility

The data linkage facility causes the updates to a database residing on a mainframe DBMS or a HiRDB system to be reflected automatically in HiRDB databases at local nodes. The data linkage facility requires the HiRDB Datareplicator, which is a related HiRDB product. The data linkage facility has the following characteristics:

At fixed time intervals, the data linkage facility copies in sequence all updates to a corporate database into departmental databases so that the latest data available in the corporate database can be used from the departmental databases.
The data linkage facility can extract selected data from a corporate database and copy in sequence all updates to the selected data from the corporate database into departmental databases. In this manner, the data linkage facility is able to provide data that is well-suited for data warehouse applications.

Note: Some columns are not eligible for processing by the data linkage facility, depending on the column attributes. For details about the column attributes that are not supported by the data linkage facility, see the HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide.

(2) Database extraction/reflection service facility

The database extraction/reflection service facility transfers data stored in a mainframe DBMS or another HiRDB system to HiRDB databases at local nodes. The database extraction/reflection service facility requires HiRDB Dataextractor, which is a related HiRDB product. The database extraction/reflection service facility has the following characteristics:

At a specific time, the database extraction/reflection service facility can copy in batch information from a corporate database into departmental databases. In this manner, departmental database tables can be initialized or all data can be updated to the latest version.
By specifying data extraction conditions, the database extraction/reflection service facility can be used to extract selected data from a corporate database so that departmental databases that are appropriate for particular types of operations can be created.
The database extraction/reflection service facility eliminates the need for UAPs that extract data or provide such operations as character code conversion and file transfer.

Note: Some columns are not eligible for processing by the database extraction/reflection service facility, depending on the column attributes. For details about the column attributes that are not supported by the database extraction/reflection service facility, see the HiRDB Dataextractor Version 8 Description, User's Guide and Operator's Guide.

(3) Example of using the replication facility

Figure 2-3 shows an example of using the replication facility.

Figure 2-3 Example of using the replication facility

[Figure]

For details about application examples of the replication facility, see the HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide, and the HiRDB Dataextractor Version 8 Description, User's Guide and Operator's Guide.

(4) Products required for replication facility

(a) Products required in HiRDB systems

The data linkage facility requires HiRDB Datareplicator. The database extraction/reflection service facility requires HiRDB Dataextractor, except when the remote system is RDB1 E2 or PDM II E2 of VOS1.

(b) DBMS products that can be linked to HiRDB using the replication facility

Table 2-2 lists DBMS products that can be linked to HiRDB by means of the replication facility:

Table 2-2 Products that can be linked to HiRDB by means of the replication facility

Linkable DBMS product (and applicable operating system)	Required replication facility product
Linkable DBMS product (and applicable operating system)	Data linkage	Database extraction/reflection service facility
XDM/RD E2 (VOS3)	XDM/DS	XDM/XT
XDM/SD E2 (VOS3)	XDM/DS
ADM (VOS3)	VOS3 Database Datareplicator or XDM/DS
PDM II E2 (VOS3)¹	VOS3 Database Datareplicator or XDM/DS
PDM II E2 (VOS3)¹	File transfer program²
PDM II E2 (VOS1)	File transfer program²	PDM II Dataextractor
TMS-4V/SP (VOS3)	VOS3 Database Datareplicator or XDM/DS	XDM/XT
RDB1 E2 (VOS1)	File transfer program²	RDB1 Dataextractor

¹In the case of PDM II E2 of VOS3, it is possible to perform data linkage using a data linkage product at the same time data linkage is being performed using a file transfer program.

²Both XFIT and an XFIT-related product are needed for the file transfer program. For details, see the HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide.

(5) Setting the HiRDB environment when the data linkage facility is used

When the data linkage facility is used (in conjunction with extracting data for updating HiRDB databases), the following system definition operands must be specified:

pd_rpl_hdepath: Specify the HiRDB Datareplicator operation directory for the extracted side.

pd_rpl_init_start: Specify when the HiRDB linkage facility is to be started.

pd_log_rpl_no_standby_file_opr: Specify the action to be taken if system log information cannot be created in the swapped-in file.