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.

Inclusion versus exclusion of objects from the workload

You can create naming patterns for objects that you want to include in and exclude from a workload.

Related topic

Working-with-object-sets

Use a plus sign (+) to mark patterns for objects that you want to include within the workload, and a minus sign (-) to mark patterns to exclude.

Information
Example

Assume that you had the following plan that included the specified packages:

Plan: ACCOUNT

Packages: PAYROLL.%, ACCTPAY.%, ACCTREC.%, and ESCROW.%

To include all of the packages in the workload with the exception of the PAYROLL.% packages, you would specify the following inclusion and exclusion rules:

+ PL ACCOUNT
- PG PAYROLL

Doing so includes the ACCTPAY, ACCTREC, and ESCROW packages in the workload, but excludes the PAYROLL package.


 

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

SQL Performance for DB2 13.1