Querying SQLFire System Tables and Indexes

Through access to configuration and run time metrics through SQL commands, SQLFire enables monitoring from a number of tools.

You can monitor a SQLFire distributed system through SQL commands (Views and system procedures) and also through the GemStone Visual Statistics Display - a graphical tool to monitor statistics captured by each member in real-time or to chart historical statistics.

You can also use the sqlf command-line tool, or any third party tool like SQuirreL.

All monitored information from SQL commands can also be scripted using the sqlf tool. And, all captured statistics are also accessible from a script using the sqlf command.