Criteria table
You can edit the BMC AMI Utility Manager Criteria table to set the criteria for selecting sets of table spaces or indexes for processing. The following sections describe the criteria and suggest where to add new criteria.
The Criteria table tells BMC AMI Utility Manager whether to perform actions specified in the Column Name column.
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
REMARKS 4 VARCHAR 128 0 Y
TS_REORG_NONE 5 CHAR 1 0 N N
TS_REORG_CHKINDEX 6 CHAR 1 0 N Y
TS_REORG_FORCECOPY 7 CHAR 1 0 N N
TS_REORG_MASSDEL 8 INTEGER 4 0 Y
TS_REORG_INSERTS 9 SMALLINT 2 0 Y
TS_REORG_DELETES 10 SMALLINT 2 0 Y
TS_REORG_UPDATES 11 SMALLINT 2 0 Y
TS_REORG_INSDELUPD 12 SMALLINT 2 0 Y
TS_REORG_INDREF 13 SMALLINT 2 0 Y
TS_REORG_UNCLUST 14 SMALLINT 2 0 Y
TS_REORG_DISORG 15 SMALLINT 2 0 Y
TS_REORG_EXTENTS 16 SMALLINT 2 0 Y
IX_REORG_NONE 17 CHAR 1 0 N N
IX_REORG_MASSDEL 18 INTEGER 4 0 Y
IX_REORG_INSERTS 19 SMALLINT 2 0 Y
IX_REORG_DELETES 20 SMALLINT 2 0 Y
IX_REORG_INSDEL 21 SMALLINT 2 0 Y
IX_REORG_PSEUDODEL 22 SMALLINT 2 0 Y
IX_REORG_LEAFLIMIT 23 SMALLINT 2 0 Y
IX_REORG_APPENDINS 24 SMALLINT 2 0 Y
IX_REORG_NLEVELS 25 SMALLINT 2 0 Y
IX_REORG_EXTENTS 26 SMALLINT 2 0 Y
TS_COPY_NONE 27 CHAR 1 0 N N
TS_COPY_DESTRUCT 28 CHAR 1 0 N Y
TS_COPY_INCRMENTAL 29 CHAR 1 0 N N
TS_COPY_CHKPENDING 30 CHAR 1 0 N Y
TS_COPY_DAYSSINCE 31 SMALLINT 2 0 Y
TS_COPY_UPDATED 32 SMALLINT 2 0 Y
TS_COPY_CHANGES 33 SMALLINT 2 0 Y
TS_INCR_DAYSSINCE 34 SMALLINT 2 0 Y
TS_INCR_UPDATED 35 SMALLINT 2 0 Y
TS_INCR_CHANGES 36 SMALLINT 2 0 Y
IX_COPY_NONE 37 CHAR 1 0 N N
IX_COPY_DESTRUCT 38 CHAR 1 0 N N
IX_COPY_CHKPENDING 39 CHAR 1 0 N N
IX_COPY_DAYSSINCE 40 SMALLINT 2 0 Y
IX_COPY_UPDATED 41 SMALLINT 2 0 Y
IX_COPY_CHANGES 42 SMALLINT 2 0 Y
IX_COPY_NACTIVE 43 INTEGER 4 0 Y
TS_STATS_NONE 44 CHAR 1 0 N N
TS_STATS_INSDELUPD 45 SMALLINT 2 0 Y
TS_STATS_INDLUPTOT 46 INTEGER 4 0 Y
TS_STATS_MASSDEL 47 INTEGER 4 0 Y
IX_STATS_NONE 48 CHAR 1 0 N N
IX_STATS_INSDEL 49 SMALLINT 2 0 Y
IX_STATS_INSDELTOT 50 INTEGER 4 0 Y
IX_STATS_MASSDEL 51 INTEGER 4 0 Y
TS_REORG_WHERE 52 VARCHAR 512 0 Y
IX_REORG_WHERE 53 VARCHAR 512 0 Y
TS_COPY_WHERE 54 VARCHAR 512 0 Y
TS_INCR_WHERE 55 VARCHAR 512 0 Y
IX_COPY_WHERE 56 VARCHAR 512 0 Y
TS_STATS_WHERE 57 VARCHAR 512 0 Y
IX_STATS_WHERE 58 VARCHAR 512 0 Y
LAST_UPD_USERID 59 CHAR 8 0 N User
LAST_UPD_TIMESTAMP 60 TIMESTMP 10 0 N Timestamp
TS_REORG_CHKAREO 61 CHAR 1 0 N N
TS_REORG_INSERTSMIN 62 INTEGER 4 0 Y
TS_REORG_DELETESMIN 63 INTEGER 4 0 Y
TS_REORG_UPDATESMIN 64 INTEGER 4 0 Y
TS_REORG_INSDELUPDMIN 65 INTEGER 4 0 Y
TS_REORG_ALLOUSED 66 SMALLINT 2 0 Y
TS_REORG_MAXSIZE 67 SMALLINT 2 0 Y
TS_REORG_HASHOVERFLOW 68 SMALLINT 2 0 Y
IX_REORG_CHKAREO 69 CHAR 1 0 N N
IX_REORG_INSERTSMIN 70 INTEGER 4 0 Y
IX_REORG_DELETESMIN 71 INTEGER 4 0 Y
IX_REORG_INSDELMIN 72 INTEGER 4 0 Y
IX_REORG_EMPTY 73 SMALLINT 2 0 Y
IX_REORG_MAXSIZE 74 SMALLINT 2 0 Y
TS_COPY_UPDATEDMIN 75 INTEGER 4 0 Y
TS_COPY_CHANGESMIN 76 INTEGER 4 0 Y
TS_INCR_UPDATEDMIN 77 INTEGER 4 0 Y
TS_INCR_CHANGESMIN 78 INTEGER 4 0 Y
IX_COPY_UPDATEDMIN 79 INTEGER 4 0 Y
TS_REORG_SSDMULTIPLIER 80 SMALLINT2 0 Y 2
VERSION 81 CHAR 8 0 N 13.1.00
------------------ ------ -------- ------ ------ ---- -------
TYPE 1 CHAR 2 0 N
NAME 2 VARCHAR 257 0 N
PARTITION 3 SMALLINT 2 0 N 0
REMARKS 4 VARCHAR 128 0 Y
TS_REORG_NONE 5 CHAR 1 0 N N
TS_REORG_CHKINDEX 6 CHAR 1 0 N Y
TS_REORG_FORCECOPY 7 CHAR 1 0 N N
TS_REORG_MASSDEL 8 INTEGER 4 0 Y
TS_REORG_INSERTS 9 SMALLINT 2 0 Y
TS_REORG_DELETES 10 SMALLINT 2 0 Y
TS_REORG_UPDATES 11 SMALLINT 2 0 Y
TS_REORG_INSDELUPD 12 SMALLINT 2 0 Y
TS_REORG_INDREF 13 SMALLINT 2 0 Y
TS_REORG_UNCLUST 14 SMALLINT 2 0 Y
TS_REORG_DISORG 15 SMALLINT 2 0 Y
TS_REORG_EXTENTS 16 SMALLINT 2 0 Y
IX_REORG_NONE 17 CHAR 1 0 N N
IX_REORG_MASSDEL 18 INTEGER 4 0 Y
IX_REORG_INSERTS 19 SMALLINT 2 0 Y
IX_REORG_DELETES 20 SMALLINT 2 0 Y
IX_REORG_INSDEL 21 SMALLINT 2 0 Y
IX_REORG_PSEUDODEL 22 SMALLINT 2 0 Y
IX_REORG_LEAFLIMIT 23 SMALLINT 2 0 Y
IX_REORG_APPENDINS 24 SMALLINT 2 0 Y
IX_REORG_NLEVELS 25 SMALLINT 2 0 Y
IX_REORG_EXTENTS 26 SMALLINT 2 0 Y
TS_COPY_NONE 27 CHAR 1 0 N N
TS_COPY_DESTRUCT 28 CHAR 1 0 N Y
TS_COPY_INCRMENTAL 29 CHAR 1 0 N N
TS_COPY_CHKPENDING 30 CHAR 1 0 N Y
TS_COPY_DAYSSINCE 31 SMALLINT 2 0 Y
TS_COPY_UPDATED 32 SMALLINT 2 0 Y
TS_COPY_CHANGES 33 SMALLINT 2 0 Y
TS_INCR_DAYSSINCE 34 SMALLINT 2 0 Y
TS_INCR_UPDATED 35 SMALLINT 2 0 Y
TS_INCR_CHANGES 36 SMALLINT 2 0 Y
IX_COPY_NONE 37 CHAR 1 0 N N
IX_COPY_DESTRUCT 38 CHAR 1 0 N N
IX_COPY_CHKPENDING 39 CHAR 1 0 N N
IX_COPY_DAYSSINCE 40 SMALLINT 2 0 Y
IX_COPY_UPDATED 41 SMALLINT 2 0 Y
IX_COPY_CHANGES 42 SMALLINT 2 0 Y
IX_COPY_NACTIVE 43 INTEGER 4 0 Y
TS_STATS_NONE 44 CHAR 1 0 N N
TS_STATS_INSDELUPD 45 SMALLINT 2 0 Y
TS_STATS_INDLUPTOT 46 INTEGER 4 0 Y
TS_STATS_MASSDEL 47 INTEGER 4 0 Y
IX_STATS_NONE 48 CHAR 1 0 N N
IX_STATS_INSDEL 49 SMALLINT 2 0 Y
IX_STATS_INSDELTOT 50 INTEGER 4 0 Y
IX_STATS_MASSDEL 51 INTEGER 4 0 Y
TS_REORG_WHERE 52 VARCHAR 512 0 Y
IX_REORG_WHERE 53 VARCHAR 512 0 Y
TS_COPY_WHERE 54 VARCHAR 512 0 Y
TS_INCR_WHERE 55 VARCHAR 512 0 Y
IX_COPY_WHERE 56 VARCHAR 512 0 Y
TS_STATS_WHERE 57 VARCHAR 512 0 Y
IX_STATS_WHERE 58 VARCHAR 512 0 Y
LAST_UPD_USERID 59 CHAR 8 0 N User
LAST_UPD_TIMESTAMP 60 TIMESTMP 10 0 N Timestamp
TS_REORG_CHKAREO 61 CHAR 1 0 N N
TS_REORG_INSERTSMIN 62 INTEGER 4 0 Y
TS_REORG_DELETESMIN 63 INTEGER 4 0 Y
TS_REORG_UPDATESMIN 64 INTEGER 4 0 Y
TS_REORG_INSDELUPDMIN 65 INTEGER 4 0 Y
TS_REORG_ALLOUSED 66 SMALLINT 2 0 Y
TS_REORG_MAXSIZE 67 SMALLINT 2 0 Y
TS_REORG_HASHOVERFLOW 68 SMALLINT 2 0 Y
IX_REORG_CHKAREO 69 CHAR 1 0 N N
IX_REORG_INSERTSMIN 70 INTEGER 4 0 Y
IX_REORG_DELETESMIN 71 INTEGER 4 0 Y
IX_REORG_INSDELMIN 72 INTEGER 4 0 Y
IX_REORG_EMPTY 73 SMALLINT 2 0 Y
IX_REORG_MAXSIZE 74 SMALLINT 2 0 Y
TS_COPY_UPDATEDMIN 75 INTEGER 4 0 Y
TS_COPY_CHANGESMIN 76 INTEGER 4 0 Y
TS_INCR_UPDATEDMIN 77 INTEGER 4 0 Y
TS_INCR_CHANGESMIN 78 INTEGER 4 0 Y
IX_COPY_UPDATEDMIN 79 INTEGER 4 0 Y
TS_REORG_SSDMULTIPLIER 80 SMALLINT2 0 Y 2
VERSION 81 CHAR 8 0 N 13.1.00
-
13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*