Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to check in which server mode (e.g. SuperClassic or Superserver) a Firebird database is running?

The latest Firebird 2.5.x database can run in either Classic, SuperClassic, or SuperServer mode. How can I check in which of these modes an installed database is running?

like image 981
Jan Derk Avatar asked Mar 06 '13 11:03

Jan Derk


People also ask

How do I know if Firebird is running?

To check that the Firebird Server is running in Windows just go to Services applet and check for Firebird Server and Firebird Guardian services. Alternatively, if you used the installer Firebird will have installed a Server Control Applet in the Control Panel.

How do I check my Firebird server version?

You can find your client software version by opening the menu item Help --> About. You can find your Firebird Server version by clicking the Check Firebird Version button in the Database Connection window using the menu option Tools --> Database Connection.

What is Firebird Superserver?

Superserver. Processes. Creates a separate process for every client connection, each with its own cache. Less resource use if the number of connections is low. A single process serves all connections, using threads to handle requests.

What is Firebird SQL server on my computer?

Firebird is an open-source SQL relational database management system that support Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.


1 Answers

There's no API that exposes this. But because you're on a server, you can check what process is running.

I.e. on Windows and Firebird 2.5:

  • One fb_inet_server.exe = very likely SuperClassic
  • Multiple fb_inet_server.exe = very likely Classic
  • fbserver.exe = very likely SuperServer
like image 143
cincura.net Avatar answered Oct 22 '22 15:10

cincura.net