The method of checking the extraction and import status depends on whether the import transaction synchronization facility is used. The following table shows how to check the extraction and import status.

Table 3-22 How to check the extraction and import status

Purpose	When this facility is not used	When this facility is used
To determine how much of the source database's update information has been imported	At the end of a job, execute the hdeevent command to check the KFRB03211-I message that is output at the target system, in order to make sure that the update information has been imported through the last job.	Use the method described in 3.7.9 Examples.
To determine whether all log information has been extracted from the system log	After executing the pdlogsync -d sys command, execute the pdls -d rpl -j command and make sure that (1) below is greater than (2) below: SYSTEMID : HRD1(183346) Data replication : Y UNITID : unt1(183346) Data replication : Y SERVER NAME : sds01 Extract Database : Y Extract Status : C System Log Extract Point : Run ID Group Gen No. BLock No. 41418a08 log5 2 4e ...(1) System Log Sync Info : Run ID Group Gen No. BLock No. 41418a08 log5 2 4c ...(2)	Same as when this facility is not used.
To terminate the source Datareplicator after sending all log information from the extraction information queue file	Place the table subject to extraction in unupdatable status, and then enter the hdestate command. Next, make sure that the read position and write position match in all back-end servers, and then execute the hdestop command.	Place the table subject to extraction in unupdatable status, and then execute a synchronous event. Next, make sure that the read position and write position match in all back-end servers, and then execute the hdestop command.
To terminate the import Datareplicator after importing all log information from the import information queue file	Enter the hdsstate command while the source Datareplicator is terminated, make sure that each data linkage identifier's read position and write position match, and then execute the hdsstop command.	Place the table subject to extraction in unupdatable status, and then execute a synchronous event. Next, make sure that the read position and write position match in all back-end servers, and then execute the hdestop command to terminate the source Datareplicator. In the status of 1, execute the hdsstop command.