Previous Topic: Specifying Control Statements for CADB2SY2Next Topic: Syntax


Specifying Synchronization Control Statements

You can use the CADB2SY1 Catalog Synchronization Utility component or you can create synchronization control statements to define which users and DB2 resources to synchronize. You can synchronize a specific logonid, a group of users (through their UIDs), a specific DB2 resource, or a group of resources. Each synchronization control statement contains one of the following verbs:

SYNC

Defines the DB2 subsystem and options of the synchronization run.

VIEW

Lets you control whether views are dropped and whether warning messages are issued for these views.

INCLUDE

Defines the user and DB2 resource information that is to be included in the synchronization run.

EXCLUDE

Defines the user and DB2 resource information to exclude from information specified by previous INCLUDE statements. You cannot EXCLUDE the PUBLIC ID from CADB2SY2 processing.

GO Signals the end of a group or batch of INCLUDE and EXCLUDE statements.

Begin each synchronization with one SYNC statement. Follow the SYNC statement with the VIEW statement. Follow the VIEW statement with one or more INCLUDE or EXCLUDE statements. You can also place a GO statement between sets of INCLUDE and EXCLUDE statements to include several batches in one synchronization.