Mimer SQL on Windows
Mimer SQL on Windows > Mimer Info Utility > Performance Statistics > Performance - Databank Usage Statistics
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