MQSCSB - MQSeries Page Get Analysis

The MQSCSB - MQSeries Page Get Analysis uses measurements from the Buffer Manager Statistics File (MQSBMS). The Analysis then displays an overall view of the page get activity over the date and/or time ranges that you select.
micsrm140
The plot displays the page gets for each Queue Manager based on the report summarization options you specify.
The following
MICS
Analyzer for MQSeries elements are selected:
Key elements
SYSID
- System Identifier
MQMSSI
- Queue Manager Name
BMSPOOL
- Buffer Pool ID
HOUR
- Hour Of Day
Data elements
BMSGETN
- Page Get Calls For New or Empty Page
BMSGETP
- Page Get Calls For Current Page Content
BMSRIO
- Page Read DASD Operations
BMSSTL
- Page Get Calls Not Found In Buffer
BMSGETN + BMSGETP
- Total Get Calls (TOTGETS)
Note:
The label that is associated with the field DATE varies based on the timespan used.
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 MQSCSB, whose Catalog Group is PERFORM.
  5. Complete the MICF Execution panel.
  6. Complete the MQSeries Page Get Analysis panel.
    The result displays on your terminal. For example, see the Weekly MQS Page Get Analysis Report below.
MQSeries Page Get Analysis Panel
+----------------------------------------------------------------------+ |------------------- MQSeries Page Get Analysis ---------------------| | Command ===> | | | | Composing Inquiry: MQSCSB - MQS Page Get Analysis | | | | Database ===> _________________________________________ | | Cycle(s) ===> __ - __ | | Timespan ===> ______ (DETAIL/DAYS/WEEKS/MONTHS) | | Plot by hour if timespan is DAYS or WEEKS ===> _ (Y/N) | | Generate a plot for each value of Zone ===> _ (Y/N) | | Generate color graphic plots ===> _ (Y/N) | | Generate CSV Extract for Query and Reporting ===> _ (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)
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 hourly, DAILY, or WEEKLY levels. 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 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.
Generate color graphic plots
(Required) Defaults to N (No). Specify Y (Yes) to generate color graphics plots. SAS/GRAPH software is a prerequisite for color graphics. When set to No standard SAS plots and graphs are produced (non-color, line formats).
Generate CSV Extract for Query and Reporting
(Required) Defaults to N (No). Specify Y (Yes) to generate an extract CSV file for subsequent use in
MICS
Query and Reporting. This option is only valid when
MICS
Query and Reporting is installed.
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 not 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.
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.

Weekly MQS Page Get Analysis Report

MICS
MQSeries Analyzer Weekly MQS Page Get Analysis 14:48 Tuesday, mmm dd, yyyy --------------------------------- ZONE=1 SYSID=XE44 MQMSSI=CSQ1 BMSPOOL=0 START OF WEEK=yyyy/mm/dd --------------------------------- Plot of TOTGETS*HOUR. Symbol used is 'T'. Plot of BMSGETN*HOUR. Symbol used is 'N'. Plot of BMSGETP*HOUR. Symbol used is 'P'. Plot of BMSRIO*HOUR. Symbol used is 'R'. Plot of BMSSTL*HOUR. Symbol used is 'S'. | | T 1000000 + o | t | T a | l | | P G 800000 + T T T e | t | P P | P R | e | q 600000 + u | e | s | t | s | 400000 + ( | G | E | T | T P | P + 200000 + G | E | T | N | N N N N ) | N 0 + T T T T R R R R R | ---+------------+------------+------------+------------+------------+------------+------------+------------+-- 8 9 10 11 12 13 14 15 16 Hour of Day NOTE: 21 obs hidden.
MICS
MQS MQSCSB yymmmdd BASED ON Information Summarized by Hour Within Week