Database list page
Repository > Database
Purpose of the page¶
This page shows a list of all the available databases and allows the system administrator to run management operations.
Buttons and/or links on the page
| Element | Description |
|---|---|
| Disconnection message for connected users: sends a message to users who are about to be disconnected from a specific database.The notification may take a few minutes. If the user is an administrator of repository or of the application DB on which the notification was sent (possesses function 0000008 or 0004132, respectively), he will not receive any notification and will not be logged out Disconnect users: disconnects users connected to a specific database. Repository administrators can in any case access that database and carry out activities on it according to their own profile. Upper/lower case alignment in codes: makes it possible to correct anomalies in the codes (upper/lower case) of the data tables, using the codes present in the list tables as the master. Encode data: encodes the data in a database to prevent unsupported characters from being saved and misinterpreted. Also applicable to individual columns of the database table. Remove unsupported characters: removes characters not supported by the application from the database (the char(0) character, for example). Note: this function is only available on application databases connected to the Microsoft SQL Server or Oracle type application. Report on data in the database: generates a report on the quantity of data contained in a database, to assess the dimensions of the tables and the extent to which this affects processing speed. Benchmarks: runs a performance test on the database, network, memory (CPU), I/O on disc. Connection Timeout: sets the maximum waiting time for the database’s response. Identifies any timeouts on the connection between the application server and the database. |
Page fields
Please find below the most important fields.
| Field | Description |
|---|---|
| Info | : the connected user has no rights to edit the database. |
| Type | Database type: - Repository: single centralised database - Primary: application database - Secondary: accessible external database - Not Configured: database which cannot be used |
| Login Status | Enabled: it is possible to connect to the database Not enabled: it is not possible to connect to the database |