> Sadly has no one an idea for my latest problems.
>
> Perhaps, you can help me with this question.
>
> ClassicServer 2.01. After I have deleted much data once more, the
> gstat-monitor shows me the follow:
>
> Oldest Tr. 16339
> Oldest active 16340
> Oldest snapshot 4656
> Next transaction 198659
> Bumped trans. 1
> Sequenceno. 0
> Next attachmentid 428
> Implementation id 16
> Shadow count 0
> Page puffers 0
> Next header page 0
> Database dialect 3
> Creation date feb 12, 2009 20:29:52
> Attributes force write
> Sweep interval 20000
>
> The deletion I have made with IB Manager 3. I have committed all steps and
> close the program after action.
>
> What does the snapshot counter mean? Can I manually update the counters?
> (oldest transaction)

AFAIK, the oldest snapshot is the oldest active transaction at the time
of the start of a snapshot transaction.

Your statistics simply tells us that you have a long-running/active
transaction somewhere. This can be either a:

* not ended transaction
* ended transaction with using commit retaining
* transaction stuck in limbo (something went wrong during a distributed
transaction)




--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/