MQSSL5 - MQSeries Queue Summary Report

The MQSSL5 - MQSeries Queue Summary Report uses measurements from the Queue Manager Activity File (MQAQAA) to display the relevant metrics for analyzing queue activity for individual queues over the date and time ranges that you select.
micsrm140
The MQSSL5 - MQSeries Queue Summary Report uses measurements from the Queue Manager Activity File (MQAQAA) to display the relevant metrics for analyzing queue activity for individual queues over the date and time ranges that you select.
The following
MICS
MQSeries Analyzer elements are selected:
Key elements
SYSID
- System Identifier
MQMSSI
- Queue Manager Name
QAABASNM
- Base Queue Name
HOUR
- Hour Of Day
Data elements
QAAQTYPE
- Queue Type
TOTCALLS
- Total Calls
computed:
TOTCALLS=SUM(QAAGN,QAAPN,QAAP1N,QAAON,QAACN,QAASN,QAAIN)
(see note)
TOTBYTES
- Total Bytes
computed:
TOTBYTES=SUM(QAAGETB,QAAPUTB)
(see note)
QAAQCPTM
- Total Queue CPU Time
AVGQCPTM
- Average Queue CPU Time
computed:
AVGQCPTM=QAAQCPTM/TOTCALLS
TOTETM
- Total Elapsed Time
computed:
TOTETM=SUM(QAACETM,QAAGETM,QAAIETM,QAAOETM,QAAPETM,QAAP1ETM,QAASETM)
AVGETM
- Average Elapsed Time
computed:
AVGETM=TOTETM/TOTCALLS
TOTPSET
- Total Page Set Access
computed:
TOTPSET=SUM(QAAGPSN,QAAPPSN,QAAP1PSN)
(see note)
Note
: Field values from 999,999 through 99,999,999 are divided by 1,000 and the character
k
is added to the end. Field values from 1,000,000 through 99,999,999,999 are divided by 1,000,000 and the character 'm' is added to the end. For the Total Bytes field, field values greater than 99,999,999,999 are divided by 1,000,000,000 and the character 'g' is added to the end.
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 MQSSL5, whose Catalog Group is PERFORM.
  5. Complete the MICF Execution panel (See MICF Reference).
  6. Complete the MQSeries Queue Summary Report panel.
    The result displays on your terminal. For example, see Queue Activity Summarized by Hour Within Day Report.
MQSeries Queue Summary Report Panel
+----------------------------------------------------------------------+ |----------------------- MQSeries Queue Summary Report --------------| | Command ===> | | | | Composing Inquiry: MQSSL5 - MQS Queue Summary | | Database ===> __________________________________________ | | Cycle(s) ===> __ - __ | | Timespan ===> _______ (DETAIL/DAYS/WEEKS/MONTHS) | | Report by hour if timespan is DAYS or WEEKS ===> _ (Y/N) | | Generate a report for each value of Zone ===> _ (Y/N) | | Data Selection: | | dd mmm yy dd mmm yy dd mmm yy dd mmm yy | | Date Ranges ===> __ ___ __ - __ ___ __ __ ___ __ - __ ___ __ | | Hour ===> __ - __ __ - __ __ - __ | | Zone ===> _ _ _ _ _ _ _ _ _ | | Sysid ===> ____ ____ ____ ____ ____ ____ | | Queue Manager Name (MQMSSI) ===> ____ ____ ____ ____ ____ ____ | | | | Queue Name (QAABASNM) (Asterisk '*' as last character for | | wildcard) ===> ________________________________________________ | | | +----------------------------------------------------------------------+
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.
Plot by hour
(Required) Defaults to Y. At the DAYS and WEEKS timespans, reports can be produced at an hourly, DAILY, or WEEKLY level. 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.
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.
Queue Name (QAABASNM)
(Optional) No default. 1-48 character value identifying the name of the queue (QAABASNM). You can specify an asterisk (*) as the last character for wildcard selection.

Queue Activity Summarized by Hour Within Day Report

Q U E U E S U M M A R Y R E P O R T Page 001 Report: Queue Activity Summarized by Hour Within Day System ID: XE44 Queue Manager: CSQ5 ---------------------------------------------------------------------------------------------------------------------------------- Day: ddmmmyy Hour: 7 Total Avg Total Avg Total Queue Total Total CPU CPU Elapsed Elapsed Pg Set Queue Name Type Calls Bytes Time Time Time Time Access ----------------------------------------------- ----- ------- -------- ----------- -------- ----------- -------- ------ CICS.INC56T5.INTQ05 Local 2 684 0:00:00.00 0.00012 0:00:00.02 0.01087 0 CSQ5.MQS.IQ1 Local 3 11 0:00:00.00 0.00046 0:00:00.79 0.26496 0 CSQ5.MQS.IQ2 Local 3 0 0:00:00.00 0.00007 0:00:00.06 0.02131 0 SYS.CHANNEL.INT5Q Local 6 0 0:00:00.00 0.00008 0:00:00.00 0.00014 0 SYS.COMMAND Local 5 419 0:00:00.00 0.00018 0:00:00.07 0.01333 0 SYS.CSQ5.Z28595 Local 66 18876 0:00:00.00 0.00006 0:00:00.25 0.00374 0 ---------------------------------------------------------------------------------------------------------------------------------- Day: ddmmmyy Hour: 8 Total Avg Total Avg Total Queue Total Total CPU CPU Elapsed Elapsed Pg Set Queue Name Type Calls Bytes Time Time Time Time Access ----------------------------------------------- ----- ------- -------- ----------- -------- ----------- -------- ------ SYS.CHANNEL.INT5Q Local 6 0 0:00:00.00 0.00008 0:00:00.00 0.00016 0 ---------------------------------------------------------------------------------------------------------------------------------- Day: ddmmmyy Hour: 9 Total Avg Total Avg Total Queue Total Total CPU CPU Elapsed Elapsed Pg Set Queue Name Type Calls Bytes Time Time Time Time Access ----------------------------------------------- ----- ------- -------- ----------- -------- ----------- -------- ------ CSQ5.MQS.IQ1 Local 12 44 0:00:00.00 0.00008 0:00:00.01 0.00059 0 CSQ5.MQS.IQ2 Local 12 0 0:00:00.00 0.00005 0:00:00.00 0.00008 0 SYS.CHANNEL.INT5Q Local 6 0 0:00:00.00 0.00008 0:00:00.00 0.00008 0 SYS.COMMAND Local 8 541 0:00:00.00 0.00014 0:00:00.02 0.00219 0 SYS.CSQ5.Z28595 Local 62 17530 0:00:00.00 0.00005 0:00:00.03 0.00048 0 SYS.CSQ5.Z25034 Local 62 17530 0:00:00.00 0.00006 0:00:00.06 0.00097 0 ---------------------------------------------------------------------------------------------------------------------------------- Day: ddmmmyy Hour: 10 Total Avg Total Avg Total Queue Total Total CPU CPU Elapsed Elapsed Pg Set Queue Name Type Calls Bytes Time Time Time Time Access ----------------------------------------------- ----- ------- -------- ----------- -------- ----------- -------- ------ CSQ5.MQ.TEST.Q1 Local 100022 10000k 0:00:14.24 0.00014 0:16:16.45 0.00976 33 SYS.CHANNEL.INT5Q Local 6 0 0:00:00.00 0.00007 0:00:00.00 0.00008 0 SYS.COMMAND Local 53 6965 0:00:00.01 0.00013 0:00:00.01 0.00023 0 SYS.CSQ5.C32541 Local 70 20222 0:00:00.00 0.00006 0:00:00.07 0.00096 0 SYS.CSQ5.C32544 Local 58 16184 0:00:00.00 0.00005 0:00:00.05 0.00087 0 SYS.CSQ5.C32563 Local 67 18876 0:00:00.00 0.00005 0:00:00.18 0.00272 0 SYS.CSQ5.C32564 Local 62 17530 0:00:00.00 0.00005 0:00:00.04 0.00059 0 SYS.CSQ5.C32565 Local 175 58026 0:00:00.01 0.00005 0:00:00.05 0.00026 0 ----------------------------------------------------------------------------------------------------------------------------------