Alexey -

>> Alexey Kovyazin [mailto:ak@...]
>> 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.



Is there any way to tell if the sweep was successful other than all of
the markers matching? Is there any way to tell why a sweep would have
failed?



I'm running the sweep from a batch file, but never thought to check
the errorlevel after completion...



Thanks,



Bob M..



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