View ON-Bar backup and restore performance statistics
To view ON-Bar performance results, open the ON-Bar activity log file, bar_act.log.
The location of the bar_act.log file is set by the BAR_ACT_LOG configuration parameter.
When the
BAR_PERFORMANCE configuration parameter is set to 1 or 3, the activity
report shows a transfer rate report.
Figure 1. Sample transfer rate performance
in the ON-Bar activity
log
2013-06-03 15:38:02 8597 8595 Begin restore logical log 310 (Storage Manager
copy ID: 28206 0).
2013-06-03 15:38:03 8597 8595 Completed restore logical log 310.
2013-06-03 15:38:08 8597 8595 Completed logical restore.
2013-06-03 15:38:19 8597 8595 PERFORMANCE INFORMATION
TRANSFER RATES
------------------------------------------------------------------------------------------------------------------------
| OBJECT | XBSA API | SERVER API |
| NAME | xfer-kbytes xfer-time RATIO(kb/s) API-TIME | xfer-kbytes xfer-time RATIO(kb/s) API-TIME |
------------------------------------------------------------------------------------------------------------------------
| 309 | 62 0.479 129 1.078 | 62 0.019 3310 0.310 |
| 310 | 62 0.407 152 1.098 | 62 0.025 2522 0.025 |
| rootdbs | 5828 0.618 9436 1.864 | 5828 8.922 653 8.931 |
| datadbs01 | 62 0.488 127 1.768 | 62 0.004 17174 0.004 |
| datadbs02 | 62 0.306 203 1.568 | 62 0.008 8106 0.008 |
| datadbs03 | 62 0.304 204 1.574 | 62 0.007 8843 0.007 |
| datadbs04 | 62 0.306 202 1.563 | 62 0.007 8664 0.007 |
| datadbs05 | 62 0.315 197 1.585 | 62 0.007 8513 0.007 |
| datadbs06 | 62 0.310 200 1.583 | 62 0.002 25348 0.002 |
---------------- ----------------------------------- ... ---------------------------------------------------------------
| PID = 8597 | 14722 26.758 550 107.476 | 14756 10.678 1382 15.829 |
------------------------------------------------------------------------------------------------------------------------
2013-06-03 15:38:19 8597 8595 PERFORMANCE INFORMATION
PERFORMANCE CLOCKS
------------------------------------------------------------------------------------------------------------------------
| ITEM DESCIRPTION | TIME SPENT |
------------------------------------------------------------------------------------------------------------------------
| Time to Analyze ixbar file | 0.000 |
-------------------------------- ---------------------------------------------------------------------------------------When the BAR_PERFORMANCE configuration parameter is set
to 2 or 3, the activity report has microsecond timestamps.
Figure 2. Sample processing rates, in
microseconds, in the ON-Bar activity
log
2013-06-03 16:34:04 15272 15270 /usr/informix/bin/onbar_d complete,
returning 0 (0x00)
2013-06-03 16:45:11.608424 17085 17083 /usr/informix/bin/onbar_d -r -w
2013-06-03 16:46:07.926097 17085 17083 Successfully connected to Storage Manager.
2013-06-03 16:46:08.590675 17085 17083 Begin salvage for log 311.
2013-06-03 16:48:07.817487 17085 17083 Completed salvage of logical log 311.
2013-06-03 16:48:08.790782 17085 17083 Begin salvage for log 312.
2013-06-03 16:48:10.129534 17085 17083 Completed salvage of logical log 312.
2013-06-03 17:06:00.836390 17085 17083 Successfully connected to Storage Manager.
...
2013-06-03 17:07:26.357521 17085 17083 Completed cold level 0 restore datadbs07.
2013-06-03 17:07:28.268562 17085 17083 Begin cold level 0 restore datadbs08
(Storage Manager copy ID: 28122 0).
2013-06-03 17:07:29.378405 17085 17083 Completed cold level 0 restore datadbs08.