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
------------------ ------ -------- ------ ------ ---- -------
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*