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?

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. — Jan Derk, Mar 06 '13 at 13:55

score 15 · Accepted Answer · answered Mar 06 '13 at 15:19

15

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

answered Mar 06 '13 at 15:19

cincura.net

4,130
16
40

What if I am in client? I can't retrieve the executable file name from client. – Chau Chee Yang Nov 13 '13 at 05:48
The client should not have a knowledge on server edition. If you need to, you're doing probably something wrong. – cincura.net Nov 13 '13 at 10:31

score 3 · Answer 2 · answered Jul 18 '22 at 14:05

3

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'

answered Jul 18 '22 at 14:05

Pavel Katalymov

41
2

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

2 Answers2