Replication Guide and Reference

Stopping the Capture and Apply Programs

To stop the Capture and Apply programs after the user copy replication is complete:

1. Stop the Capture program.

   1. From a DB2 command window, use the SET command to set the environment variable DB2DBDFT to the source server name:

      SET DB2DBDFT=SAMPLE
      

   2. Enter the following command from the same DB2 command window:

      ASNCMD STOP
      

   You can alternatively use one of the following key combinations from the window where the Capture program is running:

   • Ctrl+C
   • Ctrl+Break

2. Stop the Apply program.

   1. From a DB2 command window, use the SET command to set the environment variable DB2DBDFT to the target server name:

      SET DB2DBDFT=COPYDB
      

   2. Enter the following command from the same DB2 command window:

      ASNASTOP DEPTQUAL
      

   You can alternatively use one of the following key combinations from the window where the Apply program is running:

   • Ctrl+C
   • Ctrl+Break

Sample data for the target table results after one iteration are shown in Table 5. Note that the order of the target table columns has changed, but the data remains the same as for the sample source table.

Table 5. DEPARTCOPY Table Results

ADMRDEPT	DEPTNAME	XDEPTNO	DEPTNO	MGRNO
A00	Spiffy Computer Service	--	A00	000010
A00	Planning	--	B01	000020
A00	Information Center	--	C01	000030
A00	Development Center	--	D01	-
D01	Manufacturing Systems	--	D11	000060
D01	Administration Systems	--	D21	000070
A00	Support Services	--	E01	000050
E01	Operations	--	E11	000090
E01	Software Support	--	E21	000100

[ DB2 List of Books | Search the DB2 Books ]