RE: [Question]OnBar

The following website contain tools from Maury Tiller for troubleshooting and tuning onbar performance. By following his step-by-step procedure you can determine where the bottleneck lies. It also contains programs which he mentioned during a technical session at the Informix Solutions Portal 99. http://www.informix.com/onbartools/index.html Another unofficial website http://www.geocities.com/Heartland/Acres/4927/onbar.html provides an excellent overview of how onbar functions. -----Original Message----- From: Yang, Heung-Soon [mailto:hsyang@daou.co.kr] Sent: Friday, August 27, 1999 01:03 To: informix-list@iiug.org Subject: [Question]OnBar I have question about OnBar performance. One of my site uses OnBar with Informix Product : Informix 7.23UC1 System : IBM SPNODE OS : AIX 4.1.3 Backup Device : StorageTek TAPE Array Storage Manager : SCH Storage Manager The StorageTek TAPE Array can backup multiple host via network. And SCH Storage Manager softwares are both installed on BACKUP SERVER and BACKUP CLIENT machine. IDS 7.23UC1 is on BACKUP CLIENT machine. The performance used to be 17 minutes for rootdbs. But now it takes several hours to complete rootdbs backup without any change in data/system!! Any other BACKUP CLIENT(including Informix on other CLIENT)'s performance is not changing. Only this IDS on this IBM SPNODE is problem. And while onbar doing his job, I checked 'onstat -u'. The onbar session's nread increases 16 per minutes.... On the other machine in increases much faster. So, we asked SCH Storage Manager engineer. He told us pump up the Read Ahead parameters.(They are 50/30 now.) This would help ? Is there anybody who has other ideas? I attach onconfig/bar_action.log Thanks in advance. PS : Any other OLTP/DSS queries' performances are good just like before