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 74 Subtype 4 Records
Showing RMF Coupling Activity Over an Interval

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.

This report reads as input the SMF file and selects just the type 74 RMF Activity records with subtype = 4. (See SMF 74 record layout.) Each of these SMF records contains multiple Request Sections. We normalize these sections in order to easily print the same report information from each request section. We then print a report line for each Request Section, showing various statistics relating to synchronous and asynchronous requests during the interval. It also shows a count of certain requests for which no resource was available.

In this report, we take advantage of several of Spectrum's special formatting options. The BIZ ("blank if zero") option suppresses 0 values, which can clutter up a report. Also, since the SMF744SASQ field encompasses a wide range of values, we used a "scaled" type of picture to format it. Spectrum automatically displays a value with the appropriate K, M, G, ... suffix as necessary. This technique lets you display more data (in smaller columns) when it is not essential to know the exact value of a field.

We also used another technique to squeeze more data columns into the report. Since the identical Sysplex and System names appear for hundreds of consecutive lines, we moved those 2 fields from the detail report lines up into the page titles. We page-break on those fields to insure that the data on each page comes from a single Sysplex-System.

All of this with just a couple of dozen 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: SCALEPICS /* ALLOW VARIABLY SCALED PICTURES */

INPUT: SMF744 NORMWHEN(SMF74RTY=74 AND SMF74STY=4)
             NORMSMF(SMF744SO)     

INCLUDEIF: SMF74RTY=74 AND SMF74STY=4

TITLE: #DATE / 'RMF COUPLING ACTIVITY REPORT' / 'PAGE' #PAGENUM
TITLE: 'SYSPLEX:' SMF74XNM 'SYSTEM:' SMF74SNM

COLUMNS:
     SMF744SNAM('CONNECTED|STRUCTURE')
     SMF74IST('INTERVAL|START|TIME')
     SMF74INT_TIME(TP'ZZ:Z9.999' 'INTERVAL|LENGTH')
     SMF744SSIZ(8 'STRUCT|SIZE' BIZ)
     SMF744SARC_VAL('TOTAL|ASYNCH|OPERS' 8 BIZ)
     SMF744SASQ('SUM|SQRS|SERVIC|TIME|ASYNCH' 6 P'Z,ZZ9@' BIZ)
     SMF744SATM('SUM|SERVIC|TIME|ASYNCH' 10 BIZ)
     SMF744SSTA_VAL('ASYNCH|REQS|NO RESRC' 8 BIZ)
     SMF744SSRC_VAL('CNT|TIMES|SYNCH|REQS' 8 BIZ)
     SMF744SSSQ('SUM-SQRS|SERVIC|TIME|SYNCH' 10 BIZ)
     SMF744SSTM('SUM|SERVIC|TIME|SYNCH' 10 BIZ)

SORT:  SMF74XNM SMF74SNM SMF74DTE SMF74TME SMF744SNAM
BREAK: SMF74SNM SPACE(PAGE)

 

Produce This SMF Report:


 08/14/07                                 RMF COUPLING ACTIVITY REPORT                                 PAGE    1
                                       SYSPLEX: SYSPL9   SYSTEM: S01

                                                        SUM
                                                        SQRS     SUM                CNT     SUM-SQRS     SUM
                  INTERVAL                     TOTAL   SERVIC   SERVIC    ASYNCH   TIMES     SERVIC     SERVIC
    CONNECTED      START   INTERVAL   STRUCT   ASYNCH   TIME     TIME      REQS    SYNCH      TIME       TIME
    STRUCTURE       TIME    LENGTH     SIZE    OPERS   ASYNCH   ASYNCH   NO RESRC   REQS     SYNCH      SYNCH
 ________________ ________ _________ ________ ________ ______ __________ ________ ________ __________ __________

 ACF2_LIDS        09:30:00 10:00.000   50,048   16,034 1,004M  2,013,709                68    184,508      3,490
 BERVM_SMI1       09:30:00 10:00.000    2,304
 BERVM_SMS2       09:30:00 10:00.000    2,304    3,459   200M    472,144                13    261,598      1,150
 BERVM_SMS3       09:30:00 10:00.000    2,304    1,025    28M    104,325                 5      9,526        208
 BERVM_SMT0       09:30:00 10:00.000    2,304    1,352    76M    160,125        3        4     15,481        241
 BERVM_SMZ0       09:30:00 10:00.000    2,304      885    18M     87,762                 6     17,237        307
 BERVM_SM10       09:30:00 10:00.000    2,304    1,070    91M    177,594                 5    230,667        667
 CRAF_HBP0        09:30:00 10:00.000   12,544      445    14M     51,859                93    111,532      2,456
 CRAF_HBP0        09:30:00 10:00.000   12,672      128 6,997K     20,516
 CRAF_HBP1        09:30:00 10:00.000   20,224      117 3,568K     16,920                 8      4,659        193
 CRAF_HBP1        09:30:00 10:00.000   20,096      367    16M     50,839       14       26     15,918        642
 CRAF_HBP16K0     09:30:00 10:00.000    5,376       14 1,471K      2,474                16      9,661        393
 CRAF_HBP16K0     09:30:00 10:00.000    5,376
 CRAF_HBP2        09:30:00 10:00.000   24,576       46   758K      5,104                 6      3,270        140
 CRAF_HBP2        09:30:00 10:00.000   24,448      183 2,708K     17,469                55     30,184      1,276
 CRAF_HBP32K      09:30:00 10:00.000   13,824       63 1,575K      7,444                33     21,962        850
 CRAF_HBP32K      09:30:00 10:00.000   13,824       33   674K      3,280
 CRAF_HBP8        09:30:00 10:00.000      640
 CRAF_HBP8        09:30:00 10:00.000      640       14   176K      1,311                15      9,393        375
 CRAF_HBP8K0      09:30:00 10:00.000    5,632      191 5,466K     24,221                21     25,874        640
 CRAF_HBP8K0      09:30:00 10:00.000    5,632        9 1,132K      2,970
 CSAF_LOCK1       09:30:00 10:00.000    8,064    2,658    53M    220,344            10,652 *****S****    264,935
 CSAF_SCA         09:30:00 10:00.000    8,192    1,588   167M    244,692                 8     52,673        649
 CTBA_GBP0        09:30:00 10:00.000    2,688       37   535K      3,595
 CTBA_GBP0        09:30:00 10:00.000    2,688       71 1,601K      6,251                41     28,214      1,074
 CTBA_GBP1        09:30:00 10:00.000    2,304       14   217K      1,213                14      9,086        356
 CTBA_GBP1        09:30:00 10:00.000    2,304
 CTBA_GBP11       09:30:00 10:00.000    1,920
 CTBA_GBP11       09:30:00 10:00.000    1,920       14   134K      1,108                14      8,815        351
 CTBA_GBP16K0     09:30:00 10:00.000      896       15   272K      1,488                14      8,664        348
 CTBA_GBP16K0     09:30:00 10:00.000    1,024
 CTBA_GBP2        09:30:00 10:00.000    2,816       30   629K      3,219
 CTBA_GBP2        09:30:00 10:00.000    2,688       56   772K      4,903                33     23,489        879
 CTBA_GBP21       09:30:00 10:00.000    1,408
 CTBA_GBP21       09:30:00 10:00.000    1,408       14   119K      1,054                14      8,754        350
 CTBA_GBP32K      09:30:00 10:00.000    1,664       57 1,087K      5,867                31     21,332        812
 CTBA_GBP32K      09:30:00 10:00.000    1,792       29   414K      2,642
 CTBA_GBP8K0      09:30:00 10:00.000    2,048       30   352K      2,486
 CTBA_GBP8K0      09:30:00 10:00.000    2,048       55   807K      5,043                34     23,816        898
 CTBA_LOCK1       09:30:00 10:00.000    3,072    1,046 8,942K     78,236             3,400 22,415,563     81,367
 CTBA_SCA         09:30:00 10:00.000    3,456    1,759    59M    253,463        1       13     84,538      1,048
 CTLF_GBP0        09:30:00 10:00.000    8,448       10   122K      1,012
 CTLF_GBP0        09:30:00 10:00.000    8,320       37   782K      4,313                16     10,471        409
 CTLF_GBP1        09:30:00 10:00.000   12,544       15   359K      1,459                13      8,241        327
 CTLF_GBP1        09:30:00 10:00.000   12,672
 CTLF_GBP16K0     09:30:00 10:00.000    1,664       30   262K      2,249
 CTLF_GBP16K0     09:30:00 10:00.000    1,664       56   443K      3,703                33  6,709,361      3,423
 CTLF_GBP2        09:30:00 10:00.000    8,320       15   389K      1,656                13      8,141        325
 CTLF_GBP2        09:30:00 10:00.000    8,448
 CTLF_GBP32K      09:30:00 10:00.000    3,584       30   272K      2,255
 CTLF_GBP32K      09:30:00 10:00.000    3,584       57 1,922K      6,194                32     22,436        846

 
08/14/09                                 RMF COUPLING ACTIVITY REPORT                                 PAGE    2
                                       SYSPLEX: SYSPL9   SYSTEM: S01

                                                        SUM
                                                        SQRS     SUM                CNT     SUM-SQRS     SUM
                  INTERVAL                     TOTAL   SERVIC   SERVIC    ASYNCH   TIMES     SERVIC     SERVIC
    CONNECTED      START   INTERVAL   STRUCT   ASYNCH   TIME     TIME      REQS    SYNCH      TIME       TIME
    STRUCTURE       TIME    LENGTH     SIZE    OPERS   ASYNCH   ASYNCH   NO RESRC   REQS     SYNCH      SYNCH
 ________________ ________ _________ ________ ________ ______ __________ ________ ________ __________ __________

 CTLF_GBP8K0      09:30:00 10:00.000    4,096       15   353K      1,473                13      7,933        321
 CTLF_GBP8K0      09:30:00 10:00.000    4,096
 CTLF_LOCK1       09:30:00 10:00.000    4,992    1,214    11M     94,508             4,807 88,328,922    125,032
 CTLF_SCA         09:30:00 10:00.000    3,328    1,581    51M    225,834                 4     26,085        323
 CTOC_GBP0        09:30:00 10:00.000    3,456       50 1,690K      5,850
 CTOC_GBP0        09:30:00 10:00.000    3,456      117 8,598K     16,027                32     22,793        853
 CTOC_GBP1        09:30:00 10:00.000    5,376  112,254 9,213M 18,493,219        4    3,040 35,668,753    110,881
 CTOC_GBP1        09:30:00 10:00.000    5,376      555    21M     84,176
 CTOC_GBP16K0     09:30:00 10:00.000    1,280
 CTOC_GBP16K0     09:30:00 10:00.000    1,280       14   105K      1,061                14      8,260        340
 CTOC_GBP2        09:30:00 10:00.000    5,504    1,033   115M    222,123               787 38,159,579     24,539
 CTOC_GBP2        09:30:00 10:00.000    5,504      732    39M    127,868                 1        529         23
 CTOC_GBP32K      09:30:00 10:00.000    1,536       30   320K      2,389
 CTOC_GBP32K      09:30:00 10:00.000    1,536       58   895K      4,993                33  5,624,615      3,203
 CTOC_GBP8K0      09:30:00 10:00.000    2,048       56   626K      4,361                33     22,278        856
 CTOC_GBP8K0      09:30:00 10:00.000    2,048       30   725K      3,022
 CTOC_LOCK1       09:30:00 10:00.000    4,096    5,707   130M    520,062            10,994 *****S****    338,972
 CTOC_SCA         09:30:00 10:00.000    1,920    1,606    55M    242,189        1        6     39,090        484
 CTTF_GBP0        09:30:00 10:00.000    8,320      919    26M    112,207                 1        529         23
 CTTF_GBP0        09:30:00 10:00.000    8,320    4,400   325M    645,466               153  1,551,026      6,028
 CTTF_GBP1        09:30:00 10:00.000   32,512   57,719 2,150M  5,634,117    1,071    6,178 33,254,757    163,883
 CTTF_GBP1        09:30:00 10:00.000   32,640    5,404   206M    724,337                81     45,930      1,924
 CTTF_GBP16K0     09:30:00 10:00.000    5,376
 CTTF_GBP16K0     09:30:00 10:00.000    5,376       15    77K        951                13      8,035        323
 CTTF_GBP2        09:30:00 10:00.000   32,512   17,088 1,177M  2,471,064    1,131    7,981 61,967,099    203,089
 CTTF_GBP2        09:30:00 10:00.000   32,512    3,385   423M    515,302               151     84,553      3,571
 CTTF_GBP32K      09:30:00 10:00.000   10,752      656    64M    165,137                42     21,778        956
 CTTF_GBP32K      09:30:00 10:00.000   10,752    1,293   108M    319,735               191    351,906      5,634
 CTTF_GBP8        09:30:00 10:00.000      512      318 3,979K     26,878               251    109,958      5,242
 CTTF_GBP8        09:30:00 10:00.000      512       13   460K      2,267
 CTTF_GBP8K0      09:30:00 10:00.000    5,632      270 9,077K     39,335
 CTTF_GBP8K0      09:30:00 10:00.000    5,632    1,160    42M    140,510                68    174,474      2,032
 CTTF_LOCK1       09:30:00 10:00.000   29,184   25,062   730M  2,086,495            72,151 *****S****  1,831,872
 CTTF_SCA         09:30:00 10:00.000    8,192    1,667    90M    248,925                 5     31,698        398
 CTZF_GBP0        09:30:00 10:00.000    7,552      129 6,075K     20,228                 1        841         29
 CTZF_GBP0        09:30:00 10:00.000    7,552      479    20M     73,993        1       36     24,738        942
 CTZF_GBP1        09:30:00 10:00.000   15,104    2,328    85M    325,305               145    431,041      4,537
 CTZF_GBP1        09:30:00 10:00.000   15,104    1,080    37M    146,591                 7      3,848        164
 CTZF_GBP16K0     09:30:00 10:00.000    1,664       30   368K      2,500
 CTZF_GBP16K0     09:30:00 10:00.000    1,664       57   745K      4,820                31     21,507        815
 CTZF_GBP2        09:30:00 10:00.000    8,576      455    27M     61,207                40     30,271      1,085
 CTZF_GBP2        09:30:00 10:00.000    8,576      298    22M     41,913                 1        784         28
 CTZF_GBP32K      09:30:00 10:00.000    2,304       29 1,461K      3,752
 CTZF_GBP32K      09:30:00 10:00.000    2,304       56 1,006K      5,024                34     23,225        887
 CTZF_GBP8        09:30:00 10:00.000      512      117 1,930K     12,466                38     29,333      1,015
 CTZF_GBP8        09:30:00 10:00.000      640       67 1,486K      8,575
 CTZF_GBP8K0      09:30:00 10:00.000    4,864       42 1,794K      7,158                 3      1,638         70
 CTZF_GBP8K0      09:30:00 10:00.000    4,864      184    15M     37,988                54     27,391      1,213
 CTZF_LOCK1       09:30:00 10:00.000    5,888    4,592   144M    384,811             8,320 *****S****    230,595
 CTZF_SCA         09:30:00 10:00.000    3,328    1,861    94M    284,565                 5     31,692        398
 DFHXQLS_DFHTSA01 09:30:00 10:00.000    1,408

 ...

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