Subject Odp: [firebird-support] Re: MON$STATEMENTS - RDB $STATEMENT_ID - Integer?
Author liviuslivius@poczta.onet.pl
Hi Dmitry,

But what happen if to database is always someone connected? This is 24/7 software.

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Dmitry Yemanov" <dimitr@...>
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Re: MON$STATEMENTS - RDB$STATEMENT_ID - Integer?
Data: czw., sty 2, 2014 20:17


 

31.12.2013 12:38, liviuslivius wrote:

>
> we use FB2.5
> and i see that in monitoring tables MON$STATEMENTS field
> RDB$STATEMENT_ID is type Integer.
> What happen when it reach max int value?

This is highly unlikely, see below.

> When it is reset - backup restore?

The counter supporting statement ID is not persistent, i.e. it's kept in
memory and reset as soon as everybody disconnects from the database.

Dmitry