Michael Vilhelmsen wrote:

> First:
> If running a GBak -Backup ..... of a DB will that resolve in a sweep
> being performed ?

No. But, it will garbage collect (unless you instruct gbak not to).

> 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.
>
> 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.
>
> This is normal behavoiur, if every transaction in our programs are
> either commited or rollback, correct ?

It is normal. However, if the gap gets very wide you should see whether
the transaction handling in the apps could be improved.

> 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 ?

If - if - if ... - probably not.

> Four:
> What actually happens if I do a sweep on a DB with gab at only 1 ?

'Old versions' (of records) will be garbage collected (removed). If you
use a fairly new version of IB/Fb there will probabably be very little to
remove (as the built-in GarbageCollect thread (or frequent gbak-ing) may
take care of it).
A little sweeping doesn't hurt (except performance during the sweep).


--
Aage J.