Displaying system databases

Displaying system databases

Procedure

  1. Select option D.2 from the "Service Manager Selection Menu" to display the "Dictionary Selection Menu".
  2. Select option 4 to call the "Display System Databases" panel. This shows a table of all the system databases:

    PEB5DI01 ----------------------------------------------------- Row 1 of 4
    Command ===> _______________________________________________ Scroll ===> PAGE

    Display System Databases ( LEFT/RIGHT )

    Data Set Name X Sta FileID Buffer % Type HWM
    BETA09.DB.DEF OPN 00001 00000000 050 NO 00
    BETA09.DB.SYNC OPN 00255 00000000 001 SY 90
    BETA09.DB.VDF OPN 00256 00000020 004 DA 90
    BETA09.DB.VDF.KEY OPN 00257 00000020 007 KE 90
    ******************************* BOTTOM OF DATA ********************************












  3. Scroll to the right (normally PF11) to view additional information.

Columns

Column

Description

Dataset name

Name of the system database.

Stat

The Status column can contain one of the following:

USE (in use): the dataset is in use

CLS (closed): the dataset cannot be opened

MOD (model): not available for VDF

ONL (read only): the dataset can only be read

FMT (format): not available for VDF

EMP (empty): the dataset is empty

ERR (error): an error occurred

FEX Format extend error

FUL (full): the dataset is full

OPN (open): the dataset is active and can be used by the started task

FileID

File identification number; the file ID is automatically assigned by the system.

Buffer

Number of buffers that can be used for cache.

%

Number of 4K blocks in use displayed as percentage.

Type

Database type. The following database types may be displayed:

DA (DATA) for a VDF.Data file.

KE (KEY) for a VDF.Key file.

SY (SYNC) for a Sync.Data file.

NO for a definition file.

SP (SPOOL) for a spool file.

CA (CACHE) for a cache file.

IX (INDEX) for an index file.

HWM

Displays the high water mark value (in percent), which is used as a warning level for used space

You can change the high water mark of a database using BST05CMD or BST05UPF. (For examples, see the description of the corresponding utility in "Databases and database batch utilities" in BSA Installation and System Guide.)

VolSer

The volume currently in use. When SMS is displayed here, the assignment of a volume or unit has been left to the SMS.

Unit

The unit type where the dataset is stored.

Space

The space in cylinders required by the dataset.

CIsize

The size of the Control Interval (CI). This can be a value between 1 and 7. The value specified will then be multiplied by 4096.

Short Name

Short name of the dataset.