RE: Onbar performance question

Onbar uses a storage manager and sends data to it via your network. It will never be as fast a directly connected tape drive. However, it has other benefits. You should be able to run almost as fast as your hardware allows. We backup a 160GB SAP database in 3.4 hours with "onbar -b -w" using ADSM with IDS 7.31.UC6X8. Tables occupy 70% of the allocated space in our database. The backup runs slightly faster, but is constrained by our (100 megabit) network connections, when we perform a dbspace backup to 2 tape drives. The following web-sites contain tools, which can help you identify where your bottleneck lies: 1) http://www.geocities.com/Heartland/Acres/4927/perftools.html 2) http://www.informix.com/onbartools/index.html Avoid setting BAR_DEBUG to any non-zero value. It can significant increases in run-time and can create a large bar_dbug file. Rick -----Original Message----- From: Jon Freeland [mailto:jon@no-spam-please.millerind.com] Sent: Saturday, January 06, 2001 6:56 PM To: informix-list@iiug.org Subject: Onbar performance question We have just started using onbar with HP OmniBack II version 3.50. The performance, compared to ontape is so horrible it is useless. This is with Informix 7.31-UC5-1 on AIX 4.3.2. I have tried several things and I finally tested this on our production machine which runs 7.30-UC7-2 and got about 10 times better performance. Still not too great. Then, on my test box, I reverted back to the 7.30 version and got comparable results (after setting BAR_DEBUG to 0). I'm getting roughly 1150KB/s which would run a long time on a large database. What I'm curious to find out is whether this is typical or if there is really something broken here. I was able to back up the test database with ontape to a local 8mm tape drive in about 5 minutes. It only has about 1.5 GB worth of data in it. Using onbar and OmniBack, it took 19 minutes (using a list of dbspace names, not onbar -w). Is this typical? I would figure the two would be closer in time than this. Any help/suggestions are appreciated. -- Jon Freeland<*> Miller Industries, Inc. Remove the "no-spam" above to reply.