Subject Re: [ib-support] A few sweep questions
Author Jason Chapman (JAC2)
All AFAIK:
""Michael Vilhelmsen"" <Michael.Vilhelmsen@...> wrote in message
news:b70djq+7cd9@......
> Hi
>
> First:
> If running a GBak -Backup ..... of a DB will that resolve in a sweep
> being performed ?
No, it will perform garbage collection on every row though.

> Second:
> We have build 3 application that all connects to 1 DB.
> At all our customers sites, we can see, that in the morning, before
> anyone logs in to the DB the transactions are with 1 between them.
> I.e.
> OT 8419, OA 8420, OS 8420 and NT 8421.
Yep.

> Then during the day this gab grows and shrinks while the users are
> using the system.
> But as the last user logs out, the gab shrinks back to 1.
Congratulations.

> This is normal behavoiur, if every transaction in our programs are
> either commited or rollback, correct ?
I'm pretty sure that if you rollback a transaction that has changed data
then this gap between OT and OA will grow and not reduce until you do a
sweep.


> Third:
> If I disable the automatic sweep function, and the above senario is in
> place, would I then (teoretically) need to do a sweep ever ?
See my answer above.

JAC