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

Jan Derk picture Jan Derk · Mar 6, 2013 · Viewed 7.6k times · Source

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?

Answer

cincura.net picture cincura.net · Mar 6, 2013

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