Displaying databases (Option D.1)

Procedure

Select option 1 from the "Database Selection Menu" to display a list of databases for the selected subsystem ID. The "Data Set Definition Selection" panel is called:

PEB5DD10 ---------------------------------------------------- Row 1 of 4
 Command ===> ________________________________________________ Scroll ===> PAGE

 Dataset Definition Selection Page 1 of 3
 ( LEFT/RIGHT )
 Databases for SSID F09A SYSVAR Support : INACTIVE

 I - Insert Model F - Format Model
 S - Select Dataset Definition or D - Delete Model or Empty
 Update Model or Status R - Reset Model (ERR)
 X - Database Extension RX - Reset Database Extension (FEX)

 Sel Dataset Name X Total Free % Sta
 BETA09.DB.DEF 00000180 00000089 050 OPN
 BETA09.DB.SYNC 00000180 00000177 001 OPN
 BETA09.DB.VDF 00001800 00001716 004 OPN
 BETA09.DB.VDF.KEY 00000900 00000836 007 OPN
 ******************************* Bottom of data ********************************






Columns

Column

Description

Data Set Name

Names of the datasets. All datasets are VSAM/ESDS organized.

X

Y in this column indicates the presence of database extensions based on concatenated datasets (EXT01, EXT02 etc.). The current BSA version provides only limited support for this type. While it is possible to continue to work with the existing database, the current BSA version does not support any further extension.

Important: It is no longer meaningful to work with concatenated VSAM datasets because BSA (as of V4) supports the so-called "extended VSAM datasets", which enable a total maximum size of 28 GB for BQL databases. If you are still working with concatenated datasets, include the task of merging these datasets when planning your database maintenance.

Total

Total number of 4K blocks allocated.

Free

Total number of free 4K blocks.

%

Percentage of 4K blocks currently in use.

Sta

Status of the database component:

USE (in use):

The dataset is in use.

ERR (error):

An error occurred.

FEX:

Format extend has ended in error.

MOD (model):

Not available for VDF.

ONL (read only):

The dataset can only be read.

FMT (format):

Not available for VDF.

FUL (full):

The dataset is full.

EMP (empty):

The dataset is empty.

OPN (open):

The dataset is active.

Line commands

S

Select a dataset to display definitions

I, F, D, R

Insert model, format model, delete model or empty, reset model in error.
These line commands are explained in the Beta product documentation when spool files, index files or cache files are available for the product.

X

starts the dynamic database extension manually. This command is only available for dynamic databases. This means that the database must fulfill the following conditions:

  • Type is DA (DATA) or KE (KEY)
  • Secondary space has been defined or volume candidates are available or both

Maximum size: BQL databases support a total maximum size of 4 GB for a standard VSAM dataset and of 28 GB for an extended VSAM dataset. Extended VSAM datasets are defined via the SMS data class.

RX

Reset FEX status (Format EXtend error)