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

Question

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?

Aitch

From application or on a server? – Backswept

On a server. But an application like Flamerobin won't tell me either. It allows me to retrieve the database version, but not the server mode. – Aitch

Answer 1

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

Backswept

What if I am in client? I can't retrieve the executable file name from client. – Jeraldinejeralee

The client should not have a knowledge on server edition. If you need to, you're doing probably something wrong. – Backswept

Answer 2

Firebird 4+ has RDB$CONFIG table. To read ServerMode see record with rdb$config_name='ServerMode':

select rdb$config_value from RDB$CONFIG where rdb$config_name='ServerMode'

Courtly