Performance - Databank Usage Statistics
The following statistics are displayed, in the Performance output window, for each databank:
Statistics | Description |
---|---|
Name | This is the name of the databank or shadow. |
DBANKID / SEQNO | Databank identification. These two values correspond to the columns with the names DATABANK_SYSID and DATABANK_SEQNO in the data dictionary table SYSTEM.DATABANKS. |
Type | This displays the databank option: WORK, TRANS, or LOG. The SQLDB databank has the type TEMPORARY, and the shadows have the type SHADOW. |
Users | This is the number of users currently using the databank. |
Access | This is the access mode under which the databank is held opened. If a databank is not open it is not displayed and if it is open but not being accessed, 'none' is displayed. |
Also displayed, for the database, are:
Statistics | Description |
---|---|
Number of databanks currently open | This is a count of the number of databanks and shadows currently held open. |
Maximum number of databanks concurrently open | This is the setting of the Databanks parameter, set for the database using the Mimer Administrator. It determines how many databanks may be held open at the same time. |
Databank verification count | This is the number of databank verifications performed since the database was started. A databank verification is performed whenever a databank is opened after it was not correctly closed. Each time this happens, it is logged in the Mimer Log. |
Databank verification option | This information message reflects the setting of the databank check option, set for the database using the Mimer Administrator. The databank check option determines whether all pages of a databank are checked during a databank verification or just the index pages. |
See Also