Hello Bob,

>> >> 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?
>
> >>
> >> No. You should manually check transactions' markers difference, or use
>
> >>tool like FBDataGuard which can check it in desired time and send warning.
>
> And what happens if the transaction markers don't align after a sweep?
>
>

It's an indication that you have tons of garbage in your database, and
you'll have slowness soon.
To have more details about garbage, you can gather gstat -r statistics
after failed sweep and analyse it - in text form or graphically with
IBAnalyst.

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



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