MQSSL2 - MQSeries Performance Summary
The MQSSL2 - MQSeries Performance Summary uses measurements from the Buffer Manager Statistics File (MQSBMS), Log Manager Statistics File (MQSLMS), Message Manager Statistics File (MQSMMS), and the Data Manager Statistics File (MQSDMS). The Summary then displays an overall view of the
MICS
MQSeries configuration, activity, and service measurements over date and time ranges that you select.micsrm140
The MQSSL2 - MQSeries Performance Summary uses measurements from the Buffer Manager Statistics File (MQSBMS), Log Manager Statistics File (MQSLMS), Message Manager Statistics File (MQSMMS), and the Data Manager Statistics File (MQSDMS). The Summary then displays an overall view of the
MICS
MQSeries configuration, activity, and service measurements over date and time ranges that you select.Each report displays categorized details about activity, configuration, and utilization. The report categories and labels are listed on the left side of the report pages. Columns on the report represent the element value for the appropriate granularity level (hour or date) as denoted above the columns. The last column on the report shows the percent increase or decrease over the time periods that are represented on the report page.
The following table displays the relationship between report labels and database source elements under each report category.
Report Category: MESSAGE MANAGER ACTIVITY
Report Label File Element ------------ ---- ------- MQGET REQUESTS MQSMMS MMSGET MQPUT REQUESTS MQSMMS MMSPUT MQPUT1 REQUESTS MQSMMS MMSPUT1 MQOPEN REQUESTS MQSMMS MMSOPEN MQCLOSE REQUESTS MQSMMS MMSCLOS
Report Category: BUFFER POOL n UTILIZATION*
Report Label File Element ------------ ---- ------- AVERAGE BUFFERS IN POOL MQSBMS BMSAVBUF AVERAGE AVAIL. BUFFERS MQSBMS BMSAVAVB NO AVAILABLE BUFFERS MQSBMS BMSSOS TOTAL GETS (NEW+CURRENT) MQSBMS BMSTNGET % PAGE READS TO DASD MQSBMS BMSPCRIO % GETS - NOT IN BUFFER MQSBMS BMSPCSTL PAGE GETS(CURRENT PAGE) MQSBMS BMSGETP % REQUESTS NEW/EMPTY PAGE MQSBMS BMSPCNP PAGE WRITES MQSBMS BMSWIO PAGE UPDATES MQSBMS BMSSTW % PAGE UPDATES MQSBMS BMSPCSTW SYNC. PAGE WRITES MQSBMS BMSIMW SYNC PAGE PROCESSOR START MQSBMS BMSDMC NO. OF PAGES TO DASD MQSBMS BMSTPW
Report Category: LOG MANAGER STATISTICS
Report Label File Element ------------ ---- ------- TOTAL LOG WRITE REQUESTS MQSLMS LMSTNLWR % WRITE REQUESTS - WAIT MQSLMS LMSPCWRW % WRITE REQUESTS - FORCE MQSLMS LMSPCWRF TOTAL LOG READ REQUESTS MQSLMS LMSTNLRR % READ LOG REQ IN BUFFER MQSLMS LMSPCRBU % READ ACTIVE LOG DS MQSLMS LMSPCRAC % READ ARCHIVE LOG DS MQSLMS LMSPCRAR % READ DELAYED (MAXALLC) MQSLMS LMSPCWTL WAIT-UNAVAILABLE BUFFERS MQSLMS LMSWTB
Report Category: DATA MANAGER STATISTICS
Report Label File Element ------------ ---- ------- OBJECT_GET REQUESTS MQSDMS DMSDGET OBJECT_LOCATE REQUESTS MQSDMS DMSDLOC OBJECT_PUT REQUESTS MQSDMS DMSDPUT OBJECT_CREATE REQUESTS MQSDMS DMSDCRE OBJECT_DELETE REQUESTS MQSDMS DMSDDEL
* By default, one category section represents one Buffer Pool ID (0 through 15). However, if you restrict selection to only certain buffer pools, only the selected pool categories are displayed.
Note:
The label that is associated with the field DATE in the column titles varies based on the timespan used.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 MQSSL2, whose Catalog Group is PERFORM.
- Complete the MICF Execution panel.
- Complete the MQSeries Performance Summary panel.The result displays on your terminal. For example, see Hourly Performance Summary Report Page 1-3.
MQSeries Performance Summary Panel
+----------------------------------------------------------------------+ |------------------- MQSeries Performance Summary -------------------| | Command ===> | | | | Composing Inquiry: MQSSL2 - MQSeries Performance Summary | | | | Database ===> _________________________________________ | | Cycle(s) ===> __ - __ | | Timespan ===> ______ (DETAIL/DAYS/WEEKS/MONTHS) | | Rport 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 ===> ____ ____ ____ ____ ____ ____ | | MQS Queue Manager Name(MQMSSI) ===> ____ ____ ____ ____ ____ ____ | | MQS Buffer Pool ID Selection(BMSPOOL) (Separate by commas) | | example 0,3,5,14 ===> ____________________________________ | | | +----------------------------------------------------------------------+
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.Report 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. Separate reports are then 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 plot 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 specifies date range 1 as 01 JAN 95 - 31 DEC 95 and specifies 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.MQS Buffer Pool ID (BMSPOOL)
(Optional) No default. 1-4 numeric buffer pool value (BMSPOOL). Specify up to 15 buffer pools. An input observation is selected if its identifier is equal to any of the specified values. Leading zeros are not required, however any 4 numeric values are accepted. For example, specifying 1 is equivalent to 0001.Hourly Performance Summary Report Page 1
14:50 Tuesday, mmm dd, yyyy C A CA MICS MQSeries Analyzer HOURLY PERFORMANCE SUMMARY FOR ZONE = 1 SYSTEM = XE44 MQM SUBSYSTEM = CSQ1 RUNDATE = mmm dd, yyyy ------------------------------------------------------------------------------------------------------------------------- | | | HOUR-WEEK (HR-MM/DD): 08-01/02 09-01/02 10-01/02 11-01/02 12-01/02 13-01/02 14-01/02 15-01/02 16-01/02 CHANGE % | | | |-----------------------------------------------------------------------------------------------------------------------| | | | MESSAGE MANAGER ACTIVITY | | ------------------------ | | | | MQGET REQUESTS 165 165 113 165 49886 153480 150815 153531 178865 8303.03 % | | MQPUT REQUESTS 3 3 2 3 47718 147090 144515 147243 171412 3633.33 % | | MQPUT1 REQUESTS 3 3 2 3 3 3 3 2 3 --- | | MQOPEN REQUESTS 12 12 8 12 1211 3760 3701 3762 4368 6300.00 % | | MQCLOSE REQUESTS 12 12 8 12 1133 3520 3465 3521 4087 3958.33 % | | | |-----------------------------------------------------------------------------------------------------------------------| | | | BUFFER POOL 0 UTILIZATION | | ------------------------- | | | | AVERAGE BUFFERS IN POOL 50000 50000 50000 50000 50000 50000 50000 50000 50000 --- | | AVERAGE AVAIL. BUFFERS 49376 49376 49376 49376 49371 49366 49365 49364 49073 -0.61 % | | NO AVAILABLE BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | TOTAL GETS (NEW+CURRENT) 709 604 412 621 258897 796695 784886 796304 929486 998.17 % | | PAGE GETS(CURRENT PAGE) 708 603 412 620 236084 726463 715833 725998 847630 9621.75 % | | % GETS - NOT IN BUFFER 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.06% N.A. | | % PAGE READS TO DASD 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | PAGE UPDATES 23 19 11 19 165762 510604 502010 511204 594861 6252.17 % | | % PAGE UPDATES 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 99.99% 100.0% 100.0% --- | | SYNC. PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | SYNC PAGE PROCESSOR START 0 0 0 0 0 0 0 0 0 N.A. | | NO. OF PAGES TO DASD 0 0 0 0 0 0 1 0 0 N.A. | | | -------------------------------------------------------------------------------------------------------------------------
Hourly Performance Summary Report Page 2
14:50 Tuesday, mmm dd, yyyy C A CA MICS MQSeries Analyzer HOURLY PERFORMANCE SUMMARY FOR ZONE = 1 SYSTEM = XE44 MQM SUBSYSTEM = CSQ1 RUNDATE = mmm dd, yyyy ------------------------------------------------------------------------------------------------------------------------- | | | HOUR-WEEK (HR-MM/DD): 08-01/02 09-01/02 10-01/02 11-01/02 12-01/02 13-01/02 14-01/02 15-01/02 16-01/02 CHANGE % | | | |-----------------------------------------------------------------------------------------------------------------------| | | | BUFFER POOL 1 UTILIZATION | | ------------------------- | | | | AVERAGE BUFFERS IN POOL 1050 1050 1050 1050 1050 1050 1050 1050 1050 --- | | AVERAGE AVAIL. BUFFERS 979 978 978 977 976 976 975 975 974 -0.51 % | | NO AVAILABLE BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | TOTAL GETS (NEW+CURRENT) 367 363 246 363 406 483 486 362 507 38.15 % | | PAGE GETS(CURRENT PAGE) 366 363 245 363 405 483 485 362 506 38.25 % | | % GETS - NOT IN BUFFER 0.27% 0.00% 0.40% 0.00% 0.24% 0.00% 0.20% 0.00% 0.19% -25.93 % | | % PAGE READS TO DASD 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | PAGE UPDATES 6 3 5 3 6 3 7 2 6 --- | | % PAGE UPDATES 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 87.50% 100.0% 100.0% --- | | SYNC. PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | SYNC PAGE PROCESSOR START 0 0 0 0 0 0 0 0 0 N.A. | | NO. OF PAGES TO DASD 0 0 0 0 0 0 1 0 0 N.A. | | | |-----------------------------------------------------------------------------------------------------------------------| | | | BUFFER POOL 2 UTILIZATION | | ------------------------- | | | | AVERAGE BUFFERS IN POOL 1050 1050 1050 1050 1050 1050 1050 1050 1050 --- | | AVERAGE AVAIL. BUFFERS 1050 1050 1050 1050 1050 1049 1049 1049 1049 -0.10 % | | NO AVAILABLE BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | TOTAL GETS (NEW+CURRENT) 0 0 0 0 39 120 119 120 140 N.A. | | PAGE GETS(CURRENT PAGE) 0 0 0 0 39 120 119 120 140 N.A. | | % GETS - NOT IN BUFFER N.A. N.A. N.A. N.A. 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | % PAGE READS TO DASD N.A. N.A. N.A. N.A. 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | PAGE UPDATES 0 0 0 0 0 0 1 0 0 N.A. | | % PAGE UPDATES N.A. N.A. N.A. N.A. N.A. N.A. 50.00% N.A. N.A. N.A. | | SYNC. PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | SYNC PAGE PROCESSOR START 0 0 0 0 0 0 0 0 0 N.A. | | NO. OF PAGES TO DASD 0 0 0 0 0 0 1 0 0 N.A. | | | -------------------------------------------------------------------------------------------------------------------------
Hourly Performance Summary Report Page 3
14:50 Tuesday, mmm dd, yyyy C A CA MICS MQSeries Analyzer HOURLY PERFORMANCE SUMMARY FOR ZONE = 1 SYSTEM = XE44 MQM SUBSYSTEM = CSQ1 RUNDATE = mmm dd, yyyy ------------------------------------------------------------------------------------------------------------------------- | | | HOUR-WEEK (HR-MM/DD): 08-01/02 09-01/02 10-01/02 11-01/02 12-01/02 13-01/02 14-01/02 15-01/02 16-01/02 CHANGE % | | | | BUFFER POOL 3 UTILIZATION | | | | AVERAGE BUFFERS IN POOL 1050 1050 1050 1050 1050 1050 1050 1050 1050 --- | | AVERAGE AVAIL. BUFFERS 1050 1050 1050 1050 1050 1049 1049 1049 1049 -0.10 % | | NO AVAILABLE BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | TOTAL GETS (NEW+CURRENT) 0 0 0 0 39 120 119 120 140 N.A. | | PAGE GETS(CURRENT PAGE) 0 0 0 0 39 120 119 120 140 N.A. | | % GETS - NOT IN BUFFER N.A. N.A. N.A. N.A. 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | % PAGE READS TO DASD N.A. N.A. N.A. N.A. 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | PAGE UPDATES 0 0 0 0 0 0 1 0 0 N.A. | | % PAGE UPDATES N.A. N.A. N.A. N.A. N.A. N.A. 50.00% N.A. N.A. N.A. | | SYNC. PAGE WRITES 0 0 0 0 0 0 1 0 0 N.A. | | SYNC PAGE PROCESSOR START 0 0 0 0 0 0 0 0 0 N.A. | | NO. OF PAGES TO DASD 0 0 0 0 0 0 1 0 0 N.A. | | | | BUFFER POOL 4 UTILIZATION | | | | AVERAGE BUFFERS IN POOL 0 0 0 0 0 0 0 0 0 N.A. | | AVERAGE AVAIL. BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | NO AVAILABLE BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | TOTAL GETS (NEW+CURRENT) 0 0 0 0 0 0 0 0 0 N.A. | | PAGE GETS(CURRENT PAGE) 0 0 0 0 0 0 0 0 0 N.A. | | % GETS - NOT IN BUFFER 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | % PAGE READS TO DASD 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | PAGE WRITES 0 0 0 0 0 0 0 0 0 N.A. | | PAGE UPDATES 0 0 0 0 0 0 0 0 0 N.A. | | % PAGE UPDATES 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | SYNC. PAGE WRITES 0 0 0 0 0 0 0 0 0 N.A. | | SYNC PAGE PROCESSOR START 0 0 0 0 0 0 0 0 0 N.A. | | NO. OF PAGES TO DASD 0 0 0 0 0 0 0 0 0 N.A. | | | | LOG MANAGER STATISTICS | | | | TOTAL LOG WRITE REQUESTS 84 67 53 75 227 563 617 537 563 570.24 % | | % WRITE REQUESTS - WAIT 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% N.A. | | % WRITE REQUESTS - FORCE 1.19% 0.00% 0.00% 0.00% 0.00% 0.00% 0.16% 0.00% 0.00% N.A. | | TOTAL LOG READ REQUESTS 0 0 0 0 0 0 0 0 0 N.A. | | % READ LOG REQ IN BUFFER N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. | | % READ ACTIVE LOG DS N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. | | % READ ARCHIVE LOG DS N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. | | % READ DELAYED (MAXALLC) N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. N.A. | | WAIT-UNAVAILABLE BUFFERS 0 0 0 0 0 0 0 0 0 N.A. | | | | DATA MANAGER STATISTICS | | | | OBJECT_GET REQUESTS 6 6 4 6 553 1677 1658 1692 1959 2550.00 % | | OBJECT_LOCATE REQUESTS 39 39 26 39 2807 8632 8513 8652 10027 5610.26 % | | OBJECT_PUT REQUESTS 0 0 0 0 0 0 0 0 0 N.A. | | OBJECT_CREATE REQUESTS 0 0 0 0 1 0 0 0 1 N.A. | | OBJECT_DELETE REQUESTS 0 0 0 0 257 708 710 719 828 N.A. | -------------------------------------------------------------------------------------------------------------------------