(Contents)(Previous)(Next)

Administrative Information

ADABAS provides more system tables that are mainly needed for administrative tasks.

Display of a list of the users currently working with the database:

SELECT * FROM domain.connectedusers

Query to retrieve information about all SERVERDBs of the distributed database.

For example, their state and the corresponding SERVERNODE are indicated.

SELECT * FROM domain.serverdbs

Information about the current state of the runtime environment and the operational database kernel:

SELECT * FROM domain.versions

Display of the system database administrator of the SERVERDB to which the current user is connected.

SELECT sysdba FROM dual


(Contents)(Previous)(Next)