Skip to Content
Information
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 sets

The collection options that you set in the DOMPLEX option set apply to all programs and plans that run on the Db2 subsystem.

You can use filter option sets to set filtering options that apply to specific combinations of programs, plans, users, correlation IDs, and Db2 subsystems.

You can associate a specific filter option set to a Db2 subsystem in the Db2 definition in the DOMPLEX option set. You can specify only one filter option set to be used with a Db2 subsystem at a time, but many Db2 subsystems can use the same filter option set.

Related topic

DOMPLEX-and-filter-option-sets

The following table lists the different collection options that you can specify with filters:

 You can also use the APPFILT command at any time to set or modify the filter for a Db2 subsystem.

For complete instructions for defining filter option sets (including host variables and exception processing), or for information about setting collection and summarization options, see System and SQL Performance for Db2 administration.


 

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

SQL Performance for DB2 13.1