MQSSL1 - MQSeries Buffer Pool Summary
The MQSSL1 - MQSeries Buffer Pool Summary uses measurements from the Buffer Manager Statistics File (MQSBMS). The Summary then displays an overall view of the utilization and activity for each of the selected Buffer Pools for the date and time ranges you select.
micsrm140
Each report displays categorized details about configuration and utilization. The report categories and element 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 percent increase or decrease over the time periods from the report page.
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.
The following table displays the relationship between report labels and
MICS database
source elements for each buffer pool category.Report Label File Element ------------ ---- ------- AVERAGE BUFFERS IN POOL MQSBMS BMSAVBUF AVERAGE AVAIL. BUFFERS MQSBMS BMSAVAVB MINIMUM BUFFERS IN POOL MQSBMS BMSMNBUF MINIMUM AVAIL. BUFFERS MQSBMS BMSMNAVB NO AVAILABLE BUFFERS MQSBMS BMSSOS TOTAL GETS (NEW+CURRENT) MQSBMS BMSTNGET % REQUESTS NEW/EMPTY PAGE MQSBMS BMSPCNP PAGE GETS(CURRENT PAGE) MQSBMS BMSGETP % GETS - NOT IN BUFFER MQSBMS BMSPCSTL % PAGE READS TO DASD MQSBMS BMSPCRIO PAGE WRITES MQSBMS BMSWIO PAGE UPDATES MQSBMS BMSSTW % PAGE UPDATES MQSBMS BMSPCSTW ASYNC WRITE PROCESSES MQSBMS BMSDWT SYNC. PAGE WRITES MQSBMS BMSIMW SYNC PAGE PROCESSOR START MQSBMS BMSDMC NO. OF PAGES TO DASD MQSBMS BMSTPW
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 2,MICS Information Center Facility(MICF).
- Select option 2, Database Inquiries.
- Select MQSSL1, whose Catalog Group is PERFORM.
- Complete the MQSeries Buffer Pool Summary panel.The result displays on your terminal. For example, see the Hourly Buffer Pool Summary Report included below.
MQSeries Buffer Pool Summary Panel
+----------------------------------------------------------------------+ |------------------ MQSeries Buffer Pool Summary --------------------| | Command ===> | | | | Composing Inquiry: MQSSL1 - MQSeries Buffer Pool Summary | | | | 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 ===> ____ ____ ____ ____ ____ ____ | | 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 the 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 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 is 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 ate 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 Buffer Pool Summary Report Page 1
14:49 Tuesday, mmm dd, yyyy C AMICSMQSeries Analyzer HOURLY BUFFER POOL 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 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 % | | MINIMUM BUFFERS 50000 50000 50000 50000 50000 50000 50000 50000 50000 --- | | MINIMUM AVAIL. BUFFERS 49376 49376 49376 49376 49366 49364 49364 49363 48780 -1.21 % | | 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 % | | % REQUESTS NEW/EMPTY PAGE 0.14% 0.16% 0.00% 0.16% 8.81% 8.81% 8.79% 8.82% 8.80% 6192.86 % | | 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% --- | | ASYNC WRITE PROCESSES 0 0 0 0 0 0 0 0 0 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 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 % | | MINIMUM BUFFERS 1050 1050 1050 1050 1050 1050 1050 1050 1050 --- | | MINIMUM AVAIL. BUFFERS 978 978 977 977 976 976 975 975 974 -0.41 % | | 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 % | | % REQUESTS NEW/EMPTY PAGE 0.27% 0.00% 0.40% 0.00% 0.24% 0.00% 0.20% 0.00% 0.19% -25.93 % | | 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% --- | | ASYNC WRITE PROCESSES 0 0 0 0 0 0 0 0 0 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 Buffer Pool Summary Report Page 2
C AMICSMQSeries Analyzer HOURLY BUFFER POOL 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 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 % | | MINIMUM BUFFERS 1050 1050 1050 1050 1050 1050 1050 1050 1050 --- | | MINIMUM AVAIL. BUFFERS 1050 1050 1050 1050 1049 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. | | % REQUESTS NEW/EMPTY PAGE N.A. N.A. N.A. N.A. 0.00% 0.00% 0.00% 0.00% 0.00% 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. | | ASYNC WRITE PROCESSES 0 0 0 0 0 0 0 0 0 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 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 % | | MINIMUM BUFFERS 1050 1050 1050 1050 1050 1050 1050 1050 1050 --- | | MINIMUM AVAIL. BUFFERS 1050 1050 1050 1050 1049 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. | | % REQUESTS NEW/EMPTY PAGE N.A. N.A. N.A. N.A. 0.00% 0.00% 0.00% 0.00% 0.00% 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. | | ASYNC WRITE PROCESSES 0 0 0 0 0 0 0 0 0 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. | | | -------------------------------------------------------------------------------------------------------------------------