Replication Guide and Reference

Specifying Tuning Parameters for the Capture Program

To control the performance of the Capture program, you can specify the following tuning parameters in the ASN.IBMSNAP_CCPPARMS tuning parameters table:

Retention limit

The number of minutes to keep the change data table rows and the unit-of-work (UOW) table rows. The default value is 10,800, which is 7 days. The rows are deleted up to where the changes have been applied.

Lag limit

The number of minutes the Capture program can be backlogged from the current local time before shutting itself down. The default value is 10,800 (which is 7 days). This value is higher for a busy system; therefore, a lower lag limit shuts down the Capture program. If the Capture program shuts itself down, you should perform a cold start if the database log has been archived and the log has wrapped around.

Commit interval

The number of seconds to wait before issuing a COMMIT statement. The default value is 30 seconds. Set the interval smaller than the DB2 timeout interval if the Capture and Apply programs are running at the same time. If the Apply program is not running at the same time as the Capture program, you can set the commit no higher than the DB2 timeout interval.

Prune interval

The number of seconds to wait before pruning the staging tables. The default value is ten times the commit value or 600 seconds, whichever is larger. This parameter is ignored if you start the Capture program with the NOPRUNE option; however, you can override this option with the PRUNE command.

To specify the tuning parameters, do one of the following tasks:

• Modify DPCNTL.* in the Control Center /sqllib/bin directory before you define the first replication source for a database.

• Update the table with the following SQL statement after you create the tuning parameters table:

  UPDATE TABLE ASN.IBMSNAP_CCPPARMS
  SET RETENTION_LIMIT=
  number_of_minutes,
  LAG_LIMIT=
  number_of_minutes,
  COMMIT_INTERVAL=
  number_of_seconds,
  PRUNE_INTERVAL=
  number_of_seconds,
  

If you need to change the values and refresh the tuning parameters while the Capture program is running, enter the REINIT command after changing the table values.

For information on the structure of the tuning parameters table, see Chapter 20. "Table Structures".

[ DB2 List of Books | Search the DB2 Books ]