|
|
|
|
|
|
|
|
|
|
- Overview
- Details of available options
- Connections
- Description
- Properties
- Search
- SQL query
- Rights
- Locks
- Log
- Maintenance
WDAdminHF: Data file management
  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 can manage connections from this page: prohibit or authorize connections, disconnect users, or send a message to 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|