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]
