Processing INCLUDE and EXCLUDE Statements

Using the Catalog Synchronization Utility › Overview › Selective and Incremental Synchronization › CADB2SY0—Extracts SMF Records › Processing INCLUDE and EXCLUDE Statements

Processing INCLUDE and EXCLUDE Statements

CA ACF2 Option for DB2 processes the INCLUDE and EXCLUDE statements in batches. A batch begins with an INCLUDE or EXCLUDE statement and ends with a GO statement or end‑of‑file condition. A subsequent INCLUDE or EXCLUDE statement begins a new batch, your input file can contain multiple batches.

For each batch, CA ACF2 Option for DB2 processes the INCLUDE and EXCLUDE statements to determine which user and DB2 resource information to extract from the Logonid database and DB2 catalog, respectively. CA ACF2 Option for DB2 extracts logonids that match the criteria specified in the USER, UID, or IF keywords. If you use UID or IF keywords or mask the USER keyword, CA ACF2 Option for DB2 searches the entire Logonid database to extract the users that match. Then, CA ACF2 Option for DB2 extracts the DB2 resources from DB2 tables. The DB2 resources must match the criteria the resource keywords specified to be extracted:

DB2 Resources	Description
BPL	Buffer pools
COL	Collections
CON	Trusted Context
DBS	Databases
FNC	Functions
JAR	JAR files
PKG	Packages
PLN	Application plans
PRC	Stored procedures
ROL	Role
SCH	Schemas
SEQ	Sequences
STG	Storage groups
SYS	System privileges and utilities
TBL	Tables and views
TSP	Table spaces
TYP	Distinct types

For example, to synchronize all table resources, for all users, specify the following INCLUDE statement:

INCLUDE USER(*) TBL(*)

The example above will select all users in the Logonid database and all tables in the DB2 catalog. This results in a resource validation call for each table to be made for each user.

However, several of these users do not use DB2. By including them for synchronization, you are significantly increasing the amount of time and system resources required for the synchronization. We strongly recommend that you only include DB2 users for the synchronization to conserve time and resources. For example, if all DB2 users for the production DB2 system have a user defined logonid bit field, you can replace the previously mentioned INCLUDE statement using:

INCLUDE IF(DB2PROD) TBL(*)

To further narrow the synchronization, you can synchronize a subset of the table resources. For example, synchronize only the PAYROLL tables by entering:

INCLUDE IF(DB2PROD) TBL(PAYROLL.‑)