Q Apply administration

Let's recap the major tasks that Q Apply performs:

• Realizes that a Q subscription is ready to be processed

• Performs a full refresh of the target table (if specified)

• Replicates new changes from its Receive Queues to the target tables

Starting Q Apply

The asnqapp command is used to start Q Apply and has numerous parameters, which are discussed next. To start Q Apply we need to be either DBADM or SYSADM and have write authority on the directory where Q Apply will write its log (c:\temp in our scenario). If we had specified that Q Apply should do an automatic load, then Q Apply needs SELECT authority on the source tables. The command is:

asnqapp [<parameter>=<value> ...]

The parameters are shown next (with corresponding column names in the IBMQREP_APPLYPARMS table shown in brackets after each parameter):

Parameter	Description
APPLY_PATH=	Location of Q Apply work files (APPLY_PATH).
APPLY_SCHEMA=ASN	Name of schema used to identify Q Apply.
APPLY_SERVER=DB2DBDFT...