Subject | A few sweep questions |
---|---|
Author | Michael Vilhelmsen |
Post date | 2003-04-09T06:12:10Z |
Hi
First:
If running a GBak -Backup ..... of a DB will that resolve in a sweep
being performed ?
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 ?
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 ?
Four:
What actually happens if I do a sweep on a DB with gab at only 1 ?
Regards
Michael
First:
If running a GBak -Backup ..... of a DB will that resolve in a sweep
being performed ?
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 ?
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 ?
Four:
What actually happens if I do a sweep on a DB with gab at only 1 ?
Regards
Michael