On Sep 11, 1:28 am, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote:
> mohitanch...@gmail.com wrote:
> > I am reading about various things that could make backing up logical
> > logs faster using onbar. One of the things that IBM recommends is
> > running update statistics on sysutils database. So my question is:
>
> > 1. What columns should the update stats run against.
> > 2. Are there any other ways to improve the logical log backup. I guess
> > answer is no as I can't even use BAR_MAX_BACKUP for logical log backup
>
> Humm,
>
> I think you may be looking at the problem from the wrong end.
>
> 1. How big are your logical logs?
> 2. How often do they "fill up" (i.e. review the "logical log complete" messages).
> 3. How long does it take to back up a log?
> 4. What storage manager are you using? (local / remote?)
> 5. How do you backup your logical logs (ALARMPROGRAM or manually?)
>
> If you have small logical logs which complete in 10 seconds and it takes your storage manager 20 seconds to locate a tape and mount
> it, then you will have problems :-/
>
> However, if you have "larger" logical logs (say you want to have recovery capability to within 15 minutes) which fill in 15 minutes,
> then even if it takes one minute for the storage manager to find somewhere to place it, you will not have problems.
>
> HTH

I was actually referring to the "Tips" section of following URL:

http://publib.boulder.ibm.com/infoce...oc/perf370.htm