Using the Catalog Synchronization Utility › Implementation Considerations › Familiarizing Yourself With An Incremental Synchronization › Basic Process › Scheduling and Tailoring An Incremental Synchronization

Scheduling and Tailoring An Incremental Synchronization

Now that you have a basic understanding of how the incremental synchronization process works, let us take a look at the scheduling and tailoring process.

As we discussed earlier in the Basic Process section, the CADB2SY1 program generates standard CADB2SY2 synchronization control statements. You might notice as you go through these control statements that the program might have selected users and resources that you do not need to synchronize in your environment. For example, when a user is added, all resources are selected for synchronization for that user. However, in your environment, you might need only table resources synchronized. Therefore, you want to exclude all buffer pools, databases, packages, plans, storage groups, system privileges, and tablespaces from the incremental process. When an authorization change is made for a resource, all users are selected for synchronization. You might not need to synchronize all users in your Logonid database, just those who have DB2PROD logonid bit fields. Therefore, you want to modify the generated CADB2SY2 control statements. You also want to run the synchronization on a scheduled basis.

The following steps describe the scheduling and tailoring of an incremental synchronization:

1. Determine which users need to be synchronized and how to identify them. For example, users who have the DB2PROD logonid bit field.
2. Determine which resources or resource types need to be synchronized. For example, just table resources or just table resources that start with ABC.
3. Determine which options you want to use for CADB2SY2. The generated synchronization control statements for CADB2SY2 do not specify the OPTIONS keyword or the VIEW statement. The VIEW statement is discussed later in this chapter. If you want to use either of these for an incremental synchronization, you have to add them yourself. You can do this as part of the next step.
4. Determine the best way to modify the generated synchronization control statements for CADB2SY2 on a scheduled basis. We provide a sample job (SY1FLTR), clist (SY1CMD), and edit macro (SY1EDMAC) on the installation tape. You can tailor these to perform your modifications automatically. Schedule the SY1FLTR job to run between the CADB2SY1 and CADB2SY2 jobs (or job steps).

   For example, if you only need to synchronize table resources, you can insert EXCLUDE statements for all other resource types before the two GO statements.

5. Determine when you want to schedule the incremental synchronization and how you can schedule it. Decide whether you need it on a daily, weekly, or monthly basis. If you have a scheduling package, such as CA 7, this automates your scheduling process.