Hi, all
following is the result from the above threaded example:


Following is a PHP script to test the Firebird
System Monitoring Tables with the new SQL commands in FB2.1++
Folowing functions require that the database is on the connection
Here is it, test it, and expecting your reply.

2007-11-02-12-37-48.
monitor table connection OK
select * from MON$DATABASE

MON$DATABASE_NAME: /home/litaoman/employee.fdb
MON$PAGE_SIZE: 4096
MON$ODS_MAJOR: 11
MON$ODS_MINOR: 1
MON$OLDEST_TRANSACTION: 1153
MON$OLDEST_ACTIVE: 1154
MON$OLDEST_SNAPSHOT: 1154
MON$NEXT_TRANSACTION: 1154
MON$PAGE_BUFFERS: 2048
MON$SQL_DIALECT: 3
MON$SHUTDOWN_MODE: 0
MON$SWEEP_INTERVAL: 20000
MON$READ_ONLY: 0
MON$FORCED_WRITES: 0
MON$RESERVE_SPACE: 1
MON$CREATION_DATE: 2007-10-16 04:02:13
MON$PAGES: 269
MON$BACKUP_STATE: 0
MON$STAT_ID: 1

disconnect from database OK !

Yours
O'Li