Q Capture administration

Let's quickly recap the major tasks that Q Capture performs:

• To "read" the DB2 log, and put committed transactions onto its Send Queue

• To keep track of what has been processed

• Initiates pruning of the control tables

Starting Q Capture

The asnqcap command is used to start Q Capture and has numerous parameters, discussed next. To issue the command we need to be either DBADM or SYSADM for the database and have write authority on the directory where Q Capture will write its log (c:\temp in our scenario). The command is:

$ asnqcap [<parameter>=<value> ...]

The parameters are:

Parameter	Description
ADD_PARTITION=Y|N	Determines whether Q Capture starts reading the log file for partitions that were added since the last time Q Capture was restarted.
AUTOSTOP=Y|N	Terminate Q Capture after hitting end of log.
CAPTURE_PATH=	Location of Q Capture log files.
CAPTURE_SCHEMA=	Name of schema used to identify Q Capture.
CAPTURE_SERVER=	Name of the Q Capture control...