Replicating load operations at the source table

About this task

By default, when the Q Capture program reads a log record that indicates the source table was successfully loaded, it issues a warning message. You can change this default behavior when you create a Q subscription for a source table by specifying that Q Capture replicate some types of load operations at the source table.

When this function is enabled, Q Capture stops and starts the Q subscription for the source table, prompting a load of the target table if one is specified for the Q subscription and based on the load options that were set for the Q subscription.

When Q Capture detects the following DB2 operations, its subsequent actions are based on whether you enabled replication of source table loads:

z/OS®

• LOAD SHRLEVEL NONE RESUME YES
• LOAD SHRLEVEL NONE REPLACE
• REORG TABLESPACE DISCARD

Linux, UNIX, Windows

• LOAD REPLACE
• LOAD INSERT

The following options for replication of source table loads are stored in the CAPTURE_LOAD column of the IBMQREP_SUBS table:

R (restart)

The Q subscription is restarted and the target table is loaded with the data from the source table. The type of load is determined by the LOAD_TYPE value in the IBMQREP_TARGETS control table.

W (warning)

Only a warning message is issued. The Q subscription is not restarted.

Restrictions

• The source database in DB2 for z/OS Version 9 must be at DB2 APAR PK78558 or newer and the Q Capture program must be at the equivalent of Version 9.7 or newer. Also, this function is not supported if the source or target table share a table space with other tables. CAPTURE_LOAD is a table-space-level option.
• The source database in DB2 for Linux, UNIX, and Windows and the Q Capture program must be at Version 9.7 or newer.
• Replication of source table loads is not supported for peer-to-peer replication with three or more servers.
• When you load a table that is involved in bidirectional replication, you must let the replication of that load operation complete and the Q subscription state change to active (A) before you start another load operation for the matching table at the other server. Otherwise, the two load operations conflict and might lead to unexpected behavior.
• Loading a source table while any Q subscriptions for the table are still in loading state (for example, performing two consecutive load operations) causes the Q subscriptions for the table to stop. Always wait until all Q subscriptions for the source table are in active (A) state before performing another load operation.

Procedure

CREATE QSUB USING REPLQMAP SAMPLE_ASN_TO_TARGET_ASN
(SUBNAME EMPLOYEE0001 EMPLOYEE OPTIONS HAS LOAD PHASE I
CAPTURE_LOAD R TARGET NAME TGTEMPLOYEE LOAD TYPE 2);