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

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

6.1 Operating procedure

This section explains the HiRDB Dataextractor operating procedure.

Organization of this section
(1) Data extraction and import between HiRDBs
(2) Importing data extracted from ORACLE to HiRDB
(3) Data extraction and import between mainframe database and HiRDB or ORACLE
(4) Creating a file with extracted data
(5) Notes

(1) Data extraction and import between HiRDBs

To extract data from a HiRDB and then import it into another HiRDB, you specify the data extraction and import procedures in HiRDB Dataextractor's xtrep command on the source system.

When the xtrep command is executed on the source system, HiRDB Dataextractor starts in order to execute extraction processing, extracts data, and then sends it to the target system. When data is received on the target system, HiRDB Dataextractor starts automatically and executes import processing.

(2) Importing data extracted from ORACLE to HiRDB

To extract data from an ORACLE database and then import it into a HiRDB, you specify the data extraction and import procedures in HiRDB Dataextractor's xtrepO command on the source system.

When the xtrepO command is executed on the source system, HiRDB Dataextractor starts in order to execute extraction processing, extracts data, and then sends it to the target system. When data is received on the target system, HiRDB Dataextractor starts automatically and executes import processing.

(3) Data extraction and import between mainframe database and HiRDB or ORACLE

To extract data from a mainframe database and then import it into a HiRDB or to extract data from a HiRDB or ORACLE database and then import it into XDM/RD, you specify the data extraction and import procedures in XDM/XT on the VOS3 system.

In the case of data extraction from a mainframe database followed by data import into HiRDB, when the target system receives the data from XDM/XT, HiRDB Dataextractor starts according to specified information and executes import processing.

In the case of data extraction from a HiRDB or ORACLE database followed by data import into XDM/RD, HiRDB Dataextractor is started by XDM/XT on the source system according to specified information, it executes extraction processing, and then it sends the data to XDM/XT. XDM/XT outputs the received data to an extraction dataset so that data from this dataset can be imported into XDM/RD.

(4) Creating a file with extracted data

To create a file with data extracted from a HiRDB or ORACLE database, you specify the data extraction and file creation procedures in HiRDB Dataextractor's xtrep or xtrepO command on the source system.

If you execute the xtrep or xtrepO command on the source system, HiRDB Dataextractor starts in order to execute extraction processing and sends the extracted data to the file creation system. When the file creation system receives the data, it starts HiRDB Dataextractor automatically, and then HiRDB Dataextractor starts file creation processing.

To extract data from a mainframe database and then create a file, you specify the database extraction and file creation procedures in XDM/XT on the VOS3 system.

When the system on the file creation system receives data from XDM/XT, HiRDB Dataextractor starts according to the specified information and executes file creation processing.

(5) Notes

The directories listed below contain the files that are created dynamically by HiRDB Dataextractor during operation. You should delete these files periodically while HiRDB Dataextractor is stopped.