Querying against FB 2.5 RC3 server I can see values 0, 1, 2 in the mentioned field. But release notes describe only 0 and 1. What does 2 mean?
+1
A:
I think it might be Idle after processing select, but before reaching end of data and releasing the statement as stated in the following link:
Enhance MON$STATEMENTS / MON$STATE to represent real CPU consumption
which was introduced in the 2.5 Beta 1 release as shown in Release Notes - Firebird Core - Version 2.5 Beta 1
Not quite sure if it was really added as the bug report suggested, but they also speak about a state 3 which would be Active during data retrieval. You could always ask in the Firebird mailing list which you can find at Firebird Lists and Newsgroups.
Best regards
Guillem Vicens
2010-10-02 10:31:49
I've got an answer on some russian forum. There are three states: IDLE -- after Prepare but before Execute and after Close cursor. ACTIVE -- while statement being executed. STALLED -- for SELECT statements when not all records where fetched.
Andrei K.
2010-10-04 16:22:48