Subject Re: [ib-support] force disconnect users
Author Jason Chapman (JAC2)
If you stop and start the IB / FB service you will have the benefit of:
1) No long running TX's
2) Better long term performance for large and heavily hit DB's
3) No ghost connections.

In the space prior to people logging back in you can:
1) do an OS copy (minimises losses @2am)
2) do a sweep (sorts out rolled back TX's)
3) Do a backup with grabage collection
4) Have very happy users.



""Roger Pullen"" <pullen.roger@...> wrote in message
> Hi all
> What is the best way of automatically ensuring all users
> are logged out at, say, midnight, so that
> the tape backup will work
> W2K server & IB6
> (There should not be any users in at this
> time but there is always one who forgets
> to switch their PC off)
> RogerP