VSAM data sets

To display summary information for all open VSAM files, select the VSAM Datasets option (E) on the Files path or enter fast path F.E from any panel.

Figure 1. VSAM Summary Panel (F.E)
 ________________ ZVSAM    VTM     CICSSP31 V530./C SP22 11/23/13 15:51:03 
> PF1 Help     PF3 Back     PF4 Main Menu     PF7 Up     PF8 Down     PF11 Zoom

> A-Application Datasets   B-CICS Datasets      C-STEPLIB        D-JES Datasets
> E-VSAM Datasets          F-LSR Pools          G-DFHRPL         H-All Datasets
> I-VSAM String Waits      J-Journal Datasets   K-IMS Datasets   L-Select FIles
===============================================================================

>                             ALL OPEN VSAM FILES
 VSAM
+                              Number of files selected:   93 Skipped:    0
+      File      File       Str Wts   Str Wts      Data      Data      Data
+      ID        Status     Current     Total     Excps  CI Split  CA Split
+      --------  --------  --------  --------  --------  --------  --------
+      DFHLCD    No FCT         n/a       n/a       n/a         0         0
+      DFHGCD    No FCT         n/a       n/a       n/a       456         0
+      DFHRSD    No FCT         n/a       n/a       n/a       246         1
+      APFH120   Enabled          0         0        80         0         0
+      APFL905   Enabled          0         0      3277       117        13
+      APFM100   Enabled          0         0      5315       179        25
+      CCFM100   Enabled          0         0       182         0         0
+      CCFM200   Enabled          0         0       660         8         0
+      CCFM300   Enabled          0         0         0         0         0
+      CM827     Enabled          0         0         0         0         0
+      DMCUST    Enabled          0         0       654         0         0
+      DMDCF     Enabled          0         0         0         0         0
+      DMINV     Enabled          0         0         0         0         0
+      FCFMGMD   Enabled          0         0       634        51        17
+      FCFMPOL   Enabled          0         0        98         0         0
+      FCFMTMD   Enabled          0         0       310         0         0
+      GLFMBUD   Enabled          0         0         0         6         6
+      GLTRX1    Enabled          0         0         0         0         0
+      GMF55     Enabled          0         0         0         0         0
+      GMP11     Enabled          0         0       634        51        17
+      GMP21     Enabled          0         0         0         0         0
This panel shows a summary of all open VSAM files:
  • ddname or FCT entry name
  • Current file status if FCT-defined
  • Current number of string waits
  • Total string waits since file opened
  • EXCPs on the data component
  • Number of control interval splits in the data component
  • Number of control area splits in the data component

Frequent splits, especially CA splits, can significantly degrade the time to access the file. String waits cause tasks to wait and too many can degrade response time.

To view detailed statistics on a particular VSAM file, position the cursor anywhere on the line describing the file and press PF11 or enter the 1- to eight character file ID following the VSAM statement. For example, to view details for file APFM910, enter the following file ID: VSAM APFM910.

The VSAM File Detail panel is displayed in the following figure:

Figure 2. VSAM File Detail Panel (Accessed by Zoom)
 ________________ ZZVSAM   VTM     CICSSP31 V530./C SP22 11/23/13 15:51:03 
> PF1 Help     PF3 Back     PF4 Main Menu     PF7 Up     PF8 Down

===============================================================================

>                                 FILE DETAIL
 VSAM  APFM910
+                                General Information
+      File dataset name . . . : PROD.FINAPV.APFM910 
+      File organization . . . :     KSDS    ACB address . . . . . . : 007B5BA4
+      Open/close error code . :        0    File is NSR or LSR  . . :      NSR
+      ACB strings . . . . . . :        2    High water act. strings :        1
+      Active strings  . . . . :        0
+
+                           Data Component of KSDS Dataset
+      Data Component  . . . . : PROD.FINAPV.APFM910.DATA
+      Control area splits . . :        1    Control interval splits :       18
+      Number of EXCPs . . . . :    22684    Control interval size . :     4096
+      Number of records . . . :   476630    Number of inserts . . . :     1186
+      Number of retrieves . . :   953703    Number of updates . . . :        0
+      Number of deletes . . . :      270    Freespace percentages . :  010,025
+      Available space . . . . : 29216768    Allocated extents . . . :        4
+      Volume serial number  . :   DBCR04    Device address  . . . . :      162
+      Allocation type . . . . : Cylinder    Primary allocation amt  :       25
+      Secondary allocation amt:       17    Maximum record length . :      120
+      Number of I/O buffers . :        3
+      Writecheck used . . . . :       No    Shareoptions specified  :    (2,3)
+
+                          Index Component of KSDS Dataset
+      Index Component . . . . : PROD.FINAPV.APFM910.INDEX
+      Control area splits . . :        0    Control interval splits :        1
+      Number of EXCPs . . . . :     5037    Control interval size . :     2048
+      Number of records . . . :       54    Number of inserts . . . :        0
+      Number of retrieves . . :        0    Number of updates . . . :       22
+      Number of deletes . . . :        0    Number of index levels  :        2
+      Relative key position . :        0    Key length  . . . . . . :       48
+      Available space . . . . :    61440    Allocated extents . . . :        3
+      Volume serial number  . :   DBCR04    Device address  . . . . :      162
+      Allocation type . . . . :    Track    Primary Allocation Amt  :        2
+      Secondary Allocation Amt:        1    Maximum Record Length . :     2041
+      Number of I/O buffers . :        2
+      Writecheck used . . . . :       No    Shareoptions specified  :    (2,3)
+      Imbed or replicate  . . :  Neither
+
The VSAM file detail panel shows the following information:
  • general information such as dsname, organization, ACB information, string information, open/close error code, active strings, and whether the file is using LSR
  • data and index component information such as number and type of accesses, splits, freespace, extents, write checks, and share options
  • FCT statistics if the file is FCT-defined
  • temporary storage or transient data usage statistics if the file contains TS or TD
    Note: Depending on the file organization or whether the file uses LSR or NSR, you may receive different data on the panel.