-
Book Overview & Buying
-
Table Of Contents
IBM InfoSphere Replication Server and Data Event Publisher
By :
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
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 |
|---|---|
|
|
Location of Q Apply work files ( |
|
|
Name of schema used to identify Q Apply. |
|
|
Change the font size
Change margin width
Change background colour