MQSSL3 - MQSeries Queue Activity Report

The MQSSL3 - MQSeries Queue Activity Report uses measurements from the Queue Manager Activity file (MQAQAA). The Report then displays the relevant metrics for analyzing queue activity over the date and time ranges that you select.
micsrm140
The MQSSL3 - MQSeries Queue Activity Report uses measurements from the Queue Manager Activity file (MQAQAA). The Report then displays the relevant metrics for analyzing queue activity 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
MQSATYP
- Type of Connection
HOUR
- Hour of Day
Data elements
QAABUFFP
- Buffer Pool Number
QAACFSTR
- Name of Coupling Facility Structure
QAAINDX
- Index Type of Queue
QAANPS
- Page Set Number
QAAQSG
- Queue Sharing Group
QAAQTYPE
- Queue Type
QAAGN
- MQGET Calls (see note)
QAAGETB
- Bytes Got (see note)
QAAGCTM
- CPU Time Used MQGET Calls
QAAAVGCT
- Avg MQGET CPU Time
QAAGETM
- Elapsed Time MQGET Calls
QAAAVGTM
- Avg MQGET Time
QAAGPSN
- Page Set Reads (see note)
QAAGSUS
- Times Suspended MQGET (see note)
QAAGJWN
- Journal (Log) Write Calls MQGET (see note)
QAAGJWTM
- Wait Time Journal (Log) Write MQGET
AVGGJTM
- Average Wait Time Journal (Log) Write MQGET
computed:
AVGGJTM=QAAGJWTM/QAAGJWN
QAAPN
- MQPUT Calls (see note)
QAAPUTB
- Bytes Put (see note)
QAAPCTM
- CPU Time Used MQPUT Calls
QAAAVPCT
- Avg MQPUT CPU Time
QAAPETM
- Total Elapsed Time MQPUT Calls
QAAAVPTM
- Avg MQPUT Time
QAAPPSN
- Page Set Put Calls (see note)
QAAPSUS
- Times Suspended MQPUT (see note)
QAAPJWN
- Journal (Log) Write Calls MQPUT (see note)
QAAPJWTM
- Wait Time Journal (Log) Write MQPUT
AVGPJTM
- Average Wait Time Journal (Log) Write MQPUT
computed:
AVGPJTM=QAAPJWTM/QAAPJWN
QAAP1N
- MQPUT1 Calls (see note)
QAAP1CTM
- CPU Time Used MQPUT1 Calls
QAAAV1CT
- Avg MQPUT1 CPU Time
QAAP1ETM
- Total Elapsed Time MQPUT1 Calls
QAAAV1TM
- Avg MQPUT1 Time
QAAP1PSN
- Page Set MQPUT1 Calls (see note)
QAAP1SUS
- Times Suspended MQPUT1 (see note)
QAAP1JWN
- Journal (Log) Write Calls MQPUT1 (see note)
QAAP1JTM
- Wait Time Journal (Log) Write MQPUT1
AVGP1JTM
- Average Wait Time Journal (Log) Write MQPUT1
computed:
AVGP1JTM=QAAP1JTM/QAAP1JWN
QAAON
- MQOPEN Calls (see note)
QAAOCTM
- Total CPU Time Used MQOPEN Calls
QAAAVOCT
- Avg MQOPEN CPU Time
QAAOETM
- Total Elapsed Time MQOPEN
QAAAVOTM
- Avg MQOPEN Time
QAACN
- MQCLOSE Calls (see note)
QAACCTM
- Total CPU Time Used MQCLOSE
QAAAVCCT
- Avg MQCLOSE CPU Time
QAACETM
- Total Elapsed Time MQCLOSE
QAAAVCTM
- Avg MQCLOSE Time
QAASN
- MQSET Calls (see note)
QAASCTM
- CPU Time Used MQSET Calls
QAAAVSCT
- Avg MQSET CPU Time
QAASETM
- Total Elapsed Time MQSET Calls
QAAAVSTM
- Avg MQSET Time
QAASJWN
- Journal (Log) Write Calls MQSET (see note)
QAASJWTM
- Wait Time Journal (Log) Write MQSET
AVGSJTM
- Average Wait Time Journal (Log) Write MQSET
computed:
AVGSJTM=QAASJWTM/QAASJWN
QAAIN
- MQINQ Calls (see note)
QAAICTM
- CPU Time Used MQINQ
QAAAVICT
- Avg MQINQ CPU Time
QAAIETM
- Total Elapsed Time MQINQ Calls
QAAAVITM
- Avg MQINQ Time
Note:
Data elements greater than 99,999,999 are divided by 1,000,000 and the character
m
is added to the end of the value. Data elements from 999,999 through 99,999,999, are divided by 1,000 and the character
k
is added to the end of the value.
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 MQSSL3, whose Catalog Group is PERFORM.
  5. Complete the MICF Execution panel.
  6. Complete the MQSeries Queue Activity Report panel.
    The result displays on your terminal. For example, see Queue Activity Summarized by Week Report.
MQSeries Queue Activity Report Panel
+----------------------------------------------------------------------+ |------------------- MQSeries Queue Activity Report -----------------| | Command ===> | | | | Composing Inquiry: MQSSL3 - MQS Queue Activity | | 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) ===> ____ ____ ____ ____ ____ ____ | | Type Of Connection (MQSATYP) 1=CICS, 6=Channel Init, etc. | | (Separate by commas) example: 1,2,6 ===> _______________ | | | | 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 not 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.
Type Of Connection (MQSATYP)
(Optional) No default. Comma- separated list of Type of Connection (MQSATYP) codes. The input data file is compared to the list of Type of Connection codes. Reporting is restricted to the Type of Connection codes in the list. If no list is specified, all Type of Connections in the input data are reported on. The list does not need to be in any specific order. Do not insert blanks. Do not use leading zeros. The list must be entered as shown in the example: one-digit numbers separated by commas.
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 Week Report

Q U E U E A C T I V I T Y R E P O R T Report: Queue Activity Summarized by Week Page 001 System ID: A2CC Queue Manager: IQM6 Zone: 1 +--------------------------------------------------------------------------------------------------------------------------------+ | Queue Name: CICS.ICIC4T01.INITQ01 Week: 32 | | Queue Type: Local Buffer Pool: 2 Shared Queue: No Start: ddmmmyy:12:04:46.74 | | Index Type: None Page Set: 2 CF Structure: End: ddmmmyy:13:32:35.57 | | | | Access Total Avg Avg Page Call Log Log Wait Avg Log | | Address Call CPU CPU Elapsed Elapsed Set Suspend Write Elapsed Wait | | Space Type Type Calls Bytes Time Time Time Time Access Count Rqsts Time Time | | ---------- ----- ------ ------ ----------- ------- ----------- ------- ------ ------- ------ ----------- ------- | | CICS GET 4530 1549k 0:00:00.33 0.00007 0:00:01.32 0.00029 0 0 0 0:00:00.00 0.00000 | | PUT 0 0 0:00:00.00 0.00000 0:00:00.00 0.00000 0 0 0 0:00:00.00 0.00000 | | PUT1 0 0 0:00:00.00 0.00000 0:00:00.00 0.00000 0 0 0 0:00:00.00 0.00000 | | OPEN 2 - 0:00:00.00 0.00067 0:00:00.02 0.01190 - - - - - | | CLOSE 0 - 0:00:00.00 0.00000 0:00:00.00 0.00000 - - - - - | | SET 0 - 0:00:00.00 0.00000 0:00:00.00 0.00000 - - 0 0:00:00.00 0.00000 | | INQ 0 - 0:00:00.00 0.00000 0:00:00.00 0.00000 - - - - - | +--------------------------------------------------------------------------------------------------------------------------------+ +--------------------------------------------------------------------------------------------------------------------------------+ | Queue Name: IQM6.MQ.DSTEST1.QUEUE Week: 32 | | Queue Type: Local Buffer Pool: 0 Shared Queue: No Start: ddmmmyy:10:11:40.61 | | Index Type: Model Page Set: 0 CF Structure: End: ddmmmyy:10:31:20.54 | | | | Access Total Avg Avg Page Call Log Log Wait Avg Log | | Address Call CPU CPU Elapsed Elapsed Set Suspend Write Elapsed Wait | | Space Type Type Calls Bytes Time Time Time Time Access Count Rqsts Time Time | | ---------- ----- ------ ------ ----------- ------- ----------- ------- ------ ------- ------ ----------- ------- | | Batch/TSO GET 6 0 0:00:00.00 0.00007 0:00:00.00 0.00035 0 0 0 0:00:00.00 0.00000 | | PUT 100000 10000k 0:00:14.23 0.00014 0:16:16.45 0.00976 33 100106 200074 0:31:21.05 0.00940 | | PUT1 0 0 0:00:00.00 0.00000 0:00:00.00 0.00000 0 0 0 0:00:00.00 0.00000 | | OPEN 8 - 0:00:00.00 0.00011 0:00:00.00 0.00019 - - - - - | | CLOSE 8 - 0:00:00.00 0.00003 0:00:00.00 0.00003 - - - - - | | SET 0 - 0:00:00.00 0.00000 0:00:00.00 0.00000 - - 0 0:00:00.00 0.00000 | | INQ 0 - 0:00:00.00 0.00000 0:00:00.00 0.00000 - - - - - | +--------------------------------------------------------------------------------------------------------------------------------+