Subject Re: [firebird-support] Two transactions can have the same TID?
Author W O
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?



On Sun, Sep 8, 2013 at 7:11 PM, Helen Borrie <helebor@...> wrote:

At 10:03 a.m. 9/09/2013, W O wrote:

>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?

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!

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"