On Sep 12, 8:30 am, TBP <TheBigPota...@Nothere.Co.Uk> wrote:
> On Sep 11, 4:46 pm, mohitanch...@gmail.com wrote:
>
>
>
> > 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...dex.jsp?topic=...
>
> That just refers to "speeding up the queries / updates" that are run
> by the onbar(_d) process against the sysutils.
>
> Generally this bit of the run time is minimal (you can set BAR_DEBUG
> and BAR_DEBUG_PATH to get more activity details from which you can
> probably determine activity duration (e.g. storage manager response,
> ixbar processing, sysutils updates etc. etc.) - keep BAR_DEBUG below 5
> if you want to keep performance from going REALLY bad.

Nevertheless do you think we should run update stats on sysutils. I
think it probably be better then not doing it.