Subject Re: Transaktions, summary
Author Michael Vilhelmsen <Michael.Vilhelmsen@M
Well.

I.e. today the gab is after 4 hours somewhere around 2000.

My software runs on a Terminal Server.
The clients connects to this server, and works there.
My customer has just moved to a new location.

Therefor they have gotten a new router etc.
After this the clients "falls off" every once in a while.

When they fall off, whatever programs they had opend will be
terminated.

Could this termination couse the gab to grow ?


Michael

--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 09:07 AM 9/01/2003 +0000, you wrote:
> >Hi
> >
> >I have a customer who complains about the speed dropping during the
> >day.
> >
> >In the morning the transaktions (oldest transaction, oldest active,
> >etc) are alike.
> >
> >But during the day the gab extends.
> >The sweep function takes care of this, as far as I know. Correct ?
>
> Wrong.
> A gap that grows larger and larger throughout the day is not a
problem that
> a sweep will fix.
>
>
> >The default value for sweep is 20.000, correct ?
> >
> >Could I change that to i.e. 1.000 ?
> >
> >Would it affect the system in any way ?
>
> It would not help your problem. You need to find why the gap is
getting
> unreasonably large, and repair your software and/or provide some
training
> for users about abandoning their workstations with unfinished
> work..probably both are pertinent to your problem.
>
> >If the sweep function kicks in, and no user is connected, will the
> >gab then be somewhere between 0 and 1 ?
>
> No, the gap won't change until the "interesting" transaction is
> resolved. If your software doesn't take care of it then nothing
will,
> except a server shutdown. Meanwhile, you have an ever-accumulating
pile of
> old record versions which won't be touched by housekeeping.
>
> heLen