|
|
|
|
- Overview
- Details of available options
- Connections
- Description
- Properties
- Search
- SQL query
- Rights
- Locks
- Log
- Maintenance
WDAdminHF: Managing the data files
Available only with these kinds of connection
The remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases. To display the characteristics of an HFSQL Client/Server data file: - Connect to the requested HFSQL server via the remote HFSQL administrator.
- Select "Databases".
- Select the requested database and click the "Access the selected database" link.
- The displayed options are the options available on the current database. Click "Files".
- Click the name of the data file to manage. The available options are displayed.
Details of available options Connections This option lists the different users connected to the current data file. The list of active connections contains the following information: - the username,
- the computer name,
- the name of the application that accesses the database, etc.
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. Description This option is used to display the description of the different items in the data file (item name, size, type, etc.). Properties This option is used to display the properties of the data file (physical name, format, protection, etc.) Search This option is used to perform a search in the data file. You have the ability to enter the search conditions in an explicit way. SQL query This option is used to perform a search in the data file. You have the ability to directly enter the SQL code of the query to run. Rights This option is used to manage the rights on the data file for the selected user or group. Locks This option is used to manage locks. The following information is displayed: - the number of the locked record,
- the name of the user who is locking,
- the name of the locking computer,
- the IP address of the locking computer,
- the name of the locking application,
- the lock start date,
- the lock duration.
Log This option is used to view the content of the logs and to perform a search in the logs. The file must be logged. Maintenance This option is used to free a record or all transactions.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|