Display VSAM information (BLANK)


Although option BLANK displays data set information for data sets of any access method, this section discusses the VSAM information display. The information is retrieved from the catalog, formatted on a scrollable screens and arranged in sections.

The primary difference between File-AID data set information displays and normal ISPF is the amount of information presented for VSAM, IAM and BDAM data sets. All information that is available for these data sets (allocation, utilization, etc.) is displayed. For IAM™ and BDAM data sets, this information is contained on one screen. For VSAM datasets, it includes the info additional dataset names related to a given cluster (In Batch, FILEAID "VSAMINFO" request is used to prepare the VSAM report).

Information displays for any type of data set can be requested from the VSAM utility screen (VSAM Utility screen) by entering a dataset name and pressing Enter or by placing an S next to the dataset name in a dataset selection list.

When you press Enter, File-AID displays the VSAM Information screen as shown in the the following figure.

If the data set is multi-volume, File-AID/MVS displays the MULTI-VOLUME DATASET message in the upper-right hand corner and the + multi-volume dataset message and a + (plus) sign following the Data Volume and Index Volume fields.

Important

The VSAM type of the selected data set determines which fields are displayed in the VSAM Information screen (see the following figure).

VSAM Information Screen

----------------------- File-AID VSAM INFORMATION -------- Row 1 to 22 of 66
 COMMAND ===>                                                SCROLL ===> CSR


   CATALOG: CATALOG.MVSICFU.V01KTOR
   CLUSTER: 'TSOID01.FASAMP.EMPLOYEE'
      DATA: 'TSOID01.FASAMP.EMPLOYEE.DATA'            DATA VOLUME: PRD937
     INDEX: 'TSOID01.FASAMP.EMPLOYEE.INDEX'           INDEX VOLUME: PRD937


 DATA COMPONENT INFORMATION:                   CURRENT ALLOCATION OPTIONS:
   DEVICE TYPE:                  3390           LOAD OPTION:   RECOVERY
   ORGANIZATION:                 KSDS
   AVERAGE RECORD SIZE:           198           BUFFER SPACE:     6144
   MAXIMUM RECORD SIZE:           198           ERASE ON DELETE:   NO
   KEY LENGTH:                      5           EXCEPTION EXIT:
   KEY LOCATIONS:                   0           REUSE OPTION:     YES
                                                WRITE CHECK:       NO
                                                SHARE OPTIONS:    3-3
                                                SPANNED RECORDS:   NO
                                                KEY RANGES:        NO


 DATASETS RELATED TO ENTRY - 'TSOID01.FASAMP.EMPLOYEE'
 TYPE           DATASET NAME
 CLUSTER   - TSOID01.FASAMP.EMPLOYEE


 RLS INFORMATION:                             SMS INFORMATION:
   VSAM QUIESCED:            NO                 OWNER ID:
   RLS IN USE:               NO                 STORAGE CLASS:   STDDODFW
   LOGREPLICATE:             NO                 DATA CLASS:
   LOG:                    NULL                 MANAGEMENT CLASS: SAMPLE@S
   FRLOG (BATCH LOGGING):  NULL                 EXTENDED ATTRIBUTES: NULL
   LOGSTREAMID:                                 BWO:                 NULL


 ENCRYPTION INFORMATION:
   KEYLABEL:


  ACCOUNT INFORMATION:


  DATE INFORMATION:                             DATA RECORDS:
   CREATION DATE:        02/10/2019              TOTAL:    50
   EXPIRATION DATE:                              DELETED:   0
   MODIFICATION DATE:    19/03/2020              INSERTED:  0
   MODIFICATION TIME:    12:08 PM GMT            UPDATES:   0
                                                 RETRIEVED: 0


  SPACE ALLOCATION INFORMATION:
    DATA:                                        INDEX:
    UNIT:                 TRACKS                  UNIT:         TRACKS
    PRIMARY:                   1                  PRIMARY:           1
    SECONDARY:                 1                  SECONDARY:         1
    ALLOCATED TRACKS:          1                  ALLOCATED TRACKS:  1
    USED TRACKS:               1  (100%)
    ALLOCATED EXTENTS:         1                  ALLOCATED EXTENTS: 1
    USED EXTENTS:              1  (100%)
  VOLUME INFORMATION:
    PHYSICAL RECORD SIZE:   2048
    RECORDS PER TRACK:        21
    TRACKS PER CA:             1


  CURRENT ORGANIZATION INFORMATION:
                        DATA:      INDEX:       INDEX STATISTICS:
  NUMBER OF CA SPLITS:     0           0          NUMBER OF LEVELS:       0
  NUMBER OF CI SPLITS:     0           0          ENTRIES PER SECTION:    0
  CI SIZE:              2048        2048          FIRST SEQUENCE-SET RBA: 0
  NUMBER OF CIS/CA:        21          0          EXCEPTION EXIT:
  FREE CIS/CA:              0          0
  PERCENT FREE              0          0
  PERCENT FREE BYTES/CI:    0          0
 ******************************* Bottom of data ********************************


Field Descriptions

The VSAM dataset information display contains general cluster information: Catalog, Cluster name, Data component name and Volume, and for KSDS the Index component name and Volume.

CATALOG

Catalog name.

CLUSTER

Fully qualified name of the VSAM cluster.

DATA

Data component name.

INDEX

Index name.

DATA VOLUME

Name of the device on which data is stored.

INDEX VOLUME

Name of the device on which index is stored.

DATA COMPONENT INFORMATION:

DEVICE TYPE

Type of device on which data is stored (for example: 3380, 3390, etc.).

ORGANIZATION

Type of VSAM cluster organization: KSDS, KSDS EXTENDED, KSDS EXTENDED COMP (Compressed), ESDS, RRDS, LINEAR (LDS), or AIX for alternate indexes which is always KSDS.

AVERAGE RECORD SIZE

Estimated average size of data record specified at allocation.

MAXIMUM RECORD SIZE

Largest possible data or index record that data set can contain.

KEY LENGTH

Length of field within each record that contains key information. This is the length of the prime key for base clusters and length of the alternate key for alternate indexes.

KEY LOCATIONS

The relative position of the prime record key for KSDS base clusters; the relative position of the alternate key in the base cluster for alternate indexes.

AIX-UNIQUE KEYS

For alternate indexes only, specifies whether more than one base cluster record can contain the same alternate key.

AIX-UPGRADE

For alternate indexes only, specifies whether the alternate index is updated to reflect changes made to the base cluster.

CURRENT ALLOCATION OPTIONS:

LOAD OPTION

Specifies whether the data control intervals are preformatted before data records are inserted. When this option is set to SPEED, the data control intervals are not preformatted. When set to RECOVERY, the data control intervals are preformatted.

BUFFER SPACE

The minimum buffer space in virtual storage to be provided by a processing program.

ERASE ON DELETE

Specifies whether records are erased when deleted.

EXCEPTION EXIT

The name of a user-written exception-exit routine that receives control when an exceptional I/O error occurs for the DATA Component.

REUSE OPTION

Specifies whether the data set is reusable (can be reloaded).

WRITE CHECK

YES/NO Indicates whether write operations are checked for data checks.

SHARE OPTION

Specifies the amount of sharing among regions-systems. The first number displayed is the region share option:

1 - The data set can be shared by any number of users for read processing. VSAM ensures data integrity.

2 - The data set can be shared by any number of users for read processing and can be accessed by one user for processing. ENQ/DEQ required for read integrity.

3 - The data set can be shared by any number of users. Each user is responsible for integrity.

4 - The data set can be shared by any number of users and the buffers used for direct processing are refreshed for each request.

The second number shown is the system share options:

1 - Reserved.

2 - Reserved.

3 - The data set can be fully shared. Each user is responsible for read and write integrity.

4 - The data set can be fully shared. Buffers used for direct processing are refreshed for each request. Reserve/release macros are required.

SPANNED RECORDS

Data records can be longer than the control interval length and can cross or span control intervals.

KEY RANGES

Specifies that portions of key-sequenced clusters are to be placed on different volumes.

DATASETS RELATED TO ENTRY

Fully qualified name of the VSAM dataset listing the TYPE and DATASET NAME.

RLS INFORMATION:

VSAM RLS requires that data sets be SMS-managed.

VSAM QUIESCED

The quiesce option stops access to the VSAM RLS secondary lock structure.

RLS IN USE

Specifies whether or not RLS is in use for the data set.

LOGREPLICATE

(z/OS 2.1 and up) Identifies whether or not the VSAM dataset being defined is eligible for VSAM replication.

LOG

If you do not specify LOG, RLS cannot access the data set.

NONE - This option declares the data set to be nonrecoverable.

UNDO - This option declares the data set to be backward recoverable.

ALL - This option declares the data set to be both backward recoverable and forward recoverable.

REDO - This option declares the data set to be forward recoverable.

FRLOG (BATCH LOGGING)

ALL - Enables the changes made to your VSAM dataset to be both backed out and forward recovered using the VSAM logging.

NONE - Indicates that the data set can be used for VSAM batch logging. However, the function should be disabled.

REDO - Enables the changes made to your VSAM dataset to be forward recovered using the VSAM logging.

UNDO - Enables the changes made to your VSAM dataset to be backed out using the VSAM logging.

LOGSTREAMID

The name of the forward recovery log stream.

SMS INFORMATION:

The following fields are displayed for SMS sites only.

OWNERID

The ID of the data set owner.

STORAGE CLASS

The SMS Storage Class to be used to allocate the data set. The Storage Class is used to describe the hardware requirements of the data set.

DATA CLASS

The SMS Data Class to be used to allocate the data set. The Data Class is used to describe the attributes of the data set such as RECFM, DSORG, LRECL, BLKSIZE, etc...

MANAGEMENT CLASS

The SMS Management Class to be used to allocate the data set. The Management Class is used to describe the retention and migration backup for the data set.

EXTENDED ATTRIBUTES

NO - The data set cannot have extended attributes.

OPT - Extended attributes are optional for the data set.

BWO

TYPECICS - Use to enable BWO processing for the data set in a CICS environment.

TYPEIMS - Use to enable BWO processing for IMS data sets.

NO - Use this when BWO does not apply to cluster.

ENCRYPTION INFORMATION:

KEYLABEL

(z/OS 2.3 and up) Identifies the name, up to 64 bytes, of the key label used to encrypt the data set.

ACCOUNT INFORMATION:

32 bytes of accounting information or user data.

DATE INFORMATION:

CREATION DATE

The date the data set was allocated.

EXPIRATION DATE

The date the data set is to expire.

MODIFICATION DATE

The date the data set was last updated.

MODIFICATION TIME

The time the data set was last updated. (This is Greenwich Mean Time.)

DATA RECORDS:

TOTAL RECORDS

The number of records in the prime data area.

DELETED RECORDS

The number of records deleted.

INSERTED RECORDS

The number of records inserted.

UPDATED RECORDS

The number of records updated.

RETRIEVED

The number of records retrieved from the data set since the last reorganization.

MAX RECORD NUMBER

Identifies the highest possible valid relative-record number for a relative-record data set.(RRDS Only)

Space Allocation Information (Data):

UNIT, PRIMARY, SECONDARY

Allocated area by UNIT type for data showing initial primary space and amount for secondary.

ALLOCATED TRACKS

The amount of space allocated in tracks.

USED TRACKS

The number of tracks and percent of data space used.

ALLOCATED EXTENTS

The number of extents allocated.

USED EXTENTS

The number of extents and the percent of extents used.

Space Allocation Information (Index):

UNIT, PRIMARY, SECONDARY

Allocated area by UNIT type for index showing initial primary space and amount for secondary.

ALLOCATED TRACKS

The amount of space allocated in tracks for the index.

ALLOCATED EXTENTS

The number of extents allocated for the index.

VOLUME INFORMATION:

PHYSICAL RECORD SIZE

Size of each block written in a control area.

RECORDS PER TRACK

The number of blocks per track.

TRACKS PER CA

The number of tracks that comprise 1 control area.

CURRENT ORGANIZATION INFORMATION:

NUMBER OF CA SPLITS

The number of control area splits.

NUMBER OF CI SPLITS

Specifies the number of control interval splits.

CI SIZE

The size of the control interval.

NUMBER OF CIS/CA

The number of control intervals per control area.

FREE CIS/CA

The number of free control intervals in each CA.

Percent free CIs/CA

Percentage of space free in a control interval for subsequent processing.

Percent free bytes/CI

Percentage of bytes of free space in the total amount of space allocated.

INDEX STATISTICS:

NUMBER OF LEVELS

The number of index levels.

ENTRIES PER SECTION

The number of entries per section.

FIRST SEQUENCE-SET RBA

Pointer to the start of the sequence set CI blocks in the index set.

Exception Exit

The name of a user-written exception-exit routine that receives control when an exceptional I/O error occurs for the INDEX Component.

VSAM Information—User Catalog

If the specified data set is a user catalog, the VSAM information display contains the information as shown in the the following figure.

VSAM Information - User Catalog

image2021-5-27_11-2-53.png

USER CATALOG

User catalog name as specified.

CATALOG

Catalog name.

VOLUME

Name of the device on which data is stored.

DEVICE TYPE

Type of device on which data is stored (for example: 3380, 3390, etc.).

ASSOCIATIONS

List of the user catalog’s associations (for example: Alias entries).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*