Exceptions table

BMC AMI Utility Manager uses the Exceptions table to handle deviations from periodic processing (for example, preventing reorganization during maintenance). Edit the Exceptions table to define the exception conditions that force or prevent processing of a table space or index.

The following figure displays column definitions for the Exceptions table:

Related topics

WHERE-clause-processing

Using-the-Exceptions-table

BMC-AMI-Utility-Manager-command-and-syntax-reference

Table-column-reference

Column Name        Col No Col Type Length Scale Null Default
------------------ ------ -------- ------ ------ ---- -------
TYPE                    1 CHAR          2      0 N
NAME                    2 VARCHAR     257      0 N
PARTITION               3 SMALLINT      2      0 N     0
REORG                   4 CHAR          1      0 N     I
COPY                    5 CHAR          1      0 N     I
STATS                   6 CHAR          1      0 N     I
REMARKS                 7 VARCHAR     128      0 Y
REORG_WHERE             8 VARCHAR     512      0 Y
COPY_WHERE              9 VARCHAR     512      0 Y
STATS_WHERE            10 VARCHAR     512      0 Y
LAST_UPD_USERID        11 CHAR          8      0 N     User
LAST_UPD_TIMESTAMP     12 TIMESTAMP    10      0 N     Timestamp
RULE_TYPE              13 CHAR          1      0 N     X
VERSION                14 CHAR          8      0 N     12.1.00
ACTIVE   15 CHAR1   0 N   Y
EXPIRATION_COUNTER   16 SMALLINT    2   0 N   -1
EXPIRATION_DATE   17 TIMESTAMP    10   0 Y   NULL

Member EXCAPP in the CNTL data set contains sample SQL that you can add to an Exceptions table row to skip reorganization of a table space. You might want to do this to prevent reorganization of the table space while another event is running. You can invoke member EXCAPP instead of overriding an existing job schedule.

The following table describes each column that is listed under Column Name in the Exceptions table.

Warning

When the product processes Exceptions records, specific conditions override general or wildcard conditions.

BMC AMI Utility Manager sorts Exceptions records according to their specificity and honors the first Exceptions record that it encounters. If you defined multiple records for the same object, you cannot know which Exceptions record the product honored and which ones the product ignored.

Column	Description
TYPE	Specifies the type of RTS record Valid values are: AP—Application TS—Table space IX—Index
NAME	Specifies the name of the RTS record You can use wildcards in the name. Maximum acceptable values are: Application—128 characters Table space—17 characters, in the format databaseName.tableSpaceName Index—257 characters, in the format creator.indexName
PARTITION	Specifies the partition number 0 (zero) signifies all partitions. Default value: 0
REORG	Forces, excludes, or ignores a reorganization by BMC AMI Reorg Valid values are: F—Forces a reorganization X—Excludes a reorganization I—Ignores (not a reorganization Exceptions record) Default value: I
COPY	Forces, excludes, or ignores copying by BMC AMI Copy Valid values are: F—Forces copying X—Excludes copying I—Ignores (not a copy Exceptions record) Default value: I
STATS	Forces, excludes, or ignores statistics collection by BMC AMI Stats Valid values are: F—Forces statistics collection X—Excludes statistics collection I—Ignores (not a statistics Exceptions record) Default value: I
REMARKS	Specifies comments for an Exceptions table entry
REORG_WHERE	Specifies WHERE clause for BMC AMI Reorg table space processing
COPY_WHERE	Specifies WHERE clause for BMC AMI Copy table space processing
STATS_WHERE	Specifies WHERE clause for BMC AMI Stats table space processing
LAST_UPD_USERID	Specifies the user ID of the last user to update the row Default value: userID
LAST_UPD_TIMESTAMP	Specifies the time stamp of the most recent update to the row Default value: Not applicable
RULE_TYPE	Forces, excludes, or ignores object processing Valid values are: F—Forces object processing by the checked utilities X—Excludes object processing by the checked utilities I—Ignores the object Default value: X
VERSION	Specifies the BMC AMI Utility Manager version number Default value: 12.1.00
ACTIVE	Specifies whether the RTS record is active or inactive BMC AMI Utility Manager ignores Inactive records. Valid values are: Y—RTS record is active. N—RTS record is inactive. Default value: Y For more information, see Activating and deactivating exceptions.
EXPIRATION_COUNTER	Specifies the number of times BMC AMI Utility Manager processes the RTS record before it expires Default value: -1 For more information, see Setting exceptions to expire.
EXPIRATION_DATE	Specifies the date and time on which the RTS record expires Default value: NULL For more information, see Setting exceptions to expire.

Exceptions table

On this page