Using the Catalog Synchronization Utility › Specifying Control Statements for CADB2SY2 › Specifying GRANT TO PUBLIC Control Statements › Syntax › Control Statement Descriptions

Control Statement Descriptions

Each control statement and keyword is described below:

BPL(bufferpool|bufferpoolmask)

Identifies the buffer pools that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

COL(collection|collectionmask)

Specifies the collections that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

DBS(database|databasemask)

Specifies the databases that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

FNC(function|functionmask)

Specifies the functions that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

JAR(jarfile|jarfilemask)

Specifies the JAR files that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

PKG(package|packagemask)

Specifies the packages that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

PLN(plan|planmask)

Specifies the plans that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

PRC(procedure|proceduremask)

Specifies the stored procedures that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

SCH(schema|schemamask)

Specifies the schemas that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

SEQ(sequences|sequencemask)

Specifies the sequences that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

STG(storagegroup|storagegroupmask)

Specifies the storage groups that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

SYS(systemprivilege|systemprivilegemask)

Specifies the system privileges and utilities that the CA ACF2 Option for DB2 synchronization utility grants public access to. For a list of DB2 system privileges and utilities that you can specify, see What Are DB2 Privileges and Authorities section in the “Understanding DB2” chapter. You can use the DB2 (that is, IBM) system privilege or utility or the CA ACF2 Option for DB2 shortened name to specify this keyword.

TBL(table|tablemask)

Specifies the tables that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

TSP(tablespace|tablespacemask)

Specifies the table spaces that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

TYP(distincttype|distinctypemask)

Specifies the distinct types that the CA ACF2 Option for DB2 synchronization utility grants public access to based on the privileges specified in the PRIV keyword.

PRIV(privilege|,privilege...|)

Specifies the privileges for the resource that you are granting public access to. Separate multiple privileges with a comma, but no extra space. You can specify up to five privileges. You can specify the native DB2 privilege name or the CA ACF2 Option for DB2 privilege name.

Note: Only individual privileges are supported. You cannot specify the ALL privilege for tables. Also, do not specify the CREATE privilege for tables since this is only valid in CA ACF2.