Previous Topic: VSAM Wasted Space / Summary (STGECF)

Next Topic: VSAM Wasted Space / Analysis (STGECF)

VSAM Wasted Space / Detail (STGECF)


Source:    VCA_VS file at the DETAIL timespan

Function:  This facility helps to identify departments or
           groups that are wasting DASD storage space due to
           poor VSAM allocation practices.  These problems
           can be caused either by allocating more space than
           is necessary, or by using other VSAM options
           incorrectly.  The Storage Administrator can
           perform up to four different types of space
           analysis with this facility, and can report the
           results on one combined report or on separate
           reports.  Correction of the problems detected by
           this facility may recover a large amount of
           storage space with a small amount of effort.

           The term "wasted space" in these reports refers to
           any space that is allocated (so that it cannot be
           used by others), and yet is not currently being
           used to contain data.  In some cases, such as the
           overallocation of a data set to accommodate future
           growth, this is normal.  These reports also focus
           strictly on wasted space, and do not consider
           other factors such as performance.  Before making
           any changes to the VSAM data sets appearing on the
           reports from this facility, it is strongly
           suggested that other performance and application
           factors be considered.

Features:  Summary reports should be run regularly to monitor
           wasted space, with more detailed reporting
           occurring when problems are detected.  A wide
           variety of filtering and reporting options allow
           many views of the same data to be obtained.

           Summary reports can be produced as tabular
           reports, printer graphics reports or color
           graphics reports, and can be summarized based on
           the data set name, the CA MICS accounting codes,
           or using a Data Set Group table.  Detail reports
           may then be generated to isolate problems to the
           data set level.  If the detail report still does
           not provide enough information, up to four
           different analysis reports can be run.

SMS
Issues:    Users planning for SMS could identify those groups
           with the worst space usage values, as they may be
           the best candidates for the immediate benefits of
           SMS.  As groups migrate to SMS control, regular
           use of this report would verify that the expected
           space savings from SMS are being realized.

COLUMN DESCRIPTIONS

    SYSID
           The System Identifier to which this data applies.

    Data Set Name
           Indicates the name of the VSAM data set
           represented by the statistics on this line of the
           report.  For VSAM clusters, this line may identify
           the individual cluster component (such as Data or
           Index), rather than the cluster name.

    Data Set Size in MB
           Represents the total amount of space being
           allocated by this data set, expressed in
           megabytes.

    TOTAL Waste in MB
           Represents the total amount of space currently
           being wasted this data set.  Depending on your
           report options, this may represent the sum of up
           to four different wasted space calculations.

    % Alloc Space Waste
           The percentage of the space allocated by this data
           sets that is being wasted.  This is calculated
           using the two previous columns.

    Record/CI Waste in MB
           Represents the wasted space in this data set
           caused by record sizes that are not efficient for
           the control interval size being used.  This value
           is expressed in megabytes.

    Imbed Waste in MB
           Represents the wasted space in this data set
           caused by the use of the IMBED attribute.  This
           value is expressed in megabytes.

    Block/Trk Waste in MB
           Represents the wasted space in this data set
           caused by the size of the physical blocks being
           written on each track.  This value is expressed in
           megabytes.

    OverAlloc Waste in MB
           Represents the wasted space in this data set
           caused by allocating more space than is necessary
           to contain the data.  This value is expressed in
           megabytes.

VSAM WASTED SPACE (STGECF) CA MICS StorageMate - DETAIL ABC CORPORATION ----------------------------------------------------------- SYSID=IMS8 ------------------------------------------------------------ Data Set Name Data Set TOTAL % Alloc | Record/CI Imbed Block/Trk OverAlloc Size in Waste Space | Waste Waste Waste Waste MB in MB Wasted | in MB in MB in MB in MB COS.PROD.DB5.SDDS.DATA 1309 284 22 | 26 70 171 18 SYS9.FIN.TEST.DATA 427 228 53 | 1 0 10 217 COS.PROD.DB2.SDDS.DATA 877 183 21 | 18 47 116 3 SLSTST.CD1TRB.DATA 672 148 22 | 6 0 80 62 TEST.VS24RS1.LOCAL.DATA 170 147 87 | 0 0 0 147 COS.PROD.DB0.SDDS.DATA 409 130 32 | 6 18 45 61 SARAMEGA.DSNDBD.DSN2SPS.TEST 150 129 86 | 0 0 0 128 SYS9.PAY.TEST.DATA 214 121 57 | 1 0 8 112 DB2DSNP.DSNDBD.TESTINIT.ONE 133 115 87 | 0 0 0 115 INFOTST1.VSAM.DATA 332 103 31 | 31 0 39 33 COS.TEST.CONVERT.SDDS.DATA 238 85 36 | 4 10 24 47 COS.PROD.DB0.SDIDS.DATA 119 84 71 | 0 2 3 79 SYS5.TST33.BANK.DATA 102 78 76 | 0 0 2 76 TEST.T91C3420.VDD86261.DETAIL 76 66 86 | 0 0 0 66 SYS6.DSNDBD.RELOAD.DATA 340 63 18 | 0 0 42 21 -------------------------------------------- -------- -------- -------- -------- -------- -------- SYSID 5567 1965 93 146 540 1186 ======== ======== ======== ======== ======== ======== 5567 1965 93 146 540 1186 N= 15


 Figure 4-85.  VSAM Wasted Space / Detail