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.

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.

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 Manager checks 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 Manager checks 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.  

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.

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.


Related topics

Schedule-table

Using

Table-column-reference

 

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