Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.


OptionDescription
FILTERIXSpecifies 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.
FILTERRECTYPESpecifies 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.
Was this page helpful? Yes No Submitting... Thank you

Comments