Displaying Scheduled Actions (DB2 UDB for UNIX and Windows) 

Use

From the DBA Planning Calendar, you can view all action-related information. This includes:

·        Action parameters

·        Job logs if the action has already run

These logs provide detailed information on the results of an action.

·        Recurrence patterns

The status of an action is indicated by the color of the calendar cell where an action is inserted.

Procedure

Select the action by double-clicking a calendar cell or by positioning the cursor on a cell and choosing  Action Details.

The Display Details of Action dialog box appears. In the Action Description group box, scheduling information and the return status of the finished action is displayed.

Action Parameters

The system displays tablespaces containing tables and indexes that need to be reorganized.

Recurrence

This tabstrip only appears if the action is part of a recurring action.

The timestamp is used to assign logs to scheduled actions. An action log is assigned to the action which has the same type and the closest corresponding timestamp. In some cases, for example, if no background work process is available, the action is delayed and even postponed until after the next scheduling time. Unfortunately, this means that the action log is then assigned to the next scheduling time and the original scheduling time log is incorrect. This is the case if the logs for the previous schedules are displayed for the next schedule of the same type.

Job Log

The background processing job log generated by the action is displayed under Job Log. All messages that have been written by the background job are also displayed.

To display long texts, if any are available, double-click a message.

Program Log

Some actions write log files onto the database server. If such a program log exists, it is displayed on this tabstrip.