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
Spectrum SMF Writer - Low-Cost 4GL Report Writer for SMF Files.

Sample RMF Processor Activity Report from SMF 70 Records

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 reports below were created with Spectrum SMF Writer, the low-cost 4GL SMF report writer.

It reads as input the SMF file and selects just the type 70 subtype 1 (RMF Processor Activity) records. (See SMF 70 record layout.)

These records have a complex layout. Each record contains a variable number of LPAR sections, one for each LPAR. Furthermore, there are a variable number of Logical Processors sections for each of those LPAR sections. However, the logical processor sections (for all LPARS) are all located together -- they are not physically near their owning LPAR section.

Nevertheless, Spectrum SMF Writer easily handles these records so you quickly create powerful custom reports from the RMF data. We use nested NORMALIZE parms on the INPUT statement to process each Logical Processor that exists within each Logical Partition within the record. We sort the data by LPAR name and then by logical processor address.

We have formatted the first report to reflect this hierarchical layout of the SMF records. For each LPAR, we print a header containing ID info, as well as some info about the physical CPU. Below that are each of the processors for that LPAR. These detail processor report lines show the percentage of the RMF reporting interval for which the processor was: 1) online, 2) waiting, 3) effectively dispatched and 4) processor dispatched. Those LPARS with no defined processors are omitted from this report.

A second report (defined used the NEWOUT statement) lists just those LPARS that have no processors. In this report we show only data from the LPAR section. (Not the processor section, since they have none.)

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:

OPTION: MAXNORMDUMP(0)  /*SUPPRESS DUMPS FOR LPARS WITHOUT PROCESSORS*/

************************************************************************
*  THE INPUT WILL BE 1 LOGICAL SMF 70-1 REC FOR EACH LPAR/PROC COMBO   *
************************************************************************
INPUT:  SMF70
  NORM(SMF70_PRSMPD_SEGMENT)
  NORM(SMF70_PRSMLPD_SEGMENT)

************************************************************************
*  INCLUDE ALL 70-1 LPAR SECTIONS THAT HAVE AT LEAST 1 PROCESSOR       *
************************************************************************
INCLUDEIF: SMF70RTY=70 AND SMF70STY=1      /*INCLUDE SMF 70 SUBTYPE 1 */
       AND SMF70BDN > 0      /* ONLY IF LPAR HAS AT LEAST 1 PROCESSOR */
       AND SMF70ONT > 00:00:00  /* ONLY IF LPAR WAS "ACTIVE" IN PERIOD*/

************************************************************************
*  COMPUTE SOME WORK FIELDS (FOR SORTING/BREAKING AND FOR DISPLAY)     *
************************************************************************
COMP: PARTITION      = #FORMAT(SMF70LPN 3) + ' - ' + SMF70LPM
COMP: SORT_PARTITION = SMF70SNM + PARTITION

COMP: SORT_DATE_TIME = #FORMAT(SMF70DTE YYYYMMDD) +
                       #FORMAT(SMF70TME HHMMSS)

************************************************************************
*  SORT AND PAGE-BREAK ON DATE/TIME. FURTHER ON PARTITION AND PROCESSOR*
************************************************************************
SORT: SORT_DATE_TIME                  /* INTERVAL  */
      SORT_PARTITION(PAGE)            /* PARTITION */
      SMF70CIN                        /* CPU NAME          */
      SMF70VPA                        /* LOGICAL PROCESSOR */

************************************************************************
*  THE HEADING FOR EACH CONTROL GROUP SHOWS DATA FROM LPAR SECTION.    *
*  (NUMBERS IN PARENTHESES SPECIFY THE PRINT-LINE SIZE OF AN ITEM.)    *
************************************************************************
BREAK: SORT_PARTITION
       TOTAL('TOTAL')

************************************************************************
*  COLUMNS STMT LISTS DETAIL DATA TO PRINT FROM THE PROCESSOR SECTIONS.*
************************************************************************
COLUMNS:
      SMF70VPA('LOGL|PROC|ADDR' HEX NOACC)
      SMF70BPS('WEIGHT|FACTOR' 6)
      SMF70CIN(4 'CPU|NAME')
    2 '|'
      SMF70ONT('ONLINE|TIME')
      SMF70ONT_PCT('PCT|ONLINE')
    2 '|'
      SMF70WST('WAIT|TIME')
      SMF70WST_PCT('PCT|WAIT' 6)
    2 '|'
      SMF70EDT('EFFECT.|DISPATCH|TIME')
      SMF70EDT_PCT('PCT|EFF|DISP')
    2 '|'
       SMF70PDT('PROC|DISP|TIME')
       SMF70PDT_PCT('PCT|PROC|DISP' 6)

************************************************************************
* REPORT TITLES                                                        *
*(SLASHES SEPARATE THE LEFT (EMPTY HERE), CENTER AND RIGHT TITLE PARTS)*
************************************************************************
TITLE: 'RUN DATE:' #DATE
       / 'SMF 70 - PROCESSOR PERCENT TIME ONLINE REPORT'
       / 'PAGE' #PAGENUM

TITLE:    ' ' /
TITLE:    'PARTITION INFO' /
TITLE:    '==============' /
TITLE:    'SYSTEM:' SMF70SNM /
TITLE:    'PARTITION (NUM-NAME):' SMF70LPN(3) '-' SMF70LPM /
TITLE:    'PROCESSOR FAMILY AND MODEL:' SMF70MOD(HEX) SMF70MDL(5)
          'SERIAL' SMF70SER(HEX) /
TITLE:    'PROCESSOR CAPACITY:' 0 SMF70WLA(6) '(MSU''S)' /
TITLE:    'LPAR CLUSTER:' SMF70SPN
          'SYSTEM NAME:' SMF70STN /
TITLE:    'LPAR DEFINED CAPACITY LIMIT:' 0 SMF70MSU(6) '(MSU''S)' /
TITLE:    'STORAGE:' SMF70CSF(7) 'MB' /
TITLE:    'PROCESSORS:' SMF70BDN(4) /
TITLE:    ' ' /
TITLE:    'LOGICAL PROCESSOR INFO (FOR ACTIVE PROCESSORS)' /
TITLE:    'FOR' SMF70INT_TIME 'MINUTE INTERVAL ENDING' SMF70DTE
          'AT' SMF70TME /

TITLE:    ' ' /
************************************************************************
* BEGINNING OF SECOND REPORT DEFINITION.                               *
* THE SAME INPUT STMT IS USED. ALSO ALL COMPUTED FIELDS ARE AVAILABLE. *
************************************************************************
NEWOUT:

************************************************************************
* INCLUDE ONLY THE 70-1 LPARS WITH NO PROCESSORS IN 2ND REPORT         *
************************************************************************
INCLUDEIF: SMF70RTY =  70 AND SMF70STY=1          /*JUST INCL SMF 70-1*/
           AND SMF70BDN=0        /*JUST INCLUDE PARTITIONS WITH 0 CPUS*/

************************************************************************
*  SORT 2ND REPORT AND ON DATE/TIME AND PARTITION. NO CONTROL BREAKS.  *
************************************************************************
SORT: SORT_DATE_TIME                  /* INTERVAL  */
      SORT_PARTITION                  /* PARTITION */

************************************************************************
*  NAME THE DATA ITEMS TO SHOW IN THE 2ND REPORT                       *
************************************************************************
COLUMNS:
      SMF70SNM('SYSTEM')
      PARTITION('PARTITION|NUM - NAME')
      SMF70MOD('FAMILY')
      SMF70MDL('MODEL' 5)
      SMF70SER('SERIAL|NUMBER' HEX)
      SMF70WLA('CAPACITY|(MSU''S)')
*     SMF70SPN('LPAR|CLUSTER')
*     SMF70STN('SYSTEM|NAME')
*     SMF70MSU('DEFINED|CAPACITY|LIMIT|(MSU''S)')
*     SMF70BDN('NUM|PROCESSORS')

************************************************************************
*  TITLES FRF SECOND REPORT                                            *
************************************************************************
TITLE: / 'SMF 70 REPORT - PARTITIONS WITH NO CPU''S' / 'RUN DATE:' #DATE

TITLE: / 'FOR' SMF70OIL 'MINUTE INTERVAL ENDING' SMF70DTE 'AT' SMF70TME
       / 'PAGE' #PAGENUM
                                                                        

 

Produce These 2 SMF Reports.
Report 1:


 RUN DATE: 07/02/20       SMF 70 - PROCESSOR PERCENT TIME ONLINE REPORT                PAGE    5

 PARTITION INFO
 ==============
 SYSTEM: TN01
 PARTITION (NUM-NAME):   7 - ZU801IDO
 PROCESSOR FAMILY AND MODEL: 2817 611   SERIAL 083F96
 PROCESSOR CAPACITY:   843 (MSU'S)
 LPAR CLUSTER: DPLEX1   SYSTEM NAME: TD01
 LPAR DEFINED CAPACITY LIMIT:     0 (MSU'S)
 STORAGE:  28,672 MB
 PROCESSORS:   54

 LOGICAL PROCESSOR INFO (FOR ACTIVE PROCESSORS)
 FOR 14:59.957 MINUTE INTERVAL ENDING 10/25/12 AT 14:14:00.04

 LOGL                                                         EFFECT.   PCT       PROC     PCT
 PROC WEIGHT CPU      ONLINE    PCT        WAIT     PCT      DISPATCH   EFF       DISP     PROC
 ADDR FACTOR NAME      TIME    ONLINE      TIME     WAIT       TIME    DISP       TIME     DISP
 ____ ______ ____  _ _________ ______  _ _________ ______  _ _________ _____  _ _________ ______

 0000    187       | 14:59.958 100.0%  |  8:08.826  54.3%  |  6:46.144 45.1%  |  6:49.136  45.5%
 0001    187       | 14:59.958 100.0%  |  8:29.915  56.7%  |  6:18.582 42.1%  |  6:20.414  42.3%
 0002    187       | 14:59.958 100.0%  | 13:26.689  89.6%  |  1:28.331  9.8%  |  1:28.569   9.8%
 0003    187       | 14:59.958 100.0%  | 14:11.978  94.7%  |  0:43.805  4.9%  |  0:43.933   4.9%
 0004    187       | 14:59.958 100.0%  | 14:28.398  96.5%  |  0:28.193  3.1%  |  0:28.296   3.1%
 0005    187       | 14:59.958 100.0%  | 14:38.226  97.6%  |  0:20.609  2.3%  |  0:20.682   2.3%
 0006    187       | 14:59.958 100.0%  | 14:59.933 100.0%  |  0:00.024  0.0%  |  0:00.025   0.0%
 0007    187       | 14:59.958 100.0%  | 14:59.933 100.0%  |  0:00.024  0.0%  |  0:00.024   0.0%
 TOTAL                         100.0%               86.2%              13.4%               13.5%




 RUN DATE: 07/02/20       SMF 70 - PROCESSOR PERCENT TIME ONLINE REPORT                PAGE    6

 PARTITION INFO
 ==============
 SYSTEM: TN01
 PARTITION (NUM-NAME):   8 - ZU802IDO
 PROCESSOR FAMILY AND MODEL: 2817 611   SERIAL 083F96
 PROCESSOR CAPACITY:   843 (MSU'S)
 LPAR CLUSTER: EPLEX1   SYSTEM NAME: TE02
 LPAR DEFINED CAPACITY LIMIT:     0 (MSU'S)
 STORAGE:  28,672 MB
 PROCESSORS:   54

 LOGICAL PROCESSOR INFO (FOR ACTIVE PROCESSORS)
 FOR 14:59.957 MINUTE INTERVAL ENDING 10/25/12 AT 14:14:00.04

 LOGL                                                         EFFECT.   PCT       PROC     PCT
 PROC WEIGHT CPU      ONLINE    PCT        WAIT     PCT      DISPATCH   EFF       DISP     PROC
 ADDR FACTOR NAME      TIME    ONLINE      TIME     WAIT       TIME    DISP       TIME     DISP
 ____ ______ ____  _ _________ ______  _ _________ ______  _ _________ _____  _ _________ ______

 0000    237       | 14:59.958 100.0%  |  5:05.128  33.9%  |  9:49.597 65.5%  |  9:53.196  65.9%
 0001    237       | 14:59.958 100.0%  |  6:36.685  44.1%  |  8:18.401 55.4%  |  8:22.515  55.8%
 0002    237       | 14:59.958 100.0%  |  7:20.588  49.0%  |  7:14.363 48.3%  |  7:16.668  48.5%
 0003    237       | 14:59.958 100.0%  | 12:17.482  82.0%  |  2:26.713 16.3%  |  2:27.339  16.4%
 0004    237       | 14:59.958 100.0%  | 13:03.208  87.0%  |  1:43.876 11.5%  |  1:44.341  11.6%
 0005    237       | 14:59.958 100.0%  | 13:27.262  89.7%  |  1:20.421  8.9%  |  1:20.784   9.0%
 0006    237       | 14:59.958 100.0%  | 13:15.322  88.4%  |  1:32.095 10.2%  |  1:32.459  10.3%
 0007    237       | 14:59.958 100.0%  | 13:33.702  90.4%  |  1:16.500  8.5%  |  1:16.762   8.5%
 TOTAL                         100.0%               70.6%              28.1%               28.3%




 RUN DATE: 07/02/20       SMF 70 - PROCESSOR PERCENT TIME ONLINE REPORT                PAGE    7

 PARTITION INFO
 ==============
 SYSTEM: TN01
 PARTITION (NUM-NAME):   9 - ZU807IMO
 PROCESSOR FAMILY AND MODEL: 2817 611   SERIAL 083F96
 PROCESSOR CAPACITY:   843 (MSU'S)
 LPAR CLUSTER: NPLEX1   SYSTEM NAME: TN0K
 LPAR DEFINED CAPACITY LIMIT:     0 (MSU'S)
 STORAGE:   4,096 MB
 PROCESSORS:   54

 LOGICAL PROCESSOR INFO (FOR ACTIVE PROCESSORS)
 FOR 14:59.957 MINUTE INTERVAL ENDING 10/25/12 AT 14:14:00.04

 LOGL                                                         EFFECT.   PCT       PROC     PCT
 PROC WEIGHT CPU      ONLINE    PCT        WAIT     PCT      DISPATCH   EFF       DISP     PROC
 ADDR FACTOR NAME      TIME    ONLINE      TIME     WAIT       TIME    DISP       TIME     DISP
 ____ ______ ____  _ _________ ______  _ _________ ______  _ _________ _____  _ _________ ______

 0000     70       | 14:59.958 100.0%  | 14:46.336  98.5%  |  0:12.841  1.4%  |  0:13.202   1.5%
 0001     70       | 14:59.958 100.0%  | 14:47.713  98.6%  |  0:11.682  1.3%  |  0:11.992   1.3%
 0002     70       | 14:59.958 100.0%  | 14:49.414  98.8%  |  0:10.057  1.1%  |  0:10.347   1.2%
 0003     70       | 14:59.958 100.0%  | 14:49.201  98.8%  |  0:10.186  1.1%  |  0:10.483   1.2%
 TOTAL                         100.0%               98.7%               1.2%                1.3%

...

 

 

Report 2:


       SMF 70 REPORT - PARTITIONS WITH NO CPU'S       RUN DATE: 07/02/20
    FOR 15:00 MINUTE INTERVAL ENDING 10/25/12 AT 14:14:00.04   PAGE    1
            PARTITION                 SERIAL    CAPACITY
  SYSTEM    NUM - NAME   FAMILY MODEL NUMBER    (MSU'S)
 ________ ______________ ______ _____ ______ ______________

 TN01       1 - ZU80AIMO  2817  611   083F96            843
 TN01       5 - ZU80EIML  2817  611   083F96            843
 TN01      15 - ZU815CTO  2817  611   083F96            843
 TN01      16 - ZU816CTO  2817  611   083F96            843
 TN01       1 - ZU80AIMO  2817  611   083F96            843
 TN01       5 - ZU80EIML  2817  611   083F96            843
 TN01      15 - ZU815CTO  2817  611   083F96            843
 TN01      16 - ZU816CTO  2817  611   083F96            843
 TN01       1 - ZU80AIMO  2817  611   083F96            843
 TN01       5 - ZU80EIML  2817  611   083F96            843
 TN01      15 - ZU815CTO  2817  611   083F96            843
 TN01      16 - ZU816CTO  2817  611   083F96            843
 
 *** GRAND TOTAL (    12 ITEMS)                      10,116

See Other Sample SMF Reports
Copyright 2024.
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