602SQL Server Manager

602SQL Server Manager is a tool that provides in one place for the following:

start and stop 602SQL servers version 11 and later;
monitoring basic information (number of clients, time since start etc.) for each 602SQL server;
monitoring records to the basic log for each 602SQL server.

Start and Stop of Servers

Server Manager is common for all local SQL servers starting from version 11. Remote SQL servers, even if they are registered at the computer where Server Manager is running, cannot be controlled.

The server menu distinguishes by color the servers that have been already started from those inactive. It does not matter how was the 602SQL server started.

Starting of Servers

If the SQL server start requires password specification (see Database file protection) for data decryption, the Specify the password for the database checkbox must be selected at startup - you can then enter necessary password in the auxiliary window.

If the SQL server should start as a service on Windows or as a daemon on Linux, the Start this SQL server as system service checkbox must be selected prior to startup, or Start this SQL server as daemon on Linux. To make this action possible (to make this checkbox enabled), the 602SQL server of the corresponding name must be registered as a service (daemon) in the operating system. The registration is done from the 602SQl Client in the Database Management window on the Service / Daemon tab.

Stopping of Servers

The running 602SQL server of version 11 and later can be stopped by Server Manager. If some clients are logged in to the server at this moment, Server manager transmits a warning and lets the clients decide whether to stop the server immediately and disconnect the clients or to open a warning window containing a notification for the clients connected via TCP/IP (the most frequent way), to wait 60 seconds and in case the clients do not disconnect during this time themselves, to disconnect them.

To terminate server from Server manager, following rules apply:

if an Anonymous user is a member of operating administrator group CONFIG_ADMIN, then Server Manager does not perform login and terminates the server;
if an Anonymous user is not a member of CONFIG_ADMIN group, then Server Manager asks in a login dialog for a name and password of some CONFIG_ADMIN group member.

Information about Server

Server Manager is able to determine and list certain number of information about the running server. Server Manager must connect for each extraction of data to the server (however, it need not login).

Following information can be obtained:

whether the server is running as a task or as a service/daemon;
how many clients are currently logged in (more precisely, according to system query terminology _iv_logged_users those are all client threads apart from worked_threads);
which access interfaces (communication protocols) the SQL server provides, including information about IP address and port numbers;
version number and build number of the 602SQL server;
how long the server has been running since the startup.

For information refresh, press the Update now button. By entering the number of seconds you can specify an interval for automatic refresh of the whole Server Manager window (including the list of servers and listing of log).

Listing of Server Log

For each running server, it is possible to monitor listing to the basic server log. For refresh, information from the previous paragraph applies.

SQL Server Operation

SQL Server Operation on Windows