Combine IX/TS exceptions when evaluating an IX triggering a TS

Edit online

When this field is set to Y, Db2 Automation Expert re-evaluates the associated table space exception criteria when an index meets its index space criteria, but triggers the corresponding table space instead of itself.

Index exception criteria that trigger the associated table space are:

SYSINDEXES: CLUSTERED, CLUSTERING, CLUSTERRATIO, CLUSTERRATIOF 
SYSINDEXSTATS: CLUSTERRATIO, CLUSTERRATIOF 
SYSINDEXPART: NEAROFFPOSF, FAROFFPOSF, PERCOFFPOS

If this field is set to Y, when a table space is triggered because its index meets one of those exception criteria, Db2 Automation Expert evaluates the table space against the table space exception criteria that are included in the profile. The table space must meet the table space criteria in order to be triggered.

For example, a job profile contains a REORG utility profile and an exceptions profile that includes the following:

A MVS CATALOG        *ALLOCATED_TRACKS    <   1001   
A Db2 DISPLAY STATUS  STATUS_RW           EQ         
A SYSINDEXES          CLUSTERRATIO        <   95

When evaluating table space criteria, table space TS1 meets the specified Db2 DISPLAY STATUS criteria but does not meet the ALLOCATED_TRACKS criteria. Therefore, TS1 is not triggered. When evaluating index space criteria, however, associated index IX1 meets the specified CLUSTERRATIO criteria, as well as the ALLOCATED_TRACKS criteria, and the specified Db2 DISPLAY STATUS criteria. Since Combine IX/TS Exceptions when evaluating IX triggering a TS is set to Y, Db2 Automation Expert re-evaluates the associated table space TS1 to ensure that it meets all of the table space exception criteria. However, TS1 does not meet the table space criteria and, therefore, would not be triggered.