Go to Home Page
Questions?
Call 1-800-572-5517
 
  Go to Home Page  
  See all products
  See price schedules
  See manuals, tutorials, articles
  Download a free 30-day trial
  See user testimonials
  About Pacific Systems Group
 
 
SMF Tools
  See SMF Record Layouts
  See Sample SMF Reports
  Learn How to Export SMF Data
  Download Free SMF Reporting Software (30 days)
 
One of the greatest SMF record parsing programming languages I've ever seen. Chief, Large Systems Services Branch, NIH
  Choose Spectrum Writer to add 4GL to your product
  Report Writer Speedup Tips Article

Sample Report from SMF 115 Subtype 2 Records
Showing Statistics on Buffer Pool Management

It's easy to report on SMF data!
 

SMF Spectrum Writer
We have a low-cost 4GL report writer especially for SMF files. It's called Spectrum SMF Writer.

Spectrum SMF Writer handles the difficult SMF record parsing for you automatically. You just specify which fields you want to see.

Spectrum SMF Writer also converts the arcane date and time fields and reformats them into an attractive report.

Plus Spectrum SMF Writer even exports SMF data as comma delimited files to use on your PC.
 
Try It FREE Now!


The sample SMF report below was created with Spectrum SMF Writer, the low-cost 4GL SMF report writer.

In this report, we read the SMF file and select just the type 115 subtype 2 Websphere MQ performance statistics records. (See SMF 115 record layout.) We use all of the the multiply recurring QPST (Buffer Pool Management) sections from each SMF record to show statistics for each subpool during the period just ended.

The statistics include number of buffer pools, number of stealable buffers, lowest number of stealable buffers during the period, actual number of buffer steals, number of get page old and get page new requests, count of DASD read and write ops, pages written to DASD, etc.

All of this with just a few lines of code!
Why not install a Spectrum SMF Writer trial right now and start making your own SMF reports!

These Spectrum SMF Writer Statements:

INPUT:  SMF115                                                     
        NORMWHEN(SMF115RTY=115 AND SMF115STF=2 AND SMF115_QPSTN>0) 
        NORMSMF(SMF115_QPSTO)                                      
                                                                   
INCLUDEIF: SMF115RTY = 115 AND SMF115STF = 2                       
                                                                   
COLUMNS:                                                           
     SMF115SID('Z/OS|SUB|SYSTEM')                                  
     SMF115TME('PERIOD|ENDING' TPIC'Z9:99:99')                     
     QPSTPOOL('BUFFER|POOL|NUMBER' 6)                              
     QPSTNBUF('# OF|BUFFERS|IN POOL' 8)                            
     QPSTCBSL('LOWEST|# OF|STEALABLE|BUFFERS' 9)                   
     QPSTCBS('# OF|STEALABLE|BUFFERS' 9)                           
     QPSTSTL('# OF|BUFFER|STEALS' 9)                               
     QPSTGETP('# OF|GET PAGE|(OLD)|REQUESTS' 11)                   
     QPSTGETN('# OF|GET PAGE|(NEW)|REQUESTS' 11)                   
     QPSTRIO('# OF|DASD|READ|OPS' 6)                               
     QPSTSTW('# OF|SET WRITE|INTENT|REQUESTS' 9)                   
     QPSTTPW('# OF|PAGES|WRITTEN|TO DASD' 9)                       
     QPSTWIO('# OF|DASD|WRITE|OPS' 6)                              
                                                                   
TITLE: 'SMF 115 - WEBSPHERE MQ PERFORMANCE REPORT'                 
TITLE: 'BUFFER POOL MANAGER STATISTICS'                            

 

Produce This SMF Report:


                                           SMF 115 - WEBSPHERE MQ PERFORMANCE REPORT

                                                 BUFFER POOL MANAGER STATISTICS

                                  LOWEST                          # OF        # OF        # OF        # OF       # OF     # OF
  Z/OS           BUFFER   # OF     # OF      # OF      # OF     GET PAGE    GET PAGE      DASD      SET WRITE    PAGES    DASD
  SUB    PERIOD   POOL  BUFFERS  STEALABLE STEALABLE  BUFFER      (OLD)       (NEW)       READ       INTENT     WRITTEN  WRITE
 SYSTEM  ENDING  NUMBER IN POOL   BUFFERS   BUFFERS   STEALS    REQUESTS    REQUESTS       OPS      REQUESTS    TO DASD   OPS
 ______ ________ ______ ________ _________ _________ _________ ___________ ___________ ___________ ___________ _________ ______

  ZSA   11:00:07      0   50,000    49,618    49,943         0     833,658      26,025           0     736,158       386    112
  ZSA   11:00:07      1   20,000    17,424    18,457         0   1,318,813     507,094           0   1,016,252     2,518    689
  ZSA   11:00:07      2   50,000    49,990    49,993         0       2,962         528           0       2,962        14     14
  ZSA   11:00:07      3   20,000    19,830    19,885         0     198,242       5,373           0      56,514       144     41
  ZSA   11:00:07      4        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07      5        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07      6        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07      7        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07      8        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07      9        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07     10        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07     11        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07     12        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07     13        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07     14        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:07     15        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36      0   50,000    49,972    49,972         0          38           0           0          28         0      0
  ZSA   11:00:36      1   20,000    19,999    19,999         0           0           0           0           0         0      0
  ZSA   11:00:36      2   50,000    49,995    49,995         0           5           1           0           5         0      0
  ZSA   11:00:36      3   20,000    19,992    19,992         0          20           4           0          20         0      0
  ZSA   11:00:36      4        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36      5        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36      6        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36      7        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36      8        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36      9        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36     10        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36     11        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36     12        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36     13        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36     14        0         0         0         0           0           0           0           0         0      0
  ZSA   11:00:36     15        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43      0    7,000     6,945     6,947         0     944,557      20,985           0     888,051       102     36
  ZSC   11:24:43      1    5,000     4,997     4,997         0          12           0           0          12        12     12
  ZSC   11:24:43      2   80,000    21,100    26,499         0   1,143,307   1,222,176           0   1,781,528   107,246 26,832
  ZSC   11:24:43      3    5,000     4,871     4,917 3,699,704 226,849,650      22,659   3,698,301     179,207       230     66
  ZSC   11:24:43      4        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43      5        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43      6        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43      7        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43      8        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43      9        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43     10        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43     11        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43     12        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43     13        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43     14        0         0         0         0           0           0           0           0         0      0
  ZSC   11:24:43     15        0         0         0         0           0           0           0           0         0      0
 
 *** GRAND TOTAL (    48 ITEMS)
                    360  377,000   314,733   321,596 3,699,704 231,291,264   1,804,845   3,698,301   4,660,737   110,652 27,802


See Other Sample SMF Reports
Copyright 2017.
Pacific Systems Group.
All rights reserved.


Spectrum Writer 4GL - the economical alternative to SAS, Easytrieve, DYL-280...

Home | Products | Prices | Documentation | 30-Day Trials | Customer Reviews | Company | FAQ | Sample Reports | SMF Records
Send Your Comments or Questions