MQSCSF - MQSeries Log Manager Write Analysis
The MQSCSF - MQSeries Log Manager Write Analysis uses measurements from the Log Manager Statistics File (MQSLMS). The Analysis then displays the relevant metrics for analyzing performance that is associated with LOG writes over the date and time ranges that you select.
micsrm140
The plot displays LOG writes for each Queue Manager based on the report summarization option that you specify.
The following
MICS
Analyzer for MQSeries elements are selected:Key elements
- SYSID
- - System Identifier
- MQMSSI
- - Queue Manager Name
- HOUR
- - Hour of Day
Data
elements
- LMSTNLWR
- - Total Number of Log Write Calls
- LMSWRW
- - Write Call Count - Wait
- LMSWRNW
- - Write Call Count - NWait
- LMSWRF
- - Write Call Count - Force
- LMSWTB
- - Wait Count For Unavailable Buffers
Note:
The label that is associated with the field DATE 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 MQSCSF, whose Catalog Group is PERFORM.
- Complete the MICF Execution panel.
- Complete the MQSeries Log Manager Write Analysis panel.The result displays on your terminal. For example, see the Weekly MQS Log Manager Write Analysis Report included below.
MQSeries Log Manager Write Analysis Panel
+----------------------------------------------------------------------+ |----------------- MQSeries Log Manager Write Analysis ----------------| | Command ===> | | | | Composing Inquiry: MQSCSF - MQS Log Manager Write 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) ===> ____ ____ ____ ____ ____ ____| | | +----------------------------------------------------------------------+
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 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 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.
Weekly MQS Log Manager Write Analysis Report
MICSMQSeries Analyzer Weekly MQS Log Manager Write Analysis 14:49 Tuesday, mmm dd, yyyy -------------------------------------- ZONE=1 SYSID=XE44 MQMSSI=CSQ1 START OF WEEK=yyyy/mm/dd -------------------------------------- Plot of LMSTNLWR*HOUR. Symbol used is 'T'. Plot of LMSWRW*HOUR. Symbol used is 'W'. Plot of LMSWRNW*HOUR. Symbol used is 'N'. Plot of LMSWRF*HOUR. Symbol used is 'F'. Plot of LMSWTB*HOUR. Symbol used is 'B'. | | 700 + | | | | T 600 + | T | T T o | T t | a 500 + l | | W | r | i 400 + t | e | | R | e 300 + q | u | e | s | T t 200 + s | | | | 100 + | T T | T T | | 0 + W W W W W W W W W | ---+------------+------------+------------+------------+------------+------------+------------+------------+-- 8 9 10 11 12 13 14 15 16 Note: 27 obs hidden. Hour of DayMICSMQS MQSCSF yymmmdd BASED ON Information Summarized by Hour Within Week