Checking Database Backup Status and Result with Activity Log (ON-Bar)
Checking Database Backup Status and Result with Activity Log (ON-Bar)
Procedure
You can check the status and result of an Informix database backup with
ON-Bar by looking in the ON-Bar activity message log file. The BAR_ACT_LOG parameter in the ONCONFIG file specifies the name and location of the ON-Bar activity log. The default is /tmp/bar_act.log (UNIX) or %INFORMIXDIR%\bar_<servername>.log (NT).
Database backups from the
Here is an example of a whole-system-backup:
1998-10-19 11:16:07 3545 3543 /informix/AFI/bin/onbar_d -b -w
1998-10-19 11:16:13 3545 3543 Begin level 0 backup rootdbs.
1998-10-19 11:16:14 3545 3543 Successfully connected to Storage Manager.
1998-10-19 11:16:38 3545 3543 Completed level 0 backup rootdbs.
1998-10-19 11:16:39 3545 3543 Begin level 0 backup physdbs.
1998-10-19 11:16:46 3545 3543 Completed level 0 backup physdbs.
1998-10-19 11:16:46 3545 3543 Begin level 0 backup logdbs.
1998-10-19 11:16:53 3545 3543 Completed level 0 backup logdbs.
1998-10-19 11:16:54 3545 3543 Begin level 0 backup psapbtab.
1998-10-19 11:16:58 3545 3543 Completed level 0 backup psapbtab.
...
1998-10-19 11:17:00 3545 3543 Begin backup logical log 190.
1998-10-19 11:17:00 3545 3543 Successfully connected to Storage Manager.
1998-10-19 11:17:02 3545 3543 Completed backup logical log 190.
Here is an example of a storage-space backup:
1998-10-27 13:39:35 6689 6687 /informix/AFI/bin/onbar_d -b
1998-10-27 13:39:38 6689 6687 Begin level 0 backup rootdbs.
1998-10-27 13:43:08 6689 6687 Successfully connected to Storage Manager.
1998-10-27 13:43:29 6689 6687 Completed level 0 backup rootdbs.
1998-10-27 13:43:31 6740 6689 Process 6740 6689 successfully forked.
1998-10-27 13:43:31 6741 6689 Process 6741 6689 successfully forked.
1998-10-27 13:43:31 6742 6689 Process 6742 6689 successfully forked.
1998-10-27 13:43:32 6740 6689 Begin level 0 backup physdbs.
1998-10-27 13:43:33 6740 6689 Successfully connected to Storage Manager.
1998-10-27 13:43:34 6741 6689 Begin level 0 backup logdbs.
1998-10-27 13:43:34 6741 6689 Successfully connected to Storage Manager.
1998-10-27 13:43:36 6742 6689 Begin level 0 backup psapbtab.
...
1998-10-27 13:43:36 6742 6689 Successfully connected to Storage Manager.
1998-10-27 13:43:48 6740 6689 Completed level 0 backup physdbs.
1998-10-27 13:43:50 6741 6689 Completed level 0 backup logdbs.
1998-10-27 13:43:53 6741 6689 Process 6741 6689 completed.
1998-10-27 13:43:58 6742 6689 Completed level 0 backup psapbtab.
1998-10-27 13:44:01 6740 6689 Process 6740 6689 completed.
1998-10-27 13:44:01 6742 6689 Process 6742 6689 completed.
...
1998-10-27 13:44:02 6689 6687 Begin backup logical log 197.
1998-10-27 13:44:02 6689 6687 Successfully connected to Storage Manager.
1998-10-27 13:44:05 6689 6687 Completed backup logical log 197.
Result
If the database backup has finished successfully, you still need to
complete it.
See also:
Checking Result of Database Backup or Archive with Message LogInformix documentation at
http://www.informix.com