DB2 Replication Guide and Reference

Operating Apply for OS/2

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

• Starting
• Scheduling
• Stopping

Before You Start the Apply Program

Before you start the Apply program, ensure that:

• The control tables are defined.

• 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 Apply Program for information about authorization for the Apply program.

Starting Apply for OS/2

When 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:

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---+
                                         '-NOLOADXit-'
 
>-----+----------+---+---------+---+----------+---+---------+--->
      +-INAMsg---+   +-NOTRC---+   +-NOTIFY---+   +-SLEEP---+
      '-NOINAMsg-'   +-TRCERR--+   '-NONOTIFY-'   '-NOSLEEP-'
                     '-TRCFLOW-'
 
>-----+----------+---------------------------------------------><
      +-DELAY(n)-+
      '-DELAY(6)-'
 

Table 14 defines the optional positional parameters.

Table 14. ASNAPPLY Parameter Definitions for OS/2

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 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 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 is an optional keyword parameter. 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 continous replication is used.

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 to schedule the Apply program to start at a specific time.

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 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 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 window in which the Apply program is running.

[ DB2 List of Books | Search the DB2 Books ]