> My questions:
>
> 1) What could be that something that happens and results in freezing
> the system?
>

Garbage Collection.

> 2) How can the sweep gap be negative? I thought it is zero or
> positive by definition?
>

Im no expert, but sounds like something is broke.

> 3) Client application only uses two types of transactions:
> static char isc_tpb[5] = { isc_tpb_version1, isc_tpb_read,
> isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_wait };
> static char isc_tpb[5] = { isc_tpb_version1, isc_tpb_write,
> isc_tpb_read_committed, isc_tpb_rec_version, isc_tpb_wait };
>
> and it never uses snapshot transactions nor backup is going on at
> that time.
> Then what does Oldest Snapshot (OS) number really mean then?
> And how it can become lower than OI?
>
> 4) Why a number of active transactions (AT) is so crazy? :)
>
> Thank you,
> Glebas
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.