Catalog activity definition
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).
Option | Description |
---|---|
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. |
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. |
TRANSFER | Selects log records that resulted from a TRANSFER OWNERSHIP statement. |
Comments
Log in or register to comment.