CA MICS Q&R New and Updated ‘Out of the Box’ Reports

CA MICS Q&R › CA MICS Q&R New and Updated ‘Out of the Box’ Reports

CA MICS Q&R New and Updated ‘Out of the Box’ Reports

The CA MICS Query Library has been enhanced to include seven new reports for IMS and VCA components. The Query library includes over 50 Q&R Workstation sample queries that process and report on data from the DB2, CICS, IDMS, IMS, MQS, RMF, SMF, TAPE, VCA, VM, and WEB components. The queries are designed to provide out-of-the-box value for CA MICS users. The queries generate graphics to show resource utilization, workload activity, processor configuration, and metrics that are important to monitor at modern data centers.

The following queries have been updated in CA MICS 12.9.

RMF Component:
- RMFWCE - CPU MF Workload Characterization IPU Level.QRQ
- RMFWCL - CPU MF Workload Characterization LPAR Level.QRQ
- RMFWCT - CPU MF Workload Characterization CPUTYPE Level.QRQ
- RMFZIS - Daily zIIP Engine Use and Demand by Service Class.QRQ

The following queries have been added for the CA MICS Space Analyzer (VCA) Option:

VCACIS – Top 20 CI Splits by DS Type

CSV Extract 1: Top 20 CI Splits by DS Type
- The VCACIS query produces a daily Pareto style chart showing the top 20 VSAM data sets with the largest number of control interval splits in descending order, left to right. The query is useful to identify VSAM data sets that might need REORG maintenance to eliminate the control interval splits. By default, the query shows the top 20 VSAM data sets. The query can be easily modified to show a different number of data sets.

VCAT2C – VCA Daily top 20 STORCLAS Space Used

CSV Extract 1: Top 20 Storage Classes Ranked by Space Used
- The VCAT2C query generates a daily Pareto style chart identifying the top 20 Storage Classes that are based on DASD space that is allocated in the descending order from left to right. This query is useful to help you identify the largest users of DASD space tht is based on your storage class definitions.

VCAVOL – Volume Capacity and Use

CSV Extract 1: VOLSER Volume Capacity vs Space Allocated
- The VCAVOL query generates a chart showing the capacity and space that is allocated for DASD volumes you specify using query filtering criteria. This query is useful for studying the allocation patterns of specific volume subsets.

The following queries have been added for the CA MICS Analyzer Option for IMS:

IMSDAT – IMS Top 10 IMS Workloads

CSV Extract 1: DAILY - Top Ten IMS Workloads
- The IMSDAT IMS Daily Top 10 Workloads analysis by Region query generates a chart for each SYSID and IMS Region combination. This query is useful for analyzing workload-related transaction performance characteristics. The query uses the DAYS timespan IMS Application Unit Activity (IMSIAU) file as input and reports on yesterday’s top ten user-defined IMS Application Unit IDs (IMSAPU). The IMSAPU data element provides a means to categorize IMS transactions as belonging to specific groups or workloads. The IMSIAU file uses IMSAPU as a summarization key. The query selects the top nn (default is top 10) IMSAPUs for each IMS region. The top ten are selected based on the highest number of IMS transactions. The top ten IMSAPUs are graphically charted using two separate output views.

IMSDTR – IMS Daily Tran Count and Response Pct

CSV Extract 1: DAILY - IMS Region Transaction Response Time Analysis
- The IMSDTR query generates daily charts showing overall transaction counts and response time metrics for individual IMS regions. The query is useful to visualize the overall IMS transaction performance at the IM region level.

IMSDTT – IMS Daily Top 10 Transactions

CSV Extract 1: Daily Top Ten IMS Transactions by Volume with Average Response Time
- The IMSDTT query generates a Pareto style chart for each SYSID and IMS region combination. The query is useful to for analyzing transaction volume and performance characteristics. The query uses the DAYS timespan IMS User Activity file as input, and reports on yesterday’s top ten transactions for each IMS region.