Previous Topic: CADB2SY0—Extracts SMF RecordsNext Topic: CADB2SY2—Creates SQL Statements

Using the Catalog Synchronization Utility › Overview › Selective and Incremental Synchronization › CADB2SY0—Extracts SMF Records › CADB2SY1—Creates Synchronization Control Statements

CADB2SY1—Creates Synchronization Control Statements

If you are using an incremental synchronization to synchronize the catalog, use the CADB2SY1 component to create synchronization control statements for the CADB2SY2 component. This job uses SMF records (read from the SMF file directly or from the output of CADB2SY0) to identify changes to users and CA ACF2 Option for DB2 rules to include in the synchronization. It also queries the DB2 catalog looking for newly created resources. Then it creates synchronization control statements, appropriate for your release of DB2, that identifies the users and resources to synchronize. For example, CADB2SY1 generates statements for packages and collections.

CADB2SY1 processes the SMF records and generates two different groups or batches of synchronization control statements for the synchronization. This lets the CADB2SY2 component handle logonid changes differently from rule changes and newly created resources. The first batch processes new users by correlating the users with all DB2 resources. The second batch processes rule changes and new resources in the DB2 catalog by correlating all users with a specific DB2 resource name. For example, a new user (USER8) added to the system causes CA ACF2 Option for DB2 to generate the following synchronization control statements:

INCLUDE BPL(*) DBS(*) COL(*) PKG(*) PLN(*)
INCLUDE STG(*) SYS(*) TBL(*) TSP(*)
INCLUDE FNC(*) PRC(*) SCH(*) TYP(*)
INCLUDE JAR(*)1 
INCLUDE SEQ(*)2
INCLUDE USER(USER8)

1This statement is only generated for DB2 subsystems at DB2 Version 7.1 or above.

2This statement is only generated for DB2 subsystems at DB2 Version 8.1 or above.

A changed CA ACF2 Option for DB2 rule for the DB2P database and a new table, PAYROLL.BONUS, in the CB2 catalog generates the following INCLUDE statements:

INCLUDE USER(*)
INCLUDE DBS(DB2P)
INCLUDE TBL(PAYROLL.BONUS)

The utility writes the generated synchronization control statements to the SYNCHOUT data set. For an example of these control statements, see CADB2SY1 Incremental Function Report, later in this chapter. You can edit this data set to add options or to limit the users and resources included in the incremental synchronization. For example, if you do not want to synchronize buffer pools and storage groups at this time, you can edit the SYNCHOUT data set in either of the following ways:

If your incremental synchronization runs automatically, you can write an edit macro that automatically modifies the SYNCHOUT data set. To do this, use the sample job, CLIST, and edit macros that we provide on the installation tape. They are located in member SY1FLTR in the sample JCL library and in members SY1CMD and SY1EDMAC in the product CLIST library. CADB2SY1 does not generate any of the following CADB2SY2 control operands: