MQSSL3 - MQSeries Queue Activity Report
The MQSSL3 - MQSeries Queue Activity Report uses measurements from the Queue Manager Activity file (MQAQAA).
micsrm140
The Report then displays the relevant metrics for analyzing queue activity over the date and time ranges that you select.
The following
MICS
Analyzer for MQSeries 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:
- Enter theMICS Workstation Facility(MWF).
- Select option 2,MICS Information Center Facility(MICF).
- Select option 2, Database Inquiries.
- Select MQSSL3, whose Catalog Group is PERFORM.
- Complete the MICF Execution panel.
- Complete the MQSeries Queue Activity Report panel.The result displays on your terminal. For example, see the Queue Activity Summarized by Week Report included below.
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 - - - - - | +--------------------------------------------------------------------------------------------------------------------------------+