Previous Topic: 2.10.3 Standard Output

Next Topic: 2.10.3.2 Hourly System Usage by Product Reports

2.10.3.1 LPAR Product Consumption Report

 
 The LPAR Product Resource Consumption query analyzes BATMUG
 data collected from z/OS workloads.  It lets you produce a
 software inventory by vendor and LPAR.  To produce a general
 software inventory by LPAR, it is best to execute the LPAR
 Product Resource Consumption query against the MONTHS
 timespan.  The report summarizes the entire month's product
 usage by LPAR by product into a one-line-per-product-by-month
 report.
 
 To study product usage for the purpose of performance
 analysis or workload shifting, this query must be executed at
 the DAYS-by-Hour summarization level. This query will produce
 a report that tracks product LPAR utilization in CPU Time,
 Service Units(SUs), Millions of Service Units(MSUs), and as
 an MSU Hourly Rate.
 
 This report can be produced at multiple summarization levels.
 Dates and titles will be adjusted appropriately based on the
 timespan and summarization level chosen for the execution.
 After data has been collected for a time period, this
 summarization capability can be used to "drill down" to a
 specific time frame.
 
 By default, the report presents products for all vendors.
 Optionally, by specifying a vendor on the composition panel,
 you can produce a report for only the desired vendor. To
 obtain the specific vendor name to subset on, you can first
 run the query against all vendor products.  View the output
 and note the specific vendor name you want to further refine
 your query against. Set the vendor option field to the
 specific vendor you are interested in, and resubmit your
 query.
 
 By default, the report presents product usage summarized at
 the product-ID level.  Optionally, by modifying an execution
 panel field, the report will be summarized at the product-
 qualifier level.  Consider an example:
 
   o When reporting at the product-qualifier level, you can
     separate resource collection for different iterations of
     the same product (MUPROD) running on a single system.
     For example, your report will show all instances of
     IMS/ESA V9R1 batch and started tasks separately.
 
   o Conversely, when reporting at the product-ID level, all
     IMS/ESA V9R1 usage would be summarized at the product-ID
     level.
 
 Additionally, the LPAR Product Resource Consumption query
 provides the ability to produce the BATMUG Frequency Reports
 at either the product-ID or the product-qualifier level.  See
 section 2.10.3.2.1 below for details.
 
 A CSV file can be optionally created for later use by Q&R
 Workstation to generate charts and graphs.
 
 REPORT ELEMENTS
 
 Report Label                      File     Element
 ------------                      ----     -------
 Product Name                      BATMUG   MUGPROD
 Product Version                   BATMUG   MUGVER
 Product ID                        BATMUG   MUGID
 Product Qualifier                 BATMUG   MUGQUAL
 Owner/Vendor Name                 BATMUG   MUOWNER
 Product Usage Data Duration       BATMUG   MUGDUR
 Total Product CPU Time            BATMUG   MUGCPUTM
 Max Product CPU Time              BATMUG   MUGMXCPU
 
 
 LPAR PRODUCT CONSUMPTION REPORT
 
 To help you better understand the standard output produced
 by this query, definitions and calculations involved in
 producing the displayed variables follow:
 
 TOTAL        The total CPU time consumed by the product
 PRODUCT      over the reporting interval.
 USAGE:
 
 MAX          The maximum CPU time consumed by the product
 PRODUCT      over the reporting interval. If the report is
 USAGE:       by hour, this value will represent the maximum
              CPU time consumed for that hour.
 
 TOTAL        The number of service units consumed by the
 PRODUCT      product over the reporting interval.
 USAGE IN
 SUs:         PRODSUTO =  MUGCPUTM * SUCONFA
 
              MUGCPUTM is the sum of TCB and SRB CPU time, in
                       hundredths of a second, as recorded by
                       the Measured Usage License Charging
                       (MULC) subsystem.
 
              SUCONFA  is the physical CPU adjustment factor
                       used to convert CPU times to SUs.
 
                       The CPU adjustment factor is calculated
                       by multiplying the CPU Capability Adj.
                       Factor for N CPUs (CPCMAFxx), the CPU
                       Capability (CPCCPUCB), and the
                       Configured CPU Count (CPCCFGCT). All
                       are from the SMF type 89 (Usage Data)
                       record.
 
 MAX          The maximum number of service units consumed by
 PRODUCT      the product over the reporting interval. If
 USAGE IN     reporting by hour, this value will represent
 SUs:         the maximum SUs consumed for that hour.
 
 TOTAL        The number of service units (expressed in
 PRODUCT      MSUs) consumed by the product for the
 USAGE IN     reporting interval.
 MSUs:
 
 MAX          The number of service units (expressed in
 PRODUCT      MSUs) consumed by the product for the
 USAGE IN     reporting interval. If reporting by the hour,
 MSUs:        this value will represent the maximum MSUs
              consumed for that hour.
 
 PRODUCT      Contains the product's hourly MSU consumption
 HOURLY       rate.
 MSU RATE:
                         MUGCPUTM *  SUCONFA  * 3600
              PRDMSUR8 = ---------------------------
                              DURATION * 1000000
 
              MUGCPUTM is the sum of TCB and SRB CPU time, in
                       hundredths of a second, as recorded by
                       the Measured Usage License Charging
                       (MULC) subsystem.
 
              SUCONFA  is the physical CPU adjustment factor
                       used to convert CPU times to SUs.
 
                       The CPU adjustment factor is calculated
                       by multiplying the CPU Capability Adj.
                       Factor for N CPUs (CPCMAFxx), the CPU
                       Capability (CPCCPUCB), and the
                       Configured CPU Count (CPCCFGCT). All
                       are from the SMF type 89 (Usage Data)
                       record.
 
              DURATION is the length of the SMF recording
                       interval.
 

L P A R P r o d u c t C o n s u m p t i o n R e p o r t Page 001 -------- Report Summary: Information Summarized By Hour Within Day Report Range: 18AUGyy:10:59:37 thru 19AUGyy:12:59:37 Sysplex Name: PLEXC1 SYSID: SA31 DAY: yy-mm-dd Product Summary: Product Name|Version|ID +----------------------------------------------------------------------------------------------------------------------------------+ | Hour: 10 Total Max Total Max Total Max Product | | Product Product Product Product Product Product Hourly | | Product Product Product Owner/Vendor CPU Time CPU Time Usage Usage Usage Usage MSU | | Name Version Id Name (TCB+SRB) (TCB+SRB) (SUs) (SUs) (MSUs) (MSUs) Rate | | ---------------- -------- -------- --------------- ------------ ------------ ------- ------- ------- ------- ------- | | z/OS 01.08.00 5645-001 IBM CORP 0:00:54.1 0:00:30.3 708.7k 397.1k 0.71 0.40 0.71 | | CICS V2 R2.0 5697-E93 IBM CORP 0:00:00.8 0:00:00.4 11.0k 5.5k 0.01 0.01 0.01 | | CICS V2 R3.0 5697-E93 IBM CORP 0:00:01.6 0:00:00.8 20.5k 10.3k 0.02 0.01 0.02 | | CICS V3 R1.0 5655-M15 IBM CORP 0:00:03.6 0:00:01.8 47.5k 23.9k 0.05 0.02 0.05 | | CICS V3 R2.0 5655-M15 IBM CORP 0:00:01.9 0:00:01.0 25.1k 12.7k 0.03 0.01 0.03 | | DB2 7.1.0 5675-DB2 IBM CORP 0:00:05.3 0:00:02.7 69.2k 35.1k 0.07 0.04 0.07 | | DB2 8.1.0 5625-DB2 IBM CORP 0:00:06.0 0:00:03.0 78.1k 39.5k 0.08 0.04 0.08 | | DB2 9.1.0 5635-DB2 IBM CORP 0:00:01.0 0:00:00.6 13.5k 7.3k 0.01 0.01 0.01 | | DB2 9.1.0 5635-DB2 IBM CORP 0:00:01.0 0:00:00.6 13.5k 7.3k 0.01 0.01 0.01 | | IMS/ESA V9R1 5655-J38 IBM CORP 0:00:00.7 0:00:00.4 9.3k 4.8k 0.01 0.00 0.01 | | MQM MVS/ESA V6 5655-L82 IBM CORP 0:00:13.7 0:00:03.2 178.9k 42.0k 0.18 0.04 0.18 | +----------------------------------------------------------------------------------------------------------------------------------+ | Hour: 11 Total Max Total Max Total Max Product | | Product Product Product Product Product Product Hourly | | Product Product Product Owner/Vendor CPU Time CPU Time Usage Usage Usage Usage MSU | | Name Version Id Name (TCB+SRB) (TCB+SRB) (SUs) (SUs) (MSUs) (MSUs) Rate | | ---------------- -------- -------- --------------- ------------ ------------ ------- ------- ------- ------- ------- | | z/OS 01.08.00 5645-001 IBM CORP 0:00:48.2 0:00:25.5 630.5k 333.8k 0.63 0.33 0.63 | | CICS V2 R2.0 5697-E93 IBM CORP 0:00:00.8 0:00:00.4 11.1k 5.6k 0.01 0.01 0.01 | | CICS V2 R3.0 5697-E93 IBM CORP 0:00:01.6 0:00:00.8 20.9k 10.6k 0.02 0.01 0.02 | | CICS V3 R1.0 5655-M15 IBM CORP 0:00:03.7 0:00:01.8 48.2k 24.2k 0.05 0.02 0.05 | | CICS V3 R2.0 5655-M15 IBM CORP 0:00:02.0 0:00:01.0 26.0k 13.1k 0.03 0.01 0.03 | | DB2 7.1.0 5675-DB2 IBM CORP 0:00:05.3 0:00:02.7 68.8k 34.8k 0.07 0.03 0.07 | | DB2 8.1.0 5625-DB2 IBM CORP 0:00:05.7 0:00:03.0 75.0k 39.0k 0.07 0.04 0.07 | | DB2 9.1.0 5635-DB2 IBM CORP 0:00:01.0 0:00:00.5 13.3k 7.2k 0.01 0.01 0.01 | | IMS/ESA V9R1 5655-J38 IBM CORP 0:00:00.7 0:00:00.3 8.9k 4.6k 0.01 0.00 0.01 | | MQM MVS/ESA V6 5655-L82 IBM CORP 0:00:15.4 0:00:03.9 201.4k 50.9k 0.20 0.05 0.20 | +----------------------------------------------------------------------------------------------------------------------------------+ | Hour: 12 Total Max Total Max Total Max Product | | Product Product Product Product Product Product Hourly | | Product Product Product Owner/Vendor CPU Time CPU Time Usage Usage Usage Usage MSU | | Name Version Id Name (TCB+SRB) (TCB+SRB) (SUs) (SUs) (MSUs) (MSUs) Rate | | ---------------- -------- -------- --------------- ------------ ------------ ------- ------- ------- ------- ------- | | z/OS 01.08.00 5645-001 IBM CORP 0:06:02.3 0:05:07.5 4.7m 4.0m 4.74 4.02 4.74 | | CICS V2 R2.0 5697-E93 IBM CORP 0:00:00.8 0:00:00.4 10.9k 5.5k 0.01 0.01 0.01 | | CICS V2 R3.0 5697-E93 IBM CORP 0:00:01.6 0:00:00.8 20.4k 10.3k 0.02 0.01 0.02 | | CICS V3 R1.0 5655-M15 IBM CORP 0:00:03.6 0:00:01.8 47.0k 23.9k 0.05 0.02 0.05 | | CICS V3 R2.0 5655-M15 IBM CORP 0:00:02.0 0:00:01.0 25.8k 13.1k 0.03 0.01 0.03 | | DB2 7.1.0 5675-DB2 IBM CORP 0:00:05.2 0:00:02.7 68.7k 35.6k 0.07 0.04 0.07 | | DB2 8.1.0 5625-DB2 IBM CORP 0:00:05.8 0:00:03.0 75.4k 38.9k 0.08 0.04 0.08 | | DB2 9.1.0 5635-DB2 IBM CORP 0:00:01.0 0:00:00.5 13.7k 7.2k 0.01 0.01 0.01 | | IMS/ESA V9R1 5655-J38 IBM CORP 0:00:00.7 0:00:00.3 8.9k 4.4k 0.01 0.00 0.01 | +----------------------------------------------------------------------------------------------------------------------------------+

 
 Figure 2-229.  Sample LPAR Product Consumption Report