Subject | RE: [firebird-support] Two transactions can have the same TID? |
---|---|
Author | Leyne, Sean |
Post date | 2013-09-09T16:56:16Z |
Querying the MON$Database table.
Depending on your engine version (minor ODS) the current TID value should be available as a column.
Sean
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
On Behalf Of W O
Sent: Monday, September 09, 2013 12:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Two transactions can have the same TID?
Excellent Lester!!!
That's the answer I was looking for.
Greetings.
Walter.
On Mon, Sep 9, 2013 at 3:31 AM, Lester Caine <lester@...> wrote:
W O wrote:
> 3. The restored database can have another 2.000.000.000 of commited
> transactions, doing a total of 4.000.000.000 of commited transactions. Is that
> right?Yes
But another way of saying it is ... there is no limit on the number of committed
transaction, as long as you backup and restore before the active count reaches
the active limit.
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org 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
<*> 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:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/