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:
  1. Enter the
    MICS Workstation Facility
    (MWF).
  2. Select option 2,
    MICS Information Center Facility
    (MICF).
  3. Select option 2, Database Inquiries.
  4. Select MQSSL4, whose Catalog Group is PERFORM.
  5. Complete the MICF Execution panel.
  6. 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