At 01:54 AM 12/12/2002 +0000, c_pradelli <c_pradelli@...> wrote:

>Hi!
>
>Wich is the limit of the transaction number and what happend if a gdb
>reach it?
>
>I made this question because I have a database that receive about
>100.000 transactions a day and by now the next transaction number is
>about 1.000.000.

The transaction limit is 2**64, thus approximately 2.147.000.000. At
100.000 transactions per day, you have about 5.8 years before you'll
absolutely need to backup and restore the database. I suggest an
annual backup/restore.


Regards,

Ann
www.ibphoenix.com
We have answers.