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
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |