Create Reports Using the CA Easytrieve Reporting Service › Sample Output from Canned Reports › MVS Reports › VSAM Data Set Activity

VSAM Data Set Activity

This report shows the VSAM data set activity. This report requires SMF 64 records. In addition to standard parameters, the following keyword parameters are supported:

ORDERBY

The variables used to sort for the final report, which can be any combination of DSNAME, ACTIVITY, RETRIEVE, INSERTS, DELETES, UPDATES, EXCPS, CISPLITS, and CASPLITS.

Default: EXCP D

TOP

Restricts the number of lines of output for each time interval.

Default: 99999999

DSNAME

Filters by data set name.

Default: * (an asterisk), which selects all data sets.

To create the VSAM Data Set Activity report, use this VSAMSTAT code:

LIST OFF
%VSAMSTAT TOP 30

The following is a sample VSAM Data Set Activity report:

2008/05/20 08:09   CA SYSVIEW VSAM Dataset Activity                                                            PAGE      1
From:           2008/03/25 06:23  Each:     DAY
To:             2008/03/29 09:57  Shift:    00:00 24:00
Interval Start: 2008/03/25 00:00  Order by: ACTIVITY D

                                                DSN        DSN        DSN        DSN        DSN        VSAM      VSAM      VSAM  
                Dataset Name                  ACTIVITY  RETRIEVES   INSERTS    DELETES    UPDATES     EXCPS    CI SPLITS CA SPLITS
-------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- --------  --------
SYSPROG.XE44.RMF4.DATA                        1,687,650    739,650    800,050          0    147,950  1,174,160        0         0
SYS1.MAN1.DATA                                  219,459    219,459          0          0          0     60,120        0         0
SYS1.MAN2.DATA                                   85,426     85,426          0          0          0     13,787        0         0
BST.P40.STG2.MCF.DATA                               148        148          0          0          0         24        0         0
YUNED01.TPX50.ADMIN1.DATA                           119        119          0          0          0         10        0         0
BST.P40.STG2.MCF                                     87         87          0          0          0         62        0         0
BST.DEVEL.ELMCATL                                    14         14          0          0          0         48        0         0
BST.DEVEL.ELMCATL.DATA                                9          9          0          0          0         15        0         0
BST.P40.STG1.MCF.DATA                                 6          6          0          0          0          4        0         0
YUNED01.TPX50.ADMIN2.DATA                             5          5          0          0          0          1        0         0
BST.P40.STG1.MCF                                      3          3          0          0          0         19        0         0
BST.DEVEL.ELMCATL.INDEX                               0          0          0          0          0         43        0         0
BST.P40.STG1.MCF.INDEX                                0          0          0          0          0         39        0         0
BST.P40.STG2.MCF.INDEX                                0          0          0          0          0         67        0         0
RTM.QA.SYSV771.CAPINDEX.XE44.DATA                     0          0          0          0          0         12        0         0
RTM.QA.SYSV771.CAPINDEX.XE44.INDEX                    0          0          0          0          0         12        0         0
SYSVIEW.DEV.BASE.CAPINDEX.XE44.DATA                   0          0          0          0          0          4        0         0
SYSVIEW.MILDO03.V770.CAPINDEX.DATA                    0          0          0          0          0         12        0         0
SYSVIEW.MILDO03.V770.CAPINDEX.INDEX                   0          0          0          0          0         12        0         0
SYSVIEW.DEV.BASE.CAPINDEX.XE44.INDEX                  0          0          0          0          0          6        0         0
YUNED01.TPX50.ADMIN1.IX                               0          0          0          0          0         16        0         0
YUNED01.TPX50.ADMIN2.IX                               0          0          0          0          0          2        0         0