Using the Schedule table


The Schedule table contains schedule records that specify the time frame within which a specific object or a wildcard group of objects can, or cannot, start running.

Warning

Important

The Schedule table does not currently determine when a started object should stop running.

Specify E in the INCLUSIVE_EXCLUSIVE column to exclude objects from processing within a specified time frame.

Specify I in the INCLUSIVE_EXCLUSIVE column to include objects from processing within a specified time frame.

If there is no entry for an object in the Schedule table, the object can run at any time.

BMC AMI Utility Managerchecks the include records before the exclude records and honors the first record found for an object. Therefore, to exclude objects from processing within all but specific time frames, add an exclude record that covers all time and then add include records for time frames for which you want to allow processing. 

BMC AMI Utility Managerchecks records from most specific to least specific. For example, MEDRECS is more specific than MEDR%.

When there is a conflict between the time frames in the Schedule table and a job schedule, the time frame specified in the Schedule table prevails. For example, if a job schedule specifies that an object should run at a time excluded in the Schedule table, the object will never run.  

When you establish the Schedule table records, consider both the table spaces and their indexes. During RTS criteria processing, the BMC AMI Reorg job can skip the table space processing and process only its indexes. When this is done, the job converts a REORG TABLESPACE into a REORG INDEX.

To handle this processing, add records in the Schedule table for index entries as well. If you don't create Schedule table records for indexes, they may run at unexpected times. Add an exclude record to prevent processing of any index selected for reorganization by the Criteria table.

We recommend adding additional IX records to the Schedule table, similar to the table space wildcard records. These index exclude records make sure that reorganization of indexes don't run outside the appropriate time frames.

Information
Example

You want to schedule a wildcard reorganization to consider processing numerous objects, but you want a subset of objects not to run on weekends or at the ends of months. You can specify the same daily job processing in the job schedule, but exclude weekends or ends of months in the Schedule table.

Information
Example

To exclude processing of the TRANSACTION table from close of business (5:00 P.M.) until the end of settlement processing (9:00 P.M.), specify the following schedule record:

TYPE                    TS
NAME                    DB001.TRANSACT
PARTITION               0
REORG                   Y
COPY                    N
STATS                   N
INCLUSIVE_EXCLUSIVE     E
MONTH_WEEK              W
MONTH                   0
DAY                     0
START_TIME              17:00:00
END_TIME                21:00:00

This schedule record specifies that BMC AMI Reorg for Db2 can process the specified table space all days of the week from 5:00 P.M. to 9:00 P.M. and a weekly basis.

 

 

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

BMC AMI Utility Manager for Db2 13.1