During the connection to the remote HFSQL administrator, you must specify the HFSQL server that will be taken into account. Then, the different options available on the selected server are listed.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Details of available options

Databases

This option is used to select one of the databases found on the server. This gives you the ability to access all the options for managing the database.

Connections

This option lists the different users connected to the different databases found on the server.

The list of active connections contains the following information:

the database name,

the user name,

the computer name,

the name of the application that accesses the database, ...

You have the ability to manage the connections from this page: allow or forbid the connections, disconnect the users or send a message to the users.

Transactions

This option is used to manage the current transactions or the interrupted transactions on the server.

Users

This option is used to find out and manage the users of the server. You have the ability to create, modify or delete a user.

When creating or modifying a user, the user can be a super user: the users defined as "super user" are allowed to perform all types of actions on the server, on the databases and on all the data files.

Groups

This option is used to find out and manage the groups of users of the server. You have the ability to create, modify or delete a group of users.

You also have the ability to associate users with a group.

Rights

This option is used to manage the rights on the server for the selected user or group.

System information

This option is used to find out:

the server platform.

the platform version.

the architecture of the engine.

the server processor.

the available memory.

the version of the elements on the server.

Server configuration

This option is used to configure the server. The following elements are taken into account:

Location of databases on the server ("General" option)

Directory of logs and backups ("Logs" option)

Log file ("Logs" option): you have the ability to specify the directory of the log files and to enable some backup options. You also have the ability to specify the maximum size for log file.

Size of the index cache ("Caches" option). Note: in 32 bits, the size of index cache is limited to 1GB.

Activity statistics ("Activity stat." option): The activity statistics are used to measure the server workload. You have the ability to enable the activity statistics ans to specify the backup directory.

Logs

This option is used to view the server logs directly. This option is available only if the logs are enabled on the server.