> Hi,
>
> ODS 10.2 has 2^31 transaction id.
> I believe this spec is some limitation if Firebird is used
> under 24x7 web system.
> I know transaction id is reset when database is back-up/restoring.
>
> I would like to know how to avoid this limitation in your system.
> Please let me know whether FB2.0 change this limitation or not.
>
> Regards.
>
> Daiju

if you ever do reach this limit, the transaction ID just rolls over. Don't
forget that in a web system the trasnactions are only as long as the page
that is delivered so there are no long running transactions and nothing gets
"stuck"
Alan