Subject Re: [firebird-support] Temporarily stop and disable garbage collection
Author Ann Harrison
Here's the discussion:

> >
> > I know that I can disable garbage collection via the cmd line. What I
> > am looking for is the ability to...
> >
> > 1. Cancel any existing garbage collection
> > 2. Disable garbage collection
> > 3. Do my stuff
> > 4. Re enable garbage collection.
>

That's an odd request. It could reflect one of two things: a desire to
maintain
db_key stability or a misunderstanding of garbage collection. The first is
possible. The second is likely. I'm going to assume the second, but would
like to understand what it is you think you're going to accomplish.

> >
> >
> > I know I can to 2 and 4 via gFix but item 1 is the issue. Also I would
> > want to use the services manager rather than command line tools.
>
> You can't do 2 or 4 with gfix or anything else. There is a TPB parameter
which gbak uses that tells the current transaction not to participate in
garbage collection, but that's probably not what you want.

Before I repeat my explanation of the purpose and implementation of
garbage collection, why don't you explain what you're trying to do.

Good luck,

Ann


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