Filter option descriptions
The following table describes the Filter options:
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.
|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.|