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