Previous Topic: SMS Class Usage / Detail (STGELE)

Next Topic: SMS Class Usage / Distribution of Allocated Space (STGELE)

SMS Class Usage / Descriptive Statistics (STGELE)


Source:    VCADAA file at the DETAIL timespan
           VCA_VS file at the DETAIL timespan

Function:  Provide simple descriptive statistics for both Age
           and Allocated Space (data set size) for each
           cluster.  This helps determine the general size
           and shape of individual clusters, and can
           additionally help identify the presence of
           outliers.

Features:  This report consists of what is commonly called a
           "five number summary" of both Age and Data Set
           Size as opposed to the often used mean and
           standard deviation measures.  This approach was
           chosen because it is less affected by non-normal
           statistical distributions of the input data values
           and is typically used in engineering applications
           for that very reason.  Aside from the descriptive
           statistics, the total number of data sets and
           allocated space is given to quantify the affect of
           the cluster with respect to the total population,
           and a set of weighted allocation measurements is
           provided as an alternative metric.

SMS        N/A
Issues:

COLUMN DESCRIPTIONS

    Cluster
           The number of the cluster, from one to n, assigned
           by the clustering application.

    Number of Datasets
           The number of data sets within the cluster.

    Age (in days) Statistical Summary
           The Age is the time in days since the last
           reference of the data set being processed.  It is
           computed by subtracting the last reference date
           from the current date.  If the result is missing,
           then the same calculation is attempted using the
           data set creation date.  Observations that still
           have missing values after both attempts are
           deleted.  The Age values are displayed as Minimum,
           1st Quartile (25th pctl.), median, 3rd Quartile
           (75th pctl.) and Maximum.

    Allocated Space (size) in Megabytes
           This measurement is derived from element DAAALLSP
           and presented as Minimum, 1st Quartile (25th
           pctl.), median, 3rd Quartile (75th pctl.),
           Maximum, and total values.  This total size
           depicts how much allocated space is represented by
           the cluster.

    Weighted Allocated Space
           The allocated space of each data set is first
           weighted by its calculated Age and then
           accumulated together within each cluster.  The
           accumulated measurements for each cluster are then
           presented both as an Average (mean) and Total
           values.  This is done to quantify the effect of
           the size and ages of all data sets taken together
           and provides a simple method to understand where
           the "pain" is.  The expression "pain" refers to
           the potential impact one set of data sets might
           have on the installation as a whole.  For example,
           a cluster representing a group of poorly managed
           data sets might consist of many small data sets
           that are fairly new, and therefore cause minimal
           "pain."  Conversely, a group of rather large data
           sets that are old can easily result in a large
           impact on the installation.

SMS CLASS USAGE (STGELE) 4 CA MICS StorageMate AFTER COMPLEX SAS V8.2 Descriptive Statistics for Age & Dataset Size Report Date: 06/25/2004 ------------------------------------------------------------------------------------------------------------------------------------ | | | Age (Days) | Allocated Space (MB) | Wgtd. Alloc. Space | | | |---------------------------------------+-------------------------------------------------| (MB) | | | No. of | | 1st | | 3rd | | | 1st | | 3rd | | |----------------------| | |Datasets|Minimum| Qrtl. |Median | Qrtl. |Maximum|Minimum| Qrtl |Median | Qrtl. |Maximum| Total | Average | Total | |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |Cluster | | | | | | | | | | | | | | | |--------| | | | | | | | | | | | | | | |1 | 29,480| 20| 23| 35| 97| 372| 0| 0| 1| 2| 16| 48,349| 104| 3,074,114| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |2 | 9,258| 289| 401| 484| 617| 865| 0| 0| 0| 1| 17| 7,283| 412| 3,813,085| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |3 | 3,150| 863| 997| 1,172| 1,380| 1,903| 0| 0| 0| 1| 22| 3,576| 1,346| 4,241,299| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |4 | 1,656| 20| 22| 31| 107| 2,052| 16| 20| 27| 41| 61| 50,573| 3,945| 6,532,345| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |5 | 500| 21| 23| 31| 90| 2,030| 62| 76| 85| 108| 156| 46,633| 10,554| 5,276,859| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |6 | 698| 1,910| 2,145| 2,486| 2,796| 6,935| 0| 0| 0| 1| 28| 534| 1,978| 1,380,403| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |7 | 205| 21| 22| 31| 56| 2,380| 160| 172| 212| 255| 325| 45,483| 20,271| 4,155,606| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |8 | 104| 21| 21| 28| 37| 967| 330| 357| 425| 486| 640| 44,878| 36,830| 3,830,367| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |9 | 4| 21| 22| 26| 48| 66| 2,628| 2,716| 2,963| 3,168| 3,216| 11,770| 99,406| 397,622| |--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+---------+---------+------------| |10 | 29| 21| 22| 30| 253| 1,127| 680| 765| 827| 907| 1,700| 25,714| 214,216| 6,212,277| ------------------------------------------------------------------------------------------------------------------------------------



 Figure 4-59A  SMS Class Usage / Descriptive Statistics