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*