ASNCLP - SQL Replication - OFFLINE LOAD command

Use the OFFLINE LOAD command to control a manual full refresh for offline load procedures.

You must first run the OFFLINE LOAD BEFORE command to prepare for an offline load. This will generate the scripts to deactivate the relevant subscription sets. After you have completed your offline load, you then need to run the OFFLINE LOAD AFTER command to reactivate the subscription set and reset the IBMSNAP_PRUNCNTL and IBMSNAP_SIGNAL tables

Syntax


>>-OFFLINE LOAD--+-BEFORE-+--SETNAME--setname------------------->
                 '-AFTER--'                     

>--APPLYQUAL--applyqual----------------------------------------><

Parameters

BEFORE: Specifies that you want to modify your replication environment in preparation for running an offline load for the target tables.
AFTER: Specifies that you want to modify your replication environment after running an offline load for the target tables.
SETNAME setname: Specifies the subscription-set name.
APPLYQUAL applyqual: Specifies the Apply qualifier for the subscription set.

Example 1

To run the OFFLINE LOAD BEFORE command and to generate the scripts to deactivate the subscription set SET00:

OFFLINE LOAD BEFORE SETNAME SET00 APPLYQUAL AQ00

Example 2

To run the OFFLINE LOAD AFTER command and to reactivate the subscription set SET00 and to reset the IBMSNAP_PRUNCNTL SET and IBMSNAP_SIGNAL tables:

OFFLINE LOAD AFTER SETNAME SET00 APPLYQUAL AQ00