Troubleshooting in the DBA Planning Calendar (Informix) 

Use

This section tells you what to do in the event of problems with the DBA Planning Calendar in the Computing Center Management System (CCMS) for the Informix database.

For information about troubleshooting with the alert monitor, see Monitoring the Database with the Alert Monitor (Informix).

Prerequisites

Any scheduled action can occasionally fail, so you must at least check the more critical actions such as archive and backup daily. For more information, see Checking the Results of Actions in the DBA Planning Calendar.

Procedure

...

       1.      Check that the background job was executed correctly.

Consult the job log to check this. If no job log exists, the background job was probably not started. You can get more details using the job overview with transaction SM37 (note that the names of all jobs scheduled in the Calendar start with DBA). The job log also tells you whether an external program was started.

       2.      Consult the action log (if available) if you are sure that the background job ran successfully.

       3.      Display the operating system log (if available).

       4.      Check for common errors such as:

¡        There is no tape in the tape drive

¡        The tape in the tape drive is write-protected.

¡        The tape in the tape drive has not been initialized.

¡        The tape drive contains the wrong tape.

¡        The tape is full.

¡        There has been an error with the tape drive.

Result

When you have corrected the error, reschedule the action to execute immediately. Refer to Scheduling Actions in the DBA Planning Calendar.

 

See also:

DBA Planning Calendar (Informix)