Replication Guide and Reference

Operating Apply for OS/2

The IBM Replication administrator can use the commands in the following sections to perform the following Apply for OS/2 tasks:

• Starting
• Scheduling
• Stopping

Before You Start theApply Program

Before you start the Apply program, ensure that:

• The administrator has created the control tables.

• At least one subscription is created and activated.

• The Apply for OS/2 package is created. See "Configuring the Apply Program for OS/2" for information on bind programs to create the Apply for OS/2 package.

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

Starting Apply for OS/2

After you start Apply, it runs continuously until:

• You stop it in an orderly way.

• An unexpected error or failure occurs.

To start Apply:

Perform the following steps from an OS/2 window:

1. Log on with the IBM Replication user ID.

2. Ensure that you set the DB2 instance name as shown:

   SET DB2INSTANCE=db2_instance_name
   

3. Enter the ASNAPPLY command and one or more options, if desired, from the OS/2 window.

>>-ASNAPPLY--Apl_qual---+-----------+-+-----------+-+----------+>
                        +-Ctrl_serv-+ +-LOADXit---+ +-INAMsg---+
                                      +-NOLOADXit-+ +-NOINAMsg-+
 
>--+---------+-+----------+------------------------------------><
   +-NOTRC---+ +-NOTIFY---+
   +-TRCERR--+ +-NONOTIFY-+
   +-TRCFLOW-+
 

Table 14 defines the optional positional parameters.

Table 14. ASNAPPLY Parameter Definitions for OS/2

Parameter Definition
Apl_qual Specifies the Apply qualifier that the Apply instance uses to identify the subscriptions to be served. This positional parameter is required as the first parameter.
Ctrl_serv Specifies the name of the control server where the subscriptions to be served by this instance of the Apply program reside. If you specify this optional positional parameter, it must be the second parameter. If you do not specify this parameter, the default is the default database or the value of DB2DBDFT for DB2 for OS/2.
LOADXit Specifies that the Apply program is to invoke ASNLOAD, a 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 does not issue a message when the Apply program is inactive. This is an optional keyword parameter.
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 is an optional keyword parameter. TRCFLOW Specifies that the Apply program generates a trace that contains error and execution flow information. This is an optional keyword parameter.
NOTIFY Specifies that the Apply program is to invoke ASNDONE, an exit program that returns control to the user when Apply program processing ends. This is an optional keyword parameter. NONOTIFY  (default)  Specifies that the Apply program does not invoke ASNDONE.

When Apply for OS/2 executes, it generates two files:

• userid.LOG

  This file is created in the directory where Apply for OS/2 is invoked. It contains messages issued by Apply for OS/2.

• userid.SPL

  This file is created in the directory where Apply for OS/2 is invoked. It is an internal file used by Apply for OS/2. Do not erase it.

Scheduling Apply for OS/2

Use the Alarms program in the OS/2 Productivity set.

Stopping Apply for OS/2

Use the following command to stop Apply for OS/2.

>>-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.

   If you want to use one of the key combinations, press it from the same NT window in which the Apply program is running.

[ DB2 List of Books | Search the DB2 Books ]