Previous Topic: Volume Problems (STGECA)

Next Topic: VSAM Attributes / Chart (STGEFC)

VSAM Attributes / Summary (STGEFC)


Source:    VCA_VS file at the DETAIL timespan

Function:  Allows you to identify common patterns of data set
           attributes within your VSAM data sets.  This is
           useful in identifying data sets with similar
           attributes that may have similar processing
           requirements.

           This report also helps to identify groups of data
           sets that have been allocated with attributes that
           may cause performance problems or poor space
           utilization.

Features:  You can monitor the use of different attributes by
           your users, identifying those that could result in
           performance or space problems.

           You can also choose to drop those groups that only
           represent a small percentage of your data sets
           from the report.

           After running this summary report, three
           additional reports that expand on the information
           provided in the summary can be requested.

           Generation of the summary report is automatic.

SMS
Issues:    SMS allows similar data sets to be managed under
           one data class; this report helps users identify
           and define those classes.

           You can determine the most common groups of data
           sets, thus allowing data sets in those groups to
           be automated quickly.

           Minimum, maximum, and average space allocation is
           also computed and reported for each group, as SMS
           often allows default space values to be assigned
           based on the attributes of a data set.

COLUMN DESCRIPTIONS

    Report Group
           Represents a group of data sets that have
           identical attributes, as defined by the columns
           'VSAM Org.  Type' through 'Shr Opt Sys' on each
           report line.  Report Group is important, as it is
           used in all other VSAM Attributes reports to refer
           to this common group of data sets.  The number of
           report groups is determined by the characteristics
           of the data analyzed, as well as by the percentage
           cutoff values entered on the report option screen.

    # of Data Sets
           The number of data sets within the data analyzed
           that contained attributes identical to those
           defined by this group.

    % of Data Sets
           The percentage of data sets within the data
           analyzed that were assigned to this report group.
           Note that any data sets excluded by filtering
           values on the report option panel are not included
           when calculating this percentage.

    VSAM Org.  Type
           Defines the VSAM organization type of the data
           sets in this group.  One of the following values
           should be present:

           KS - Key Sequence Data Set
           ES - Entry Sequence Data Set
           RR - Relative Record Data Set
           LS - Linear Data Set

           Note that all the data sets assigned to this
           report group have the same VSAM organization
           listed under this column.

    C. I. Size
           Note that all the data sets assigned to this
           report group have the same control interval size
           listed under this column.

    LRECL
           The maximum length of each logical record in this
           data set.  Note that all the data sets assigned to
           this report group have the same logical record
           length listed under this column.

    Imbed
           Note that all the data sets assigned to this
           report group have the same imbed attribute listed
           under this column.

    Replicate
           Contains a value of 'Y' if the replication
           attribute was specified for this data set, and a
           value of 'N' if it was not.  If this column is
           blank, the replication attribute is not valid for
           this type of data set.  Note that all the data
           sets assigned to this report group have the same
           replicate attribute listed under this column.

    Rel.  Key Pos.
           The relative position of the first byte of the key
           within the logical record for ISAM files.  Note
           that all the data sets assigned to this report
           group have the same relative key position listed
           under this column.

    Key Length
           The length of the key associated with each data
           block in a keyed data set.  Note that all the data
           sets assigned to this report group have the same
           key length listed under this column.

    % Free C. I.
           Note that all the data sets assigned to this
           report group have the same free control interval
           percentage value listed under this column.

    % Free C. A.
           Note that all the data sets assigned to this
           report group have the same free control area
           percentage value listed under this column.

    Shr Opt Reg
           The cross-region share options for the data sets
           in this group.  This is derived from the first
           byte of the DAASHROP element.  Note that all the
           data sets assigned to this report group have the
           same cross-region share option listed under this
           column.

    Shr Opt Sys
           The cross-system share options for the data sets
           in this group.  This is derived from the second
           byte of the DAASHROP element.  Note that all the
           data sets assigned to this report group have the
           same cross-system share option listed under this
           column.

    Avg Size (KB)
           The average size, expressed in thousands of bytes
           (kilobytes), of all data sets in this reporting
           group.  This is calculated by taking the total
           amount of tracks allocated by all data sets in
           this group, and dividing it by the number of data
           sets.  This value may be useful when trying to set
           a default amount of space that could be assigned
           to the data sets in this group.

    Min Size (KB)
           The smallest amount of space allocated, expressed
           in thousands of bytes (kilobytes), detected for
           all of the data sets in this reporting group.  A
           value of zero indicates that at least one data set
           in the group is allocated with zero extents and
           is, therefore, using no space for that data set.
           This value may be useful when trying to set a
           default amount of space that could be assigned to
           the data sets in this group.

    Max Size (KB)
           The largest amount of space allocated, expressed
           in thousands of bytes (kilobytes), detected for
           all of the data sets in this reporting group.
           This value may be useful when trying to set a
           default amount of space that could be assigned to
           the data sets in this group.

VSAM ATTRIBUTES (STGEFC) 1 CA MICS StorageMate - SUMMARY ABC CORPORATION Report # of % of VSAM C.I. LRECL Imbed Repli- Rel. Key % % Shr Shr Avg Min Max Group Data Data Org. Size cate Key Length Free Free Opt Opt Size Size Size Sets Sets Type Pos. C.I. C.A. Reg Sys (KB) (KB) (KB) 1 61 7.6 KS 512 0 N N 0 4 0 0 2 3 52 47 57 2 61 7.6 KS 4096 7290 N N 0 4 0 0 2 3 170 47 1709 3 39 4.9 ES 4096 0 0 0 0 0 3 4 1107 142 1700 4 36 4.5 KS 4096 0 N N 0 76 0 0 2 3 165 47 963 5 33 4.1 KS 1536 0 N N 0 23 0 0 2 3 4033 712 8500 6 32 4.0 KS 4096 0 N N 8 4 0 0 2 3 137 47 963 7 26 3.2 KS 512 0 N N 9 45 0 0 3 4 273 47 1133 8 20 2.5 KS 2048 0 N N 0 54 0 0 2 3 555 47 5553 9 18 2.2 KS 1024 0 N Y 9 45 0 0 3 4 660 47 1424


 Figure 4-79.  VSAM Attributes / Summary