Monitoring Onbar Performance
Previously there was no easy way to monitor onbar archiving progress. It always a question, how long onbar process will take to complete an archive or how much time onbar will spend to transfer data between server, storage manager and vice versa.
Informix introduce two new configuration parameters to help onbar monitoring.
The BAR_PROGRESS_FREQ configuration parameter specifies, in minutes, the frequency of the progress messages in the bar activity log for backup and restore operations.
For example, if BAR_PROGRESS_FREQ is set to 5, onbar reports the percentage of the object backed up or restored every five minutes. Following is an excerpt of bar activity log that showing progress of rootdbs dbspace backup:
2007-05-09 16:12:58 13344 13342 /export/home/informix/bin/onbar_d -b -L 0 2007-05-09 16:12:59 13344 13342 Archive started on rootdbs (Requested Level 0). 2007-05-09 16:13:00 13344 13342 Begin level 0 backup rootdbs. 2007-05-09 16:13:00 13344 13342 Successfully connected to Storage Manager. 2007-05-09 16:18:00 13344 13342 1 percent of rootdbs has been backed up. 2007-05-09 16:23:01 13344 13342 6 percent of rootdbs has been backed up. 2007-05-09 16:28:02 13344 13342 11 percent of rootdbs has been backed up. 2007-05-09 16:33:03 13344 13342 16 percent of rootdbs has been backed up. 2007-05-09 16:38:04 13344 13342 21 percent of rootdbs has been backed up. 2007-05-09 16:43:05 13344 13342 26 percent of rootdbs has been backed up.
The default value of BAR_PROGRESS_FREQ is 0. If the value set to 0, onbar does not write any progress messages to the bar activity log.
The BAR_PROGRESS_FREQ value can’t less than five minute for monitoring onbar progress.
If ON–Bar cannot determine the size of the backup or restore object, it reports the number of transfer buffers sent to the database server instead of the percentage of the object backed up or restored.
The BAR_PERFORMANCE configuration parameter specifies the type of performance statistics to report, and write them to the bar activity log for backup and restore operations.
For example, if BAR_PERFORMANCE is set to 3, onbar reports the time spent transferring data between the Informix server and the storage manager, in the bar activity log.
The default value of BAR_PERFORMANCE is 0. If the value set to 0, onbar does not report any performance statistics to the bar activity log.
Valid values of BAR_PERFORMANCE are 0,1,2 or 3.
- 0 - turn performance monitoring off
- 1 - display the time spent transferring data between the server and storage manager
- 2 - display sub-second accuracy in the timestamps
- 3 - display both timestamps and transfer statistics
Both BAR_PROGRESS_FREQ and BAR_PERFORMANCE configuration parameters take effect while onbar process starts.