Using the Archive and Backup Monitor in CCMS (Informix) 

Use

You can use the archive and backup monitor in the Computing Center Management System (CCMS) to check in detail the results of an archive, a database backup, or a logical-log backup started in the DBA Planning Calendar. For more information on scheduling these actions, see Scheduling Actions in the DBA Planning Calendar.

Prerequisites

You are ready to use CCMS. Refer to Getting Started in CCMS with Informix DBA.

You have performed an archive, a database backup, or a logical-log backup in the DBA Planning Calendar.

You use ON-Bar or ON-Archive as your data recovery tool for the Informix database.

Procedure

  1. Choose Tools ® CCMS ® DB Administration ® Backup Logs.

    2. The system displays the archive and backup monitor, including a summary of the logical-log status.

  2. If you are using ON-Bar, choose between Dbspace backups and Whole system backups, and between All backups and CCMS backups only.

    3. The system changes the display accordingly.

  3. Choose the appropriate function to display the information you want to see, as shown in the following table:

The functions available – reflected in the display – vary according to whether you are using ON-Bar or ON-Archive. With ON-Bar, the display also varies according to whether you have chosen whole-system backups or database backups, and CCMS backups or all database backups (see previous step).

Function

Description

Last database backup (all dbspaces) (ON-Bar)

Last whole system backup (ON-Bar)

Last successful database archive
(ON-Archive)

Displays the date and time of the last database backup or archive. Choose to see further details of the database backup or archive (such as the dbspaces and so on).

Overview of database backups
(ON-Bar)

Overview of whole system backups
(ON-Bar)

Overview of all database archives
(ON-Archive)

Choose to see an overview of all database backups and archives performed.

Status of the logical log

Displays percentage used of the logical log. Choose to see further details about the current status of the logical log (that is, total size in Kb, amount used in Kb, amount available in Kb, percent used).

Most recent logs backed up

Displays the number of the latest logical-log file Not yet backed up. Choose to see a recent history of logical-log backups.

Overview of all logical log backups

Choose to see a comprehensive overview of all logical-log backups.

CCMS backups only (ON-Bar)

All backups (ON-Bar)

Choose to see all backups or only those performed in CCMS.

Volume Report (ON-Archive)

Choose to see full details of each archived dbspace or backed-up logical log. The information displayed includes the volume set used, label and volume number of the tape and its creation date.

Recovery Report (ON-Archive)

Displays the recovery reports created by SAPDBA, if any exist. You can also generate a recovery report immediately. Note that a recovery report created in CCMS is not automatically stored in the same file system as it is when created with SAPDBA.

For further details on recovery reports in SAPDBA, see Recovery Report with SAPDBA.

Result

By checking the results of archives and backups you can make sure that they have completed successfully. Remember that unsuccessful archives and backups might mean that production data is lost in the event of failure, because you are not able to perform a complete database restore.

 

See also:

Archive and Backup Monitor in CCMS (Informix)