thanks dmitry !

>
> AJ> the probleme is that the sweep can take up to 5 hours to finish
> and the
> AJ> backup up to 12 hours to finish :(
>
> What is the size of database?
>

120 GB

>
> AJ> i know that in the backup i don't put the -g params (inhibit garbage
> AJ> collection) but someone say me that
> AJ> the -g do something else that the gfix.exe -sweep doesn't do ...
>
> Sweep, if it could, already collected garbage. So, it is useless
> to run gbak without -g after sweep. If sweep couldn't collect garbage
> due to some active "being interested" transaction, neither gbak can
> collect garbage, so, -g is again useless.
>
> You need to check gstat -h before you run sweep to
> know will sweep help, and after sweep to know is sweep helped.
>

ok thanks now i will do like this. Run Sweep only if OIT < next
transaction + 20000

>
> AJ> Note: When I started to use the ServerManager
> AJ> switch (-se service_mgr) I noticed a significant speedup for gbak.
>
> yes, up to 2-4 times faster. we made tests 3 years ago and found that.
>

hmm i not understand why ?


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