Displaying dataset information

Displaying dataset information

Overview

Under option D.1, line command S in front of a dynamic database provides the same information as the IDCAMS LISTCAT command. If the selected database does not support dynamic extension (e.g. a SPOOL database), the amount of information provided is reduced. The examples below show the results for a dynamic database.

Procedure

  1. 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.
  2. Enter the line command S in front of a database file to display page 1 of the "Display Data Set Information" panel:

    PEB5DD21 --------------------------------------------------------- Page 1 of 3
    Command ===>

    Display Data Set Information

    Product : B93 SYSVAR Support : INACTIVE
    Data Set Name : QAB93.Q93U.DB.MAIN

    Database Information
    Short Name : B93MAIN File ID : 00012
    CI Size : 04096
    High Alloc RBA : 0000090000
    High Used RBA : 0000090000

    Cache Buffer : 00000050
    I/O-Read : 0000000366
    Type : DA I/O-Write : 0000000003
    Data Set Status : OPN I/O-Requests : 0000201377
    High Water Mark : 90 Percent Caching : 100 Percent



    Press DOWN to display the next page or END to return to the previous panel.

  3. Scroll down (normally PF8) to display page 2:

    PEB5DD22 --------------------------------------------------------- Page 2 of 3
    Command ===> _________________________________________________________________

    Display Data Set Information

    Product : B93 SYSVAR Support : INACTIVE
    Data Set Name : QAB93.Q93V.DB.MAIN

    VSAM Information
    Catalog Name : CATALOG.MVSICF1.VQAP2
    Cluster Name : QAB93.Q93V.DB.MAIN
    Data Name : QAB93.Q93V.DB.MAIN.DATA
    Extended VSAM File : NO
    Space Information
    Primary Space : 000500 Cylinders Record Length : 04096
    Secondary Space : 000000 Cylinders Records per Track : 00012
    Total Space : 000500 Cylinders Tracks per Cylinder : 00015
    Number of Extents : 001
    SMS Information
    MGMTCLAS : MC#STD STORCLAS : SC#QAP2 DATACLAS :


    Press DOWN / UP to display the next / previous page or END to return.

  4. Scroll down again to display page 3:

    PEB5DD23 --------------------------------------------------------- Page 3 of 3
    Command ===> _________________________________________________________________

    Display Data Set Information

    Product : B93 SYSVAR Support : INACTIVE
    Data Set Name : QAB93.Q93V.DB.MAIN

    Volume Information
    Number of Volumes : 01 Number of Volume Candidates : 00

    Vol_01 Vol_02 Vol_03 Vol_04 Vol_05 Vol_06 Vol_07 Vol_08 Vol_09 Vol_10
    QAP202









    Press UP to display the previous page or END to return to the previous panel.

Fields (general)

Field

Description

Product

The Beta Systems product you are currently working with.

Data Set Name

The VSAM file name of the selected dataset.

If a static system symbol was replaced in the dataset name, then both forms of the dataset name will be displayed – the actual dataset name with the replaced value, and the name stored in the database definition file with the static system symbol.

SYSVAR Support

Indicates whether SYSVAR support is active or inactive.

Fields (Database Information)

Field

Description

Short Name

Short name used by the system.

File ID

Unique number automatically assigned by the system.

CIsize

Size of the VSAM control interval.

High Alloc RBA

Number of the highest allocated relative byte address.

High Used RBA

Number of the highest used relative byte address.

Volume

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

Cache Buffer

Number of 4K storage buffers for performance improvement.

Type

Indicates the type of database:

NO

Definition file

CA (CACHE)

Cache file

DA (DATA)

Data file

GL (GLOBL)

Global index file

IX (INDEX)

Index file

KE (KEY)

Key file

LO (LOG)

Log file

SP (SPOOL)

Spool file

SY (SYNC)

Synchronization file

Data Set Status

The dataset status can be:

CLS

closed

EMP

empty

ERR

error

FEX

format extend error

FMT

format

FUL

full

MOD

model

ONL

read only

OPN

open

High Water Mark

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

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.)

Warning threshold/ Allocated

These values are displayed only if the optional MAXSIZE value has been defined for this database in the database definition file:

Warning threshold is a user-defined value (in cylinders) which can be used to monitor the growth of dynamic databases when extents are formatted (messages 9549I and 9549W).

Allocated displays the amount of allocated space (in percent) in relation to the warning threshold.

I/Os

Number of read/write operations, number of requests.

Caching

Database access displayed in percentage points. Shows access processed via the BQL speedmaster function, not via the database.

Fields (VSAM Information)

Field

Description

Catalog Name

Name of the VSAM catalog.

Cluster Name

Name of the VSAM cluster.

Data Name

Name of the VSAM cluster type DATA.

Extended VSAM File

Extended VSAM files are defined via the SMS data class.

Fields (Space Information)

Field

Description

Primary Space

Primary space required by the file in cylinders.

Secondary Space

Secondary space required by the file in cylinders.

Total Space

Total space allocated to the file in cylinders.

Number of Extents

Number of extents used by the file.

Record Length

Maximum length of a dataset record.

Records per Track

Number of records per track.

Tracks per Cylinder

Number of tracks per cylinder.

Fields (SMS Information)

Field

Description

MGMTCLAS

Only if SMS is used; MVS management class.

STORCLAS

Only if SMS is used; MVS storage class.

DATACLAS

Only if SMS is used; MVS data class.

Fields (Volume Information)

Field

Description

Number of Volumes

Number of volumes that have been defined.

Number of Volumes
Candidates

Number of unused volumes that are still available.

Vol_01 .. Vol_10

Volser number(s) of the volume(s) on which the dataset resides.