Hello Bob,

> currently at 90GB. We have sweep disabled, and each night run gbak,
> gfix --sweep, as well as reindex all tables via a script.
>

Seems like you do correct things, but do you check that sweep is really
successful?

Look at the transactions' markers log in IBTM (IBSurgeon Transaction
Monitor), gathered from Profitmed database (120Gb, 400 clients, 2mln
transactions per 12 hours):
http://www.ib-aid.com/images/transactions_maintenance.gif

You can see gfix -sweep operations 2 times per day (~6am and ~21am),
which were successfully performed: there are 2 moments when all
transactions markers (Oldest, OAT, OST and NEXT) are equal (Next is +1).

This is one of critical things to watch for if you really want to sweep
your database.

Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com



[Non-text portions of this message have been removed]