MQSCSD - MQSeries Data Manager Analysis

The MQSCSD - MQSeries Data Manager Analysis uses measurements from the Data Manager Statistics File (MQSDMS). The analysis then displays the relevant metrics for analyzing the data manager activity over the date and time intervals that you select.
micsrm140
The MQSCSD - MQSeries Data Manager Analysis uses measurements from the Data Manager Statistics File (MQSDMS). The analysis then displays the relevant metrics for analyzing the data manager activity over the date and time intervals that you select.
The following
MICS MQSeries Analyzer
elements are selected:
Key elements
 
SYSID
- System Identifier
MQMSSI
- Queue Manager Name
HOUR
- Hour of Day
Data elements
 
DMSDGET
- Object_Get Calls
DMSDPUT
- Object_Put Calls
DMSDCRE
- Object_Create Calls
DMSDDEL
- Object_Delete Calls
DMSDLOC
- Object_Locate Calls
DMSALST
- Stgclass Change Calls
Note:
 The label that is associated with the field DATE varies based on the timespan used.
To produce the report, follow these steps:
  1. Enter the
    MICS Workstation Facility
    (MWF).
  2. Select option 2,
    MICS Information Center Facility
    (MICF).
  3. Select option 2, Database Inquiries.
  4. Select MQSCSD, whose Catalog Group is PERFORM.
  5. Complete the MICF Execution panel.
  6. Complete the MQSeries Data Manager Analysis panel.
    The result displays on your terminal. For an example, see Weekly MQS Data Manager Analysis Report.
MQSeries Data Manager Analysis Panel
 
+----------------------------------------------------------------------+ |-------------------- MQSeries Data Manager Analysis ------------------| | Command ===> | | | | Composing Inquiry: MQSCSD - MQS Data Manager Analysis | | | | Database ===> _________________________________________ | | Cycle(s) ===> __ - __ | | Timespan ===> ______ (DETAIL/DAYS/WEEKS/MONTHS) | | Plot by hour if timespan is DAYS or WEEKS ===> _ (Y/N) | | Generate a plot for each value of Zone ===> _ (Y/N) | | Generate color graphic plots ===> _ (Y/N) | | Generate CSV Extract for Query and Reporting ===> _ (Y/N) | | Data Selection: | | dd mmm yy dd mmm yy dd mmm yy dd mmm yy | | Date Ranges ===> __ ___ __ - __ ___ __ __ ___ __ - __ ___ __ | | Hour ===> __ - __ __ - __ __ - __ | | Zone ===> _ _ _ _ _ _ _ _ _ | | Sysid ===> ____ ____ ____ ____ ____ ____ | | MQS Queue Manager Name(MQMSSI) ===> ____ ____ ____ ____ ____ ____ | | | +----------------------------------------------------------------------+
Database 
(Required) No default. Specify up to six database unit IDs (the IDs of the
MICS
database units from which files are read). Duplicates are not allowed. If
MICS
files exist in only one database unit, this parameter is set automatically. To display a selection list of valid database unit IDs, specify
(question mark).
Cycle(s) 
(Required) Defaults to 01. Cycle or cycles of the specified timespan of the
MICS
files that are used as input to the analysis. Two data entry fields are provided so you can specify a range of cycles. The fields can contain any numeric value from 0 through 99. If you want only a single cycle (such as cycle 01), specify the selected cycle in the first entry field and leave the second field blank. If you supply a single-digit number, leading zeros are inserted automatically (7 becomes 07). You can specify a cycle range in either ascending or descending order (for example, 01-05 or 05-01).
Timespan 
(Required) Default varies by report. The timespan of the
MICS
database from which the primary input files are selected. Required input files must be available at the specified timespan.
Report by hour 
(Required) Defaults to Y. At the DAYS and WEEKS timespans, reports can be produced at hourly, DAILY, or WEEKLY levels. If you specify Y (Yes) to Report by hour, the data are summarized and displayed by hour, and separate reports are produced for each day or week. If you specify N (No) to Report by hour, the data are summarized by day or week, and a single report listing all days or weeks is produced.
Generate a report for each value of Zone 
(Required) Defaults to Y. Specify Y (Yes) to generate reports for each zone. The nature and resource requirements of processing often change from one zone to another (for example, prime shift online demands versus production batch requirements at non-prime shift periods). Zone reporting gives you the ability to display separate reports for each observed zone. If you specify N (No), the data are summarized to the appropriate level and displayed on a single report.
Generate color graphic plots 
(Required) Defaults to N (No). Specify Y (Yes) if you want to generate color graphics plots. SAS/GRAPH software is a prerequisite for color graphics. When set to No standard SAS plots and graphs are produced (non-color, line formats).
Generate CSV Extract for Query and Reporting 
(Required) Defaults to N (No). Specify Y (Yes) to generate an extract CSV file for subsequent use in
MICS
Query and Reporting. This option is only valid when
MICS
Query and Reporting is installed.
Date Ranges 
(Optional) No default. Up to two date ranges in DD MMM YY format. The first value in each date range is the starting date and the last value is the ending date. The ending date must be higher than the starting date. The date ranges cannot overlap, but you can specify the higher range before the lower range. For example, a valid date range specification is specifying date range 1 as 01 JAN 95 - 31 DEC 95 and specifying date range 2 as 01 JAN 94 - 31 DEC 94. An input observation is selected if its date value is greater than or equal to the starting date and is less than or equal to the ending date of any specified date range.
Hour 
(Optional) No default. 0-23. Up to three hour ranges. The first value is the starting hour and the last value is the ending hour. The ending hour must be higher than the starting hour. The hour ranges cannot overlap, but you can specify the higher range before the lower range. For example, a valid hour range specification is 18 - 23 and 09 - 17. An input observation is selected if its hour value is greater than or equal to the starting hour and is less than or equal to the ending hour of any specified hour range.
Zone 
(Optional) No default. 1-character zone value from 1 to 9. You can specify up to nine zone values. An input observation is selected if its zone value is equal to any of the specified values.
SYSID 
(Optional) No default. 1-4 character SYSID value. You can specify up to six SYSIDs. An input observation is selected if its SYSID value is equal to any of the specified values.
Queue Manager Name (MQMSSI) 
(Optional) No default. 1-4 character value identifying the name of the Queue Manager (MQMSSI). Specify up to six Queue Manager Names. An input observation is selected if its identifier is equal to any of the specified values.

Weekly MQS Data Manager Analysis Report

CA MICS MQSeries Analyzer Weekly MQS Data Manager Analysis 14:48 Tuesday, mmm dd, yyyy -------------------------------------- ZONE=1 SYSID=XE44 MQMSSI=CSQ1 START OF WEEK=yyyy/mm/dd -------------------------------------- Plot of DMSDGET*HOUR. Symbol used is 'G'. Plot of DMSDPUT*HOUR. Symbol used is 'P'. Plot of DMSDCRE*HOUR. Symbol used is 'C'. Plot of DMSDDEL*HOUR. Symbol used is 'D'. Plot of DMSDLOC*HOUR. Symbol used is 'L'. | | 10000 + L | | | | L L L O | B 8000 + J | E | C | T | _ | G 6000 + E | T | | R | e | q 4000 + u | e | s | t | L s | 2000 + G | G G G | | | G D D D D | D 0 + G G G G P P P P P | ---+------------+------------+------------+------------+------------+------------+------------+------------+-- 8 9 10 11 12 13 14 15 16 NOTE: 21 obs hidden. Hour of Day CA MICS MQS MQSCSD yymmmdd BASED ON Information Summarized by Hour Within Week