Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see PACLOG for DB2 13.1.

Filter option descriptions

The following table describes the Filter options:

Warning

To guard against the inadvertent removal of records that you might need for purposes other than recovery, consider using different filter options for each of your processed copies.


Option

Description

FILTERIX

Specifies whether to remove index-related records from the archive log data set. Use FILTERIX NONE to keep all such records. Use FILTERIX ALL (the default) to filter out those records. Use FILTERIX EXCEPT (database.indexspace) to exclude selected index spaces from filtering, thus allowing index recovery from log data. You can use an asterisk (*) as a wildcard to pattern match on either or both the database and index space names.

FILTERRECTYPE

Specifies whether to remove other record types that are not needed for Db2 forward recovery processes from the archive log. Use FILTERRECTYPE NONE to keep all such records. Use FILTERRECTYPE ALL (the default) to filter out those records.

FILTERTS (database.tableSpace,…)

Specifies the Db2 table space to remove all records that pertain to those table spaces from the archive log. The list must be enclosed in parentheses, and the items in the list must be separated by commas. You can use an asterisk (*) as a wildcard to pattern match on either or both the database and table space names.

Related topics

PACLOG-syntax-diagrams

PACLOG-option-descriptions

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*