Previous Topic: 15.3.4 Data Value Exception Detail ReportNext Topic: 15.3.6 Cluster Index Analysis Graph


15.3.5 Sparse Cluster Population Report


The Sparse Cluster Population report is a listing of all
clusters that have been defined as "sparse".  Sparse clusters
are by definition those clusters having less than 0.5% of the
population of the sample.  Generally, these clusters contain
outliers, but may also contain normal cases.

The application will determine the key sequence structure of
the input file, modify the key structure to remove date and
time key values, except for the End Timestamp, and present
the listing using the modified key sequence. You can
optionally exclude the CA MICS account codes from the reports
by specifying a value of "NO" on the REPORT USING ACCOUNT
FIELDS option on the Execution Options panel.  This report
can be used to verify that the sparse clusters are truly
exceptional cases, not merely unusual cases.

Note that each outlying clustering data value is flagged with
an "*".  This permits you to not only identify outliers in
the data, but to understand which elements contain abnormal
data values.

Sparse Cluster Population Report For: Monday, June 23, 2003 Listing of Observations Within Cluster Cluster System Job Job Job TCB CPU Number Identifier DIVISION DEPARTMENT RESERVED Group Identification End Time Stamp Time DASD EXCPS ------------------------------------------------------------------------------------------------------------------- 2 XAL1 GIS 00045 ******** 5 MPGLAUDT 07NOV02:11:39:02.05 0:02:06.60* 7,340 XAL1 GIS 02046 ******** 0 T1PR2NEW 13NOV02:17:37:26.57 0:02:09.01* 108 3 XAL1 GIS 00045 ******** 0 A02ICST3 12NOV02:11:11:59.69 0:01:31.50* 9,099 XAL1 GIS 00045 ******** 0 MPIRSADT 08NOV02:17:22:57.44 0:01:37.44* 5,808 XAL1 GIS 00045 ******** 0 TOPCDEV2 08NOV02:11:42:22.55 0:01:40.63* 7,267 XAL1 GIS 00045 ******** 0 TOPCDEV2 08NOV02:13:41:37.00 0:01:38.81* 7,179 XAL1 GIS 00045 ******** 0 TOPCDEV2 08NOV02:13:49:04.83 0:01:33.66* 7,094 XAL1 UNK UNK ******** 0 CACMPQA 14NOV02:10:09:47.07 0:01:41.14* 8,383 4 XAL1 GIS 00045 ******** 5 MPMINAS 14NOV02:16:45:15.65 0:00:35.54 70,439* XAL1 GIS 00045 ******** 5 MPMIPACE 14NOV02:10:30:56.85 0:00:40.26 80,646* 5 XAL1 DEV 01076 ******** 7 FEESE01Y 07NOV02:15:34:08.89 0:00:59.88 79,414* XAL1 GIS 02045 ******** 0 BEHMAMDB 11NOV02:15:08:03.50 0:01:18.45* 79,294* 6 XAL1 DEV 01062 ******** 5 MCCTI03H 07NOV02:14:32:14.63 0:00:34.83 23,429 XAL1 DEV 01062 ******** 7 DIXPA02M 15NOV02:15:35:10.77 0:00:42.85 26,409 XAL1 GIS 02045 ******** 0 BEHMAMDB 11NOV02:15:31:53.21 0:00:27.57 27,384 XAL1 GIS 02045 ******** 0 BEHMAMEN 11NOV02:14:52:19.61 0:00:24.20 23,585 7 XAL1 GIS 00045 ******** 0 TCWFAST$ 11NOV02:11:50:11.47 0:00:19.64 156,990* XAL1 GIS 00045 ******** 5 STARLOAD 13NOV02:15:58:32.57 0:00:28.49 148,507* XAL1 GIS 00045 ******** 5 STARLOAD 13NOV02:16:26:38.42 0:00:26.74 148,503* 8 XAL1 GIS 00045 ******** 0 WKBKVM85 11NOV02:12:50:10.33 0:25:27.51* 220,572* XAL1 GIS 02046 ******** 7 MELRI01B 07NOV02:18:12:06.64 0:25:34.91* 233,415* 9 XAL1 DEV 01062 ******** 0 BEAMA05M 07NOV02:13:30:34.99 0:00:06.64 90,943* XAL1 DEV 01076 ******** 0 JERMI01M 11NOV02:17:49:34.96 0:00:04.81 101,604* XAL1 DEV 01076 ******** 0 JERMI01M 11NOV02:17:53:40.22 0:00:04.31 89,564* XAL1 DEV 01266 ******** 7 HENRO04Q 15NOV02:11:00:52.65 0:00:05.13 95,660* XAL1 GIS 00045 ******** 0 TCWFAST$ 11NOV02:11:23:34.38 0:00:17.46 99,448* 12 XAL1 DEV 01062 ******** 5 JONCA04B 12NOV02:15:55:19.91 0:01:10.59* 2,702 XAL1 DEV 01062 ******** 5 JONCA04B 12NOV02:16:10:50.76 0:01:14.38* 2,661 XAL1 DEV 01062 ******** 7 DIXPA02D 15NOV02:10:46:48.50 0:01:17.18* 15,968 XAL1 DEV 01062 ******** 7 DIXPA02D 15NOV02:13:30:36.48 0:01:14.50* 15,781 XAL1 GIS 00045 ******** 5 VRPDIV 08NOV02:17:27:14.42 0:01:23.85* 9,966 XAL1 GIS 02046 ******** 0 FAIRSCAN 07NOV02:11:39:42.42 0:01:14.27* 13,231 XAL1 GIS 02046 ******** 0 FAIRSCAN 08NOV02:14:40:26.10 0:01:13.71* 13,234 XAL1 UNK UNK ******** 0 DBTNGFR2 14NOV02:09:26:28.85 0:01:12.29* 5,774 XAL1 UNK UNK ******** 0 T1CAPS2 11NOV02:09:07:14.75 0:01:21.77* 15,217 13 XAL1 DEV 01060 ******** 5 CYGIPCS 12NOV02:10:46:57.98 0:01:41.88* 178,301* XAL1 SPT 04733 ******** 5 BEEST02U 08NOV02:11:58:26.55 0:02:11.93* 173,919* Note: '*' Indicates that the data value is an outlier


 Figure 15-4A.  Sparse Cluster Population report

The Sparse Cluster Population report is dynamically built,
and does not have a fixed format.  The first 'n' columns of
the report contain the sequence fields of the CA MICS file
used for analysis.  These fields are documented in the
CA MICS Data Dictionary.  The remaining elements are those
specified by the analyst on the Workload Characterization
panel as clustering elements.  If these are CA MICS data
elements, which is the typical case, then their definitions
and usage data can be located in the CA MICS Data Dictionary
as well.