Default language.

Limited supportBMC 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 BMC AMI Utility Manager for Db2 13.1.

Schedule table


The Schedule table establishes the time frame for forcing or preventing table space processing.

Column definitions in the Schedule table

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
UTILITY_ID              4 CHAR         16      0 Y    
REORG                   5 CHAR          1      0 N    N   
COPY                    6 CHAR          1      0 N    N
STATS                   7 CHAR          1      0 N    N
INCLUSIVE_EXCLUSIVE     8 CHAR          1      0 N    I
MONTH_WEEK              9 CHAR          1      0 N    W
MONTH                  10 INTEGER       4      0 Y    
DAY                    11 INTEGER       4      0 Y    
START_TIME             12 TIME          3      0 Y    
END_TIME               13 TIME          3      0 Y    
REMARKS                14 VARCHAR     128      0 Y    
LAST_UPD_USERID        15 CHAR          8      0 N    User   
LAST_UPD_TIMESTAMP     16 TIMESTMP     10      6 N    Timestamp
VERSION                17 CHAR          8      0 N    12.1.00

1 You can specify multiple schedule records for the same object if the records specify different time ranges. If the time ranges overlap, the product honors the first record that matches the criteria.

 

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