MQSSL4 - MQSeries Task Accounting Report
The MQSSL4 - MQSeries Task Accounting Report uses measurements from the Task Accounting file (MQATAA). The Report then displays the relevant metrics for task level analysis over the date and time ranges that you select.
micsrm140
The MQSSL4 - MQSeries Task Accounting Report uses measurements from the Task Accounting file (MQATAA). The Report then displays the relevant metrics for task level analysis 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
- MQSATYP
- - Type Of Connection
- HOUR
- - Hour Of Day
- Summary
- - User specified data element (optional) - Key
Data elements
- TAACOUNT
- - Task Count (see note)
- TOTCPUTM
- - Total CPU Time
- computed:
- TOTCPUTM=SUM(TAANCPTM,TAAQCPTM)
- AVGCPUTM
- - Average CPU Time
- computed:
- AVGCPUTM=TOTCPUTM/TAACOUNT
- TAAEXCTM
- - Task Execution Time
- AVGEXCTM
- - Average Execution Time
- computed:
- AVGEXCTM=TAAEXCTM/TAACOUNT
- TAASUSN
- - Task Suspended Count (see note)
- TAASUSTM
- - Total Suspend Time
Non-queue Task Statistics
- TAACMN
- - Commit Calls (see note)
- TAACMCTM
- - Commit CPU Time
- AVGCMCTM
- - Average Commit CPU Time
- computed:
- AVGCMCTM=TAACMCTM/TAACMN
- TAACMETM
- - Commit Elapsed Time
- AVGCMETM
- - Average Commit Elapsed Time
- computed:
- AVGCMETM=TAACMETM/TAACMN
- TAABAN
- - Backout Calls (see note)
- TAABACTM
- - Backout CPU Time
- AVGBACTM
- - Average Backout CPU Time
- computed:
- AVGBACTM=TAABACTM/TAABAN
- TAABAETM
- - Backout Elapsed Time
- AVGBAETM
- - Average Backout Elapsed Time
- computed:
- AVGBAETM=TAABAETM/TAABAN
- TAAOTN
- - Other MQI Calls (see note)
- TAAOTCTM
- - Other MQI Calls CPU Time
- AVGOTCTM
- - Average Other MQI Calls CPU Time
- computed:
- AVGOTCTM=TAAOTCTM/TAAOTN
- TAAOTETM
- - Other MQI Calls Elapsed Time
- AVGOTETM
- - Average Other MQI Calls Elapsed Time
- computed:
- AVGOTETM=TAAOTETM/TAAOTN
- NQCALL
- - Total Commit, Backout, and Other MQI Calls
- computed:
- NQCALL=SUM(TAACMN,TAABAN,TAAOTN)
- (see note)
- NQCPUTM
- - Total Commit, Backout, and Other MQI CPU Time
- computed:
- NQCPUTM=SUM(TAACMCTM,TAABACTM,TAAOTCTM)
- NQAVGCTM
- - Total Commit, Backout, and Other MQI Average CPU Time
- computed:
- NQAVGCTM=TAANCPTM/TAACOUNT
- NQELATM
- - Total Commit, Backout, and Other MQI Elapsed Time
- computed:
- NQELATM=SUM(TAACMETM,TAABAETM,TAAOTETM)
- NQAVGETM
- - Total Commit, Backout, and Other MQI Average Elapsed Time
- computed:
- NQAVGETM=NQELATM/NQCALL
Queue Task Statistics
- TAAGN
- - MQGET Calls (see note)
- TAAGETB
- - Bytes Got (see note)
- TAAGCTM
- - CPU Time Used MQGET Calls
- TAAAVGCT
- - Avg MQGET CPU Time All Queues
- TAAGETM
- - Elapsed Time MQGET Calls
- TAAAVGTM
- - Avg MQGET Time All Queues
- TAAGPSN
- - Page Set Reads (see note)
- TAAGSUS
- - Times Suspended MQGET (see note)
- TAAGJWN
- - Journal (Log) Write Calls MQGET (see note)
- TAAGJWTM
- - Wait Time Journal (Log) Write MQGET
- AVGGJTM
- - Average Wait Time Journal (Log) Write Calls MQGET
- computed:
- AVGGJTM=TAAGJWTM/TAAGJWN
- TAAPN
- - MQPUT Calls (see note)
- TAAPUTB
- - Bytes Put (see note)
- TAAPCTM
- - CPU Time Used MQPUT Calls
- TAAAVPCT
- - Avg MQPUT CPU Time All Queues
- TAAPETM
- - Total Elapsed Time MQPUT Calls
- TAAAVPTM
- - Avg MQPUT Time All Queues
- TAAPPSN
- - Page Set Put Calls (see note)
- TAAPSUS
- - Times Suspended MQPUT (see note)
- TAAPJWN
- - Journal (Log) Write Calls MQPUT (see note)
- TAAPJWTM
- - Wait Time Journal (Log) Write MQPUT
- AVGPJTM
- - Average Wait Time Journal (Log) Write Calls MQPUT
- computed:
- AVGPJTM=TAAPJWTM/TAAPJWN
- TAAP1N
- - MQPUT1 Calls (see note)
- PUT1BC
- - Bytes Put1 computed from Bytes Put (TAAPUTB) (see note)
- TAAP1CTM
- - CPU Time Used MQPUT1 Calls
- TAAAV1CT
- - Avg MQPUT1 CPU Time All Queues
- TAAP1ETM
- - Total Elapsed Time MQPUT1 Calls
- TAAAV1TM
- - Avg MQPUT1 Time All Queues
- TAAP1PSN
- - Page Set MQPUT1 Calls (see note)
- TAAP1SUS
- - Times Suspended MQPUT1 (see note)
- TAAP1JWN
- - Journal (Log) Write Calls MQPUT1 (see note)
- TAAP1JTM
- - Wait Time Journal (Log) Write MQPUT1
- AVGP1JTM
- - Average Wait Time Journal (Log) Write Calls MQPUT1
- computed:
- AVGP1JTM=TAAP1JTM/TAAP1JWN
- TAAON
- - MQOPEN Calls (see note)
- TAAOCTM
- - Total CPU Time Used MQOPEN Calls
- TAAAVOCT
- - Avg MQOPEN CPU Time All Queues
- TAAOETM
- - Total Elapsed Time MQOPEN
- TAAAVOTM
- - Avg MQOPEN Time All Queues
- TAACN
- - MQCLOSE Calls (see note)
- TAACCTM
- - Total CPU Time Used MQCLOSE
- TAAAVCCT
- - Avg MQCLOSE CPU Time All Queues
- TAACETM
- - Total Elapsed Time MQCLOSE
- TAAAVCTM
- - Avg MQCLOSE Time All Queues
- TAASN
- - MQSET Calls (see note)
- TAASCTM
- - CPU Time Used MQSET Calls
- TAAAVSCT
- - Avg MQSET CPU Time All Queues
- TAASETM
- - Total Elapsed Time MQSET Calls
- TAAAVSTM
- - Avg MQSET Time All Queues
- TAASJWN
- - Journal (Log) Write Calls MQSET (see note)
- TAASJWTM
- - Wait Time Journal (Log) Write MQSET
- AVGSJTM
- - Average Wait Time Journal (Log) Write Calls MQSET
- computed:
- AVGSJTM=TAASJWTM/TAASJWN
- TAAIN
- - MQINQ Calls (see note)
- TAAICTM
- - CPU Time Used MQINQ
- TAAAVICT
- - Avg MQINQ CPU Time All Queues
- TAAIETM
- - Total Elapsed Time MQINQ Calls
- TAAAVITM
- - Avg MQINQ Time All Queues
- QCALL
- - Total Calls
- computed:
- QCALL=SUM(TAAGN,TAAPN,TAAP1N,TAAON,TAACN,TAASN,TAAIN)
- (see note)
- QBYTE
- - Total Bytes
- computed:
- QBYTE=SUM(TAAGETB,TAAPUTB,PUT1BC)
- (see note)
- TAAQCPTM
- - Total Queue CPU Time
- QAVCPUTM
- - Total Average CPU Time
- computed:
- QAVCPUTM=TAAQCPTM/QCALL
- QELATM
- - Total Elapsed Time
- computed:
- QELATM=SUM(TAAGETM,TAAPETM,TAAP1ETM,TAAOETM,TAACETM,TAASETM,TAAIETM)
- QAVELATM
- - Total Average Elapsed Time
- computed:
- QAVELATM=QELATM/QCALL
- QPSET
- - Total Page Set Access
- computed:
- QPSET=SUM(TAAGPSN,TAAPPSN,TAAP1PSN)
- (see note)
- QSUSCNT
- - Total Call Suspend Count
- computed:
- QSUSCNT=SUM(TAAGSUS,TAAPSUS,TAAP1SUS)
- (see note)
- QLOG
- - Total Log Write Calls
- computed:
- QLOG=SUM(TAAGJWN,TAAPJWN,TAAP1JWN,TAASJWN)
- (see note)
- QLOGETM
- - Total Log Wait Elapsed Time
- computed:
- QLOGETM=SUM(TAAGJWTM,TAAPJWTM,TAAP1JTM,TAASJWTM)
- QAVLOGTM
- - Total Average Log Wait Time
- computed:
- QAVLOGTM=QLOGETM/QLOG
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.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 MQSSL4, whose Catalog Group is PERFORM.
- Complete the MICF Execution panel.
- Complete the MQSeries Task Accounting Report panel.The result displays on your terminal. For an example, see Task Accounting Summarized by Hour Within Week Report.
MQSeries Task Accounting Report Panel
+----------------------------------------------------------------------+ |------------------- MQSeries Task Accounting Report -----------------| | Command ===> | | | | Composing Inquiry: MQSSL4 - MQS Task Accounting | | 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 ===> _______________ | | Optional Summarization Key ===> _________ | | | +----------------------------------------------------------------------+
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.
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.
Optional Summarization Key
(Optional) No default. 1-8 character data element name. The specified data element summarizes the Task Accounting Report (restricted to the data elements in the Task Accounting File (MQATAA)).
Task Accounting Summarized by Hour Within Week Report
T A S K A C C O U N T I N G R E P O R T Page 001 Report: Task Accounting Summarized by Hour Within Week System ID: XE44 Queue Manager: CSQ5 ------------------------------------------------------------------------------------------------------------------------------------ Tasks: 2 Optional Summary Key TAACHNL: CSQ5.TO.CTS9 Week: 48 Hour: 14 Total CPU Time: 0:00:01.02 Connection Type: Chan Init Start: ddmmmyy:14:53:55.71 Avg CPU Time: 0.51132 End: ddmmmyy:14:54:23.85 Task Execution Time: 0:00:43.06 Avg Execution Time: 0:00:21.531 Tasks Suspended: 3000 Total Suspend Time: 0:00:09.81 ------------------------------------------------------------------------------------------------------------------------- NON-QUEUE TASK STATISTICS ------------------------------------------------------------------------------------------------------------------------- Avg Avg Call CPU CPU Elapsed Elapsed Type Calls Time Time Time Time ------- ------ ----------- -------- ----------- -------- Commit 3000 0:00:00.14 0.00005 0:00:09.94 0.00331 Backout 0 0:00:00.00 0.00000 0:00:00.00 0.00000 Other 0 0:00:00.00 0.00000 0:00:00.00 0.00000 ------ ----------- -------- ----------- -------- Totals 3000 0:00:00.14 0.06956 0:00:09.94 0.00331 ------------------------------------------------------------------------------------------------------------------------- QUEUE TASK STATISTICS ------------------------------------------------------------------------------------------------------------------------- Avg Avg Page Call Log Log Wait Avg Log Call CPU CPU Elapsed Elapsed Set Suspend Write Elapsed Wait Type Calls Bytes Time Time Time Time Access Count Calls Time Time ------ ------ ------ ----------- -------- ----------- -------- ------- ------- ------ ----------- -------- GET 4001 2000k 0:00:00.34 0.00009 0:00:03.20 0.00080 0 1001 2000 0:00:05.50 0.00275 PUT 1000 2000k 0:00:00.14 0.00014 0:00:00.16 0.00016 0 3 0 0:00:00.00 0.00000 PUT1 1000 0 0:00:00.21 0.00021 0:00:00.22 0.00022 0 0 0 0:00:00.00 0.00000 OPEN 2001 - 0:00:00.14 0.00007 0:00:00.15 0.00007 - - - - - CLOSE 2000 - 0:00:00.04 0.00002 0:00:00.05 0.00002 - - - - - 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 - - - - - ------ ------ ----------- -------- ----------- -------- ------- ------- ------ ----------- -------- Totals 10002 4000k 0:00:00.88 0.00009 0:00:03.77 0. 00038 0 1004 2000 0:00:05.50 0.00275