Starting a Q Apply program

When you start a Q Apply program, it begins reading transaction messages from queues and applying the transactions to target tables or stored procedures.

Before you begin

If you are starting the Q Apply program from a remote workstation, configure connections to the Q Apply server.
Create and configure an IBM® MQ queue manager, queues and other necessary objects.
Ensure that you have authorization for Q Replication objects and MQ objects.
Create Q Apply control tables.
Configure the target database or subsystem to work with the Q Apply program.
If you have Q subscriptions that specify an automatic load that uses the EXPORT utility, create a password file so that Q Apply can connect to the Q Capture server.

About this task

When you start a Q Apply program, you can specify startup parameters and the program will use the new values until you take one of the following actions:

You change the parameter values while the program is running
You stop and restart the program, which prompts it to read the IBMQREP_APPLYPARMS table and use the values saved there.

Procedure

To start a Q Apply program, use one of the following methods:

Method Description

Method	Description
z/OS® console or TSO	On z/OS, you can start a Q Apply program by using JCL or as a system-started task. You can specify new invocation parameter values when you start a Q Apply program with JCL. z/OS has a 100-byte limit for the total length of parameters that you can specify in the PARMS= field. To overcome this limitation, replication programs now allow you to specify as many additional parameters as needed in the SYSIN data set. When the SYSIN DD statement is included in the invocation JCL, the Q Apply program automatically concatenates what is specified in the SYSIN dataset to the PARMS= parameters. You can only specify Q Apply parameters in the SYSIN data set. Any LE parameters must be specified in the PARMS= field or in LE _CEE_ENVFILE=DD, followed by a slash(/). Example: `//* asterisk indicates a comment line // QAPP EXEC PGM=ASNQAPP,PARMS='LE/Q Apply parameters' //* Parameters can be any or no LE parameters and any or //* no Q Apply parameters //SYSIN DD * //* additional Q Apply parameters, one or more //* parameters on each line APPLY_SERVER=DSN!! APPLY_SCHEMA=APPCAT DEBUG=Y LOGSTDOUT=N`
asnqapp command	From a command line, use the asnqapp command to start a Q Apply program and optionally specify startup parameters: `asnqapp apply_server=server_name apply_schema=schema parameters` Where `server_name` is the name of the database or subsystem where the Q Apply control tables are defined and where the Q Apply program will apply changes to targets, `schema` identifies the Q Apply program that you want to start, and `parameters` is one or more parameters that you can specify at startup.
Windows Service	You can create a replication service on the Windows operating system to start the Q Apply program automatically when the system starts.

z/OS® console or TSO

On z/OS, you can start a Q Apply program by using JCL or as a system-started task. You can specify new invocation parameter values when you start a Q Apply program with JCL.

z/OS has a 100-byte limit for the total length of parameters that you can specify in the PARMS= field. To overcome this limitation, replication programs now allow you to specify as many additional parameters as needed in the SYSIN data set.

When the SYSIN DD statement is included in the invocation JCL, the Q Apply program automatically concatenates what is specified in the SYSIN dataset to the PARMS= parameters. You can only specify Q Apply parameters in the SYSIN data set. Any LE parameters must be specified in the PARMS= field or in LE _CEE_ENVFILE=DD, followed by a slash(/).

Example:

//* asterisk indicates a comment line
// QAPP EXEC PGM=ASNQAPP,PARMS='LE/Q Apply parameters'
//* Parameters can be any or no LE parameters and any or
//* no Q Apply parameters
//SYSIN DD *
//* additional Q Apply parameters, one or more
//* parameters on each line
  APPLY_SERVER=DSN!! APPLY_SCHEMA=APPCAT 
  DEBUG=Y LOGSTDOUT=N

asnqapp command

From a command line, use the asnqapp command to start a Q Apply program and optionally specify startup parameters:

asnqapp apply_server=server_name
apply_schema=schema
parameters

Where server_name is the name of the database or subsystem where the Q Apply control tables are defined and where the Q Apply program will apply changes to targets, schema identifies the Q Apply program that you want to start, and parameters is one or more parameters that you can specify at startup.

Windows Service You can create a replication service on the Windows operating system to start the Q Apply program automatically when the system starts.

You can verify whether a Q Apply program started by using one of the following methods:

Examine the Q Apply diagnostic log file (apply_server.apply_schema.QAPP.log on z/OS and db2instance.apply_server.apply_schema.QAPP.log on Linux, UNIX, and Windows) for a message that indicates that the program is capturing changes.
Check the IBMQREP_APPLYTRACE table for a message that indicates that the program is capturing changes.
z/OS: If you are running in batch mode, examine the z/OS console or z/OS job log for messages that indicate that the program started.
Use the Q Apply Messages window in the Replication Center to see a message that indicates that the program started. To open the window, right-click the Q Apply server that contains the Q Apply program whose messages you want to view and select Reports > Q Apply Messages.