Catalog activity definition

The following figure shows the catalog activity definition syntax used in the WHERE clause of the LOGSCAN statement. Use this syntax to select log records based on the type of Db2 catalog activity they reflect.

You can also think of this syntax as selecting a type of data definition language (DDL) statement. For example, you can select all log records that resulted from DROP statements, or all log records that record privilege distribution (GRANT statements).

Use the catalog activity definition when you are generating a DDL output file or Catalog Activity report; it is not valid if your log scan specifies any other type of output. By defining a filter that includes catalog activity and generating a Catalog Activity report, you can select information about changes to the Db2 catalog, including changes to Db2 security.

Catalog activity definition syntax diagram

To select log records based on a type of Db2 catalog activity, Log Master must perform completion processing on Db2 catalog log records. Because of the large number of log records related to the catalog, this processing can cause your job to run longer and require more resources than a job that does not read the Db2 catalog. If you frequently operate on objects that are stored in the catalog, you can improve performance by creating more frequent image copies of the catalog or by defining tables in the Db2 catalog with Data Capture Changes (DCC). DB2CAT shows which tables should be defined with DCC or Data Capture None (DCN).

OptionDescription
ALTER

Selects log records based on whether they resulted from an ALTER statement.

COMMENT ON

Selects log records based on whether they resulted from a COMMENT ON statement.

CREATE

Selects log records based on whether they resulted from a CREATE statement.

DROP

Selects log records based on whether they resulted from a DROP statement.

GRANT

Selects log records based on whether they resulted from a GRANT statement.

RENAME

Selects log records based on whether they resulted from a RENAME statement.

LABEL ON

Selects log records based on whether they resulted from a LABEL ON statement.

REVOKE

Selects log records based on whether they resulted from a REVOKE statement.

BIND

Selects log records based on whether they resulted from a BIND command.

REBIND

Selects log records based on whether they resulted from a REBIND command.

FREE

Selects log records based on whether they resulted from a FREE command or DROP PACKAGE DDL.

IN

Log Master can select log records based on whether they resulted from a single type of DDL statement or a set of DDL statement types. The IN keyword indicates a set of multiple DDL statement types. Enclose the set of DDL statement types within parentheses and separate multiple types with commas.

Example

   IN (DROP, REVOKE)
NOT

Specifies that log records are selected when the type of DDL statement reflected in them does not match any member of a set of multiple DDL statement types.

Example

   NOT IN (CREATE, GRANT)
TRANSFER

Selects log records that resulted from a TRANSFER OWNERSHIP statement.

Was this page helpful? Yes No Submitting... Thank you

Comments