Previous Topic: 4.4.4.6 CA MICS Space Utilization and Reporting

Next Topic: 4.4.4.6.2 CA MICS Database Estimator

4.4.4.6.1 CA MICS Database Utilization Facility

CA MICS Database Utilization Facility provides comprehensive
information on how much space is used in a CA MICS database.

The CA MICS Database Utilization Facility contains the
following reports:

   o The Invalid File Report provides a list of files that
     cannot be identified as belonging to the CA MICS
     database structure.  Invalid files can be the result of
     residual files from an incomplete database update,
     user-created files, and obsolete files.

     Invalid files will be reported in the 'Unknown' category
     of the Information Area and File summary reports.  The
     CA MICS Database Health Check Utility can be run to help
     resolve issues with identified invalid files.

   o The Libname Summary Report provides overview information
     for each timespan in the database.

   o The Information Area Summary Report shows space
     utilization for each Information Area within a timespan.
     This report is useful for determining where a database
     can be split.

   o The File Summary Report shows space utilization for each
     file in a timespan. Note that all cycles for a file are
     comprised in a single line entry.


The following subsections provide more details concerning the
Database Space Utilization Reports:

          1 - Panel Entries
          2 - Sample Output

4.4.4.6.1.1 Panel Entries

Command ===>


------------------ CA MICS Space Utilization and Reporting --------------- 1 - Database Space Utilization Report Report on Database Space Usage. 2 - Database Space Estimator Report Estimate Maximum Database Size. T - Tutorial X - Exit



Command ===>



------------------------- Database Space Utilization ----------------- Unit Database ID ===> _ Space Reporting Unit ===> L (Bytes, bLocks, Tracks, Cylinders) Report Types Summary ===> Y Information Area ===> Y Detail ===> Y Press END to continue.


. . . . . . . . . . . . . . . . . . . . . . . . . .


To generate the Database Space Utilization reports,
select option 6 from the CA MICS Administrator Utilities
menu, and then option 1 (MWF 5;4;6;1).

Fill in values, as described below, and press END or use the
PF3 key to submit the inquiry.

Unit Database ID        Defaults to the primary database ID.
                        Specify the one-character identifier
                        assigned to the unit that you want to
                        analyze.  A list of valid values for
                        your site is available by placing a
                        question mark (?) in the field.

Space Reporting Unit    Defaults to L (bLocks).  This report
                        can display space in either Bytes
                        (B), bLocks (L), Tracks (T), or
                        Cylinders (C).

Report Types
------------
Summary                Defaults to Y (Yes).  Specify Y (Yes)
                        to produce the Libname Summary
                        Report.

Information Area       Defaults to Y (Yes).  Specify Y (Yes)
                        to produce the Information Area
                        Summary Report.

Detail                 Defaults to Y (Yes).  Specify Y (Yes)
                        to produce the File Summary Report.

4.4.4.6.1.2 Sample Output

A sample report listing for the CA MICS Database Utilization
Facility follows:

 
The Invalid File report lists files within the CA MICS 
database that cannot be identified as belonging to
a CA MICS component.

CA MICS Space Utilization and Reporting 14:41 Friday, January 27, yyyy 1 Database Space Utilization Invalid Files The following files are considered invalid and may skew results. It is recommended that the CA MICS Database Health Check Utility be run. TimeSpan DDName Member ---------- ---------- ---------- MONTHS PMONTHS BAT_TPM0 MONTHS PMONTHS BATATPM0 MONTHS PMONTHS BATRENM0 MONTHS PMONTHS BATSPLM0 MONTHS PMONTHS IMS_IAM0 MONTHS PMONTHS IMS_ISM0 DETAIL PDETAIL BATJOBQ0 DETAIL PDETAIL BATJOBYY DETAIL PDETAIL RMFCKPTX DETAIL PDETAIL XXXJIB01 DETAIL PDETAIL XXXJOBYY DETAIL PDETAIL XXXJOB01 DETAIL PDETAIL XXXYYY DETAIL PDETAIL XXXYYY00 DETAIL PDETAIL XXXYYY01


Column Descriptions
-------------------

Timespan: The CA MICS timespan where the invalid file
          resides.

DDname: The DDname of the invalid file.

Member: The SAS member name of the invalid file.


The Libname Summary report lists space utilizations for each physical data set of the CA MICS database.

CA MICS Space Utilization and Reporting 14:41 Friday, January 27, yyyy 2 Database Space Utilization Libname Summary Space Reporting Unit is Blocks Used Allocated Free Free Libname Data Set Name Block Size Members Space Space Space Percent -------- -------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- PDETAIL MDI.U3PUN.DETAIL 27,648 520 10,007 10,560 574 5.44% PDAYS MDI.U3PUN.DAYS 27,648 628 3,130 3,130 13 0.42% PDAYS1 MDI.U3PUN.DAYS1 27,648 3 14 12,171 12,168 99.98% PWEEKS MDI.U3PUN.WEEKS 27,648 87 543 920 382 41.52% PMONTHS MDI.U3PUN.MONTHS 27,648 207 998 1,176 185 15.73% PYEARS MDI.U3PUN.YEARS 27,648 1 4 6 5 83.33% ---------- ---------- ---------- ---------- 14,696 27,963 13,327 47.66%


Column Descriptions
-------------------

 Libname: The SAS libname of the timespan.

 Data Set name: The z/OS data set name of the timespan.

 Block size: The physical block size of the data set.

 Members: Total members in the SAS data sets. This includes
   valid and invalid (as listed in the Invalid Files report)
   file entries.

 Used Space: Space currently used in the timespan.

 Allocated Space: Total space currently allocated to the
    timespan. This is computed as Used and Free space.

 Free Space: The space available in the timespan.

 Free Percent: Percentage of allocated free space in the
    timespan.

 The Information Area Summary report shows space utilization for each Information Area within the timespan.

CA MICS Space Utilization and Reporting 14:41 Friday, January 27, yyyy 3 Database Space Utilization Information Area Summary Space Reporting Unit is Blocks Timespan: DETAIL; Libname: PDETAIL; Data set Name: MDI.U3PUN.DETAIL Device Type: 3390; Volume Count: 1; Block Size: 27,648 Allocated Blocks: 10,560; Used Blocks: 10,007; % Free: 5.24% Used Used Avg Space Information Area Members Space Percent per File ---------------------------------------------- ---------- ---------- ---------- ---------- (???) Unknown 7 12 0.11% 2 (ACT) Accounting Component 6 10 0.09% 2 (ADM) Administrative Activity Information Area 2 2 0.02% 1 (AST) ASTEX 4 7 0.07% 2 (AUM) MeasureWare Information Area 18 79 0.75% 4 (BAT) Batch Activity Information Area 50 1,480 14.02% 30 (CIC) CICS Activity Information Area 11 65 0.62% 6 (DBP) DB2 Buffer Pool Area 2 3 0.03% 2 (DB2) DB2 Information Area 15 78 0.74% 5 (DEA) VAX/VMS Accounting Information Area 6 14 0.13% 2 (DEM) VAX/VMS Monitor Information Area 6 145 1.37% 24 (DES) VAX/VMS System Usage Information Area 5 39 0.37% 8 (HAR) Hardware Utilization 22 360 3.41% 16 (HFS) USS File System Information Area 3 9 0.09% 3 (HSB) DFHSM Inventory Backup Information Area 4 2,777 26.30% 694 (HSM) DFHSM Inventory Primary Information Area 10 835 7.91% 84 (IDM) IDMS Information Area 5 15 0.14% 3 (IMS) IMS Activity Information Area 7 46 0.44% 7 (MQA) MQS Accounting Information Area 4 16 0.15% 4 (MQS) MQS Performance Information Area 14 27 0.26% 2 (NVS) Netview Session Information Area 9 16 0.15% 2 (OPS) Operations Information Area 3 6 0.06% 2 (PWR) VSE/POWER Information Area 19 44 0.42% 2 (SCP) MVS System Control Program 36 625 5.92% 17 (SNT) Network Information Area 33 66 0.63% 2 (SRL) System Reliability Information 52 452 4.28% 9 (TCP) TCP/IP Information Area 15 36 0.34% 2 (TDM) TANDEM Information Area 23 165 1.56% 7 (TSO) TSO Information Area 23 333 3.15% 14 (VCA) VTOC/Catalog Activity Information Area 7 23 0.22% 3 (VMC) Accounting and Exception Information Are 12 23 0.22% 2 (VMX) VM/XA and VM/ESA System Information Area 37 1,973 18.68% 53 (WEB) WEB Information Area 28 61 0.58% 2 (WLG) WEB Log Files Information Area 9 114 1.08% 13 (WLM) MVS Workload Management 13 30 0.28% 2 ---------- ---------- ---------- ---------- 520 9,986 94.56% 19


Heading Descriptions
------- -------------

 Timespan: The CA MICS database timespan.

 Libname: The DDname used to reference the timespan data set.

 Data Set Name: The fully qualified data set name of the
  timespan.

 Device Type: The device type of the data set. Note that the
  device type is the same for all volumes of a multi-volume
  data set.

 Volume Count: Number of volumes of the timespan data set.

 Block Size: The z/OS block size of the data set.

 % Free: Percentage of free space in the timespan data set.

 For each of the following items, units can be Bytes, Blocks,
  Tracks, or Cylinders depending upon options selected when
  the report is run.

 Allocated units: The amount of space currently allocated to
  timespan data set.

 Used units: The amount of space currently used in the
  timespan data set.

Column Descriptions
-------------------

 Information Area: Name the CA MICS Information Area with the
    timespan.

 Members: Total members in this Information Area. This
    includes valid and invalid (as listed in the Invalid
    Files report) file entries.

 Used Space: Space currently used in the Information Area.

 Used Percent: Percentage of allocated space used by the
    Information Area within the timespan.

 Avg. Space per File: The average space used for each file
    within the timespan.

The File Summary report shows space utilization for each CA MICS File within the timespan.
 

CA MICS Space Utilization and Reporting 14:41 Friday, January 27, yyyy 18 Database Space Utilization File Summary Space Reporting Unit is Blocks Timespan: DETAIL; Libname: PDETAIL; Data set Name: MDI.U3PUN.DETAIL Device Type: 3390; Volume Count: 1; Block Size: 27,648 Allocated Blocks: 10,560; Used Blocks: 10,007; % Free: 5.24% Information Area Used Used Avg. Space File Name Cycles Space Percent Per Cycle ------------------------------------------------- ---------- ---------- ---------- ---------- (WLG) WEB Log Files Information Area (CFG) WLE CONFIGURATION FILE 1 2 0.02% 2 (ERL) HTTP ERROR MESSAGES LOG FILE 4 8 0.08% 2 (SAL) HTTP ACCESS LOG FILE 4 104 0.98% 26 ---------------------------------------------- ---------- ---------- ---------- ---------- (WLG) WEB Log Files Information Area 9 114 0.98% 13 (WLM) MVS Workload Management (_EA) REPORT CLASS 1 2 0.02% 2 (_EC) REPORT CLASS RESOURCE CONSUMPTION 1 4 0.04% 4 (_ED) REPORT CLASS GENERAL EXEC DELAY 1 2 0.02% 2 (_EM) REPORT CLASS RESPONSE TIME 1 2 0.02% 2 (_EW) REPORT CLASS SUBSYSTEM DELAY STATES 1 2 0.02% 2 (RGP) RESOURCE GROUP 1 2 0.02% 2 (SDE) SERVICE DEFINITION 1 2 0.02% 2 (SDS) SERVICE CLASS SUBSYSTEM DELAY STATES 1 2 0.02% 2 (SEA) SERVICE CLASS 1 2 0.02% 2 (SEC) SERVICE CLASS RESOURCE CONSUMPTION 1 4 0.04% 4 (SED) SERVICE CLASS GENERAL EXEC DELAY 1 2 0.02% 2 (SEM) SERVICE CLASS RESPONSE TIME 1 2 0.02% 2 (SVC) SERVICE CLIENT 1 2 0.02% 2 ---------------------------------------------- ---------- ---------- ---------- ---------- (WLM) MVS Workload Management 13 30 0.02% 2 ============================================== ========== ========== ========== ========== 3,592 9,986 94.56% 3


Heading Descriptions
------- -------------

 Timespan: The CA MICS database timespan.

 Libname: The DDname used to reference the timespan data set.

 Data Set Name: The fully qualified data set name of the
 timespan.

 Device Type: The device type of the data set. Note that the
    device type is the same for all volumes of a multi-volume
    data set.

 Volume Count: Number of volumes of the timespan data set.

 Block Size: The z/OS block size of the data set.

 % Free: Percentage of free space in the timespan data set.

 For each of the following items, units can be Bytes, Blocks,
    Tracks, or Cylinders depending upon options selected when
    the report is run.

 Allocated units: The amount of space currently allocated to
    timespan data set.

 Used units: The amount of space currently used in the
    timespan data set.

Column Descriptions
-------------------

 Information Area: Name of the CA MICS Information Area
    within the timespan.

 File Name: Name of the CA MICS file within the timespan.

 Cycles: Total iterations (cycles) of this file within the
    timespan.

 Used Space: Space currently used by the file.  Note that the
    space used at the Libname summarization level may not
    equal the allocated space in the timespan.  This
    difference is attributed to internal SAS usage.

 Used Percent: Percentage of allocated space used by the File
    within the timespan.

 Avg. Space per Cycle: The average space used for each cycle
    of the CA MICS file within the timespan.