Exclusion rules
This topic displays exclusion rules that identify whether to bypass objects from corrective action generation.
The following figure shows the syntax for Exclusion rules:

Objects that are not included in analysis are not excluded by these conditions. The product might generate such objects in the worklist due to escalation rules.
The following table lists the exclusion rules, showing availability by object type.
Values in boldface are the default values. Object types are as follows:
- INDEX (IX)
- INDEXSPACE (IS)
- TABLESPACE (TS)
- TABLESPACESET (TT)
Exclusion rules
Option name | Value | Description | Object type | |
|---|---|---|---|---|
TT, TS | IX, IS | |||
EXCLBADSTATUS | Y N (default) | Indicates whether to exclude objects that are not in Db2 read-write status | X 1 | X |
IXOMITCARD0 | Y (default) N | Indicates whether to exclude from action generation all indexes and index space partitions whose cardinality (FULLKEYCARD) equals 0. If you specify PARTLVL Y, the exception is evaluated at the partition level. Otherwise, the exception is evaluated at the object level. | NA | X |
IXSPACELOLIM | 0 (default) through 99999999 | Specifies the index space size (in tracks) below which the product excludes indexes and index partitions from action generation 2 | X | X |
IXSPACEUPLIM | 0 through 99999999 (default) | Specifies the index space size (in tracks) above which the product excludes indexes and index partitions from action generation2 | X 1 | X |
OMITCARD0 | Y N (default) | Indicates whether to exclude from action generation all table spaces and table space partitions whose cardinality equals 02 | X | NA |
SPACELOLIM | 0 (default) through 99999999 | Specifies the table space size (in tracks) below which the product excludes table spaces and table space partitions from action generation2 | X | NA |
SPACEUPLIM | 0 through 99999999 (default) | Specifies the table space size (in tracks) above which the product excludes table spaces and table space partitions from action generation2 | X | NA |
TRIGARCH | Y N (default) | Indicates whether to exclude archived objects from action generation. Specify Y to exclude archived or migrated objects from action generation, or N to generate actions for archived or migrated objects. | X | X |
1 This option is valid for TT and TS if you specify INDEX Y.
2 If you specify PARTLVL Y, the exception is evaluated at the partition level. Otherwise, the exception is evaluated at the object level.