IBM DB2 Everyplace Sync Server Administration Guide Version 7 Release 2 Modification 1


Starting the DataPropagator Capture program

The Capture program on the source system must be running continuously not only to capture changes made to the source database by the Sync Server, but possibly by other applications as well. If the source server is restarted, you must restart the Capture program before attempting to synchronize.

See the DB2 Universal Database Replication Guide and Reference for information on the authorization you need to run the Capture program.

How you start the Capture program depends on the operating system of the source server.

Windows and UNIX systems

Use the ASNCCP command to start capturing changes to a Windows or UNIX source database.

To start the Capture program on a Windows source server

  1. On the Windows NT workstation desktop, open a DB2 command window by selecting Start --> Programs --> DB2 for Windows --> Command Window.
  2. The first time you start the Capture process, enter the following command:
    ASNCCP database_name
    

    where database_name is the name of the source database with which you will synchronize.

    If you are restarting the Capture process, issue the following command:

    ASNCCP database_name warmns
    
    The Capture process started by the ASNCCP command runs continuously.

You can also operate the Capture program by using the Windows NT Service Control Manager. The Service Control Manager enables you to automatically start the Capture and Apply programs as services from the NT Control Panel. See the DB2 Universal Database Replication Guide and Reference for information on how to set up the NT service.

To start the Capture program on a UNIX source server

  1. Make sure the DB2 database manager has started. If not, issue the db2start command on the UNIX terminal.
  2. On the UNIX terminal, the first time you start the Capture process, enter the following command:
    ASNCCP database_name
    
    where database_name is the name of the source database with which you will synchronize. The command must be issued in a directory for which you have the write privilege.

    If you are restarting the Capture process, issue the following command:

     ASNCCP database_name warmns
    

The Capture process started by the ASNCCP command runs continuously.

Note:The warmns parameter of the ASNCCP command forces a warm start of the Capture program so that processing continues where it ended in its previous run. Additional program parameters for the ASNCCP command are documented in the DB2 Universal Database Replication Guide and Reference. Although you might issue parameters with the ASNCCP command, avoid using the following parameters, which negatively affect synchronization:

COLD

This parameter causes the Sync Server to treat every row in the source database as a changed row, and will seriously degrade performance.

AUTOSTOP

This parameter forces the Capture program to stop after capturing all transactions in the source database log. The Sync Server requires the Capture program to run continuously on the source server.

CHGONLY

This parameter is not recommended. See the DB2 Universal Database Replication Guide and Reference for more information.

AS/400 systems

Use the STRDPRCAP (Start DPR Capture) command to start capturing changes to the AS/400 source database. Because this command processes all replication sources in the register table, make sure that the user running this command has the proper authority.

Specify a value of 5 for the DPRVSN (DataPropagator version) parameter. Do not cold start the Capture program (by issuing a value of NO for the RESTART parameter), because this causes the Sync Server to treat every row in the source database as a changed row, seriously degrading performance.

OS/390 systems

If your source system is an OS/390 system, you can use JCL to start the Capture program or you can start the program as a system-started task. See the DB2 Universal Database Replication Guide and Reference for more information on how to perform these tasks. Do not use the COLD and CHGONLY parameters for reasons given in Windows and UNIX systems.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]