DB2 Replication Guide and Reference

Operating Apply for Windows NT and Windows 95

An administrator can use the commands in the following sections to perform the following Apply for Windows NT tasks:

• Starting
• Scheduling
• Stopping

Before You Start the Apply Program

Before you start the Apply program, ensure that:

• The control tables are defined.

• A password file has been created, if necessary, for end-user authentication at the source server. See Providing End-User Authentication at the Source Server for more information.

• At least one subscription is created and activated.

• The Apply for Windows NT package is created. See Configuring the Apply Program for Windows NT and Windows 95 for information on bind programs to create the Apply packages.

• You have the proper authorization. See Authorization Requirements for the Apply Program for information about authorization for the Apply program.

Starting Apply for Windows NT and Windows 95

After you start the Apply program, it runs continuously until:

• You stop it in an orderly way.

• An unexpected error or failure occurs.

To start the Apply program using the NT services:

1. Select Replication from the NT Services window.

2. Click on the START push button. The Apply program starts according to the ASCII file information you provided.

You can also start the replication service by typing STRTSERV on the NT command line.

To start the Apply program using the DB2 command window:

1. Ensure that you set the DB2 instance as shown:

   SET DB2INSTANCE=db2_instance_name
   

2. Enter the ASNAPPLY command and one or more options from the Windows NT or Windows 95 window.

>>-ASNAPPLY--Apl_qual----+-----------+---+-----------+---------->
                         '-Ctrl_serv-'   +-LOADXit---+
                                         '-NOLOADXit-'
 
>-----+----------+---+---------+---+----------+---+---------+--->
      +-INAMsg---+   +-NOTRC---+   +-NOTIFY---+   +-SLEEP---+
      '-NOINAMsg-'   +-TRCERR--+   '-NONOTIFY-'   '-NOSLEEP-'
                     '-TRCFLOW-'
 
>-----+----------+---------------------------------------------><
      +-DELAY(n)-+
      '-DELAY(6)-'
 

Table 12 defines the optional positional parameters.

Table 12. ASNAPPLY Parameter Definitions for NT

Parameter Definition
Apl_qual Specifies the Apply program qualifier the Apply program instance uses to identify the subscriptions to be served. The Apply qualifier is case sensitive and must match the value of APPLY_QUAL in the subscription set table. This is a positional parameter that is required as the first parameter.
Ctrl_serv Specifies the name of the server where the replication control tables will reside. If you do not specify this optional positional parameter, the default is the default database or the value of DB2DBDFT for DB2 for Windows NT or Windows 95.
LOADXit Specifies that the Apply program is to invoke ASNLOAD, an exit program that can call an IBM or multivendor utility, to initialize a target table. This keyword parameter is optional. NOLOADXit  (default)  Specifies that the Apply program will not invoke ASNLOAD.
INAMsg  (default)  Specifies that the Apply program is to issue a message when the Apply program is inactive. NOINAMsg Specifies that the Apply program will not issue this message. This keyword parameter is optional.
NOTRC  (default)  Specifies that the Apply program does not generate a trace. TRCERR Specifies that the Apply program generates a trace that contains only error information. This keyword parameter is optional. TRCFLOW Specifies that the Apply program generates a trace that contains error and execution flow information. This keyword parameter is optional.
NOTIFY Specifies that the Apply program is to invoke ASNDONE, an exit program that returns control to the user when the Apply program processing ends. This keyword parameter is optional. NONOTIFY  (default)  Specifies that the Apply program will not invoke ASNDONE.
SLEEP  (default)  Specifies that the Apply program is to go to sleep if no new subscriptions are eligible for processing. NOSLEEP Specifies that the Apply program is to stop if no new subscriptions are eligible for processing. This keyword parameter is optional.
DELAY(n) Where n=0, 1, 2, 3, 4, 5, or 6. Specifies the delay time (in seconds) at the end of each Apply program cycle when continuous replication is used. This keyword parameter is optional. DELAY(6)  (default)  Specifies a delay time of 6 seconds at the end of each Apply program cycle when continuous replication is used.

When Apply for Windows NT or Windows 95 executes, it generates two files:

• <userid><database_instance_name><database_name>.LOG

  This file is created in the directory where Apply for Windows NT or Windows 95 is invoked. It contains messages issued by Apply for Windows NT or Windows 95.

• <userid><database_instance_name><database_name>.SPL

  This file is created in the directory where Apply for Windows NT or Windows 95 is invoked. It is an internal file used by Apply for Windows NT or Windows 95. Do not erase it.

Scheduling Apply for Windows NT and Windows 95

Use the Windows NT or Windows 95 AT command to start the Apply program at a specific time. For example, the following command string starts Apply for Windows NT at 15:00.

c:\>AT 15:00 /interactive "c:\SQLLIB\BIN\db2cmd.exe
    c:\SQLLIB\BIN\asnapply.exe qualid1 cntldb"

Stopping Apply for Windows NT and Windows 95

Use the following command to stop Apply for Windows NT or Windows 95.

>>-ASNASTOP--Apply_qualifier-----------------------------------><
 

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

• Ctrl+C
• Ctrl+Break

Purpose

Use the ASNASTOP command or the key combination to stop the Apply program in an orderly way and commit the log records that it processed up to that point.

Usage

To use the command, do the following from a different window than where the Apply program is running:

1. Set environment variable DB2INSTANCE to the value that was set when the Apply program was started.

2. Set environment variable DB2DBDFT to the source server specified when the Apply program was started (or the DB2DBDFT value that was used when the Apply program was started).

3. Enter the command.

To use one of the key combinations, press it from the same window in which the Apply program is running.

[ DB2 List of Books | Search the DB2 Books ]