A>
A>
A> Что значит MON$STATE = 1 в таблице MON$ATTACHMENTS?

вот что написано в README.monitoring_tables.txt

MON$ATTACHMENTS (connected attachments)
     - MON$ATTACHMENT_ID (attachment ID)
     - MON$SERVER_PID (server process ID)
     - MON$STATE (attachment state)
         0: idle
         1: active
     - MON$ATTACHMENT_NAME (connection string)
     - MON$USER (user name)
     - MON$ROLE (role name)
     - MON$REMOTE_PROTOCOL (remote protocol name)
     - MON$REMOTE_ADDRESS (remote address)
     - MON$REMOTE_PID (remote client process ID)
     - MON$CHARACTER_SET_ID (attachment character set)
     - MON$TIMESTAMP (connection date/time)
     - MON$GARBAGE_COLLECTION (garbage collection flag)

и еще вот так
 Notes:
   1) Textual descriptions of all "state" and "mode" values can be found
      in the system table RDB$TYPES


--
С уважением
Кочмин Александр
Firebird Foundation associate member #257

Ответить