| Subject | Re: [firebird-support] Two transactions can have the same TID? |
|---|---|
| Author | W O |
| Post date | 2013-09-08T23:53:24Z |
Thank you very much for your answer Helen.
I do backups every day, one full and several incrementals. Well, rather it is done automatically by my program.
I understand that each commited (and not commited, of course) row keeps the number of its TID, so that number is always present in the row. When after a cycle backup/restore the Next Transaction is 1 because all the integer numbers were used, what happens? that database cannot be used anymore for inserts, updates and deletes?
Greetings.
Walter.
On Sun, Sep 8, 2013 at 7:11 PM, Helen Borrie <helebor@...> wrote:
At 10:03 a.m. 9/09/2013, W O wrote:You understand correctly. When the TID is approaching the 2-billion mark you'd better start thinking about backup and restore if you've never thought it necessary before!
>Thank you very much for your answer Sean.
>
>Then, I am understanding bad or a database just can have a maximum of 2.147.483.547 commited transactions?
Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________