Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

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:

exclusion_rules.png

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.

Warning

Important

  • Although the IXSPACEUPLIM and IXSPACELOLIM limits can cause the product not to generate utilities for indexes and index partitions, the product still reports and (optionally) saves exceptions.
  • Although the IXSPACEUPLIM and IXSPACELOLIM limits can prevent the product from generating utilities for indexes and index partitions, the product still reports and (optionally) saves exceptions.
  • Although the SPACELOLIM and SPACEUPLIM limits can prevent the product from generating utilities for table spaces and table space partitions, it still reports and (optionally) saves exceptions.

 

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

DASD MANAGER PLUS for DB2 12.1