Hello, I have a few questions about the transaction numbers.
The documentation at http://www.firebirdsql.org/manual/gstat-example-header.html says that OST is normally the same as OAT. * When could OST be different to OAT? * Is it possible to simulate this situation (OST != OAT) by using isql? If yes, how? * If OST and OAT are different, which one is higher? My current understanding is that OIT is always the lowest of the three, and I think that OAT should be less or equal than OST. * Is this true, then? OIT <= OAT <= OST Also, given that OST is the oldest snapshot transaction: * What happens if there is no current snapshot transaction? * If the database had never had a snapshot transaction, would this value be 1 (or 0) while OAT and OIT have moved on? And one extra question: * If I'm in the middle of a transaction and the network connection breaks, what happens to the OAT/OIT/OST - in particular, does any of them get stuck? If yes, for how long? Thanks in advance for any help and/or links where I could find answers. Best regards, Fernando Nájera ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
