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 RACF Report from SMF 89 Subtype 1 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 report below was created with Spectrum SMF Writer, the low-cost 4GL SMF report writer.

It reads as input the SMF file and selects just the type 89 (RACF Usage) records. (See SMF 89 record layout.)

We print a report showing the TCB and SRB time for each monitored product during each recording interval. The information is sorted and report by Sysplex name, then by System name and finally by Product name, with subtotals for each product. We have report both the TCB and SRB times in two ways: as the number of seconds, as they appear in the record. And again after converting the seconds into standard hour, minute and second notation. Spectrum SMf Writer makes this easy with its powerful built-in time handling functions.

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:  SMF89

INCLUDEIF: SMF89RTY = 89 AND SMF89STP=1

COMPUTE: TCB_TIME = #MAKETIME(SMF89UCT)
COMPUTE: SRB_TIME = #MAKETIME(SMF89USR)

COLUMNS:
     SMF89SYN('MVS|SYSTEM|NAME')
     SMF89UST('INTERVAL|START|TIME')
     SMF89UET('INTERVAL|END|TIME')
     SMF89UPN('PRODUCT|NAME')
     SMF89UCT('TCB|TIME|SECONDS' 12)
     TCB_TIME('TCB|TIME')
     SMF89USR('SRB|TIME|SECONDS' 12)
     SRB_TIME('SRB|TIME')

SORT:  SMF89SPN SMF89SYN SMF89UPN SMF89UST     
BREAK: SMF89UPN SPACE(1)                       

TITLE: 'SMF 89 - RACF INITIALIZATION'
TITLE: 'SUBTYPE 1 - INTERVAL STATS FOR' SMF89SPN 'ON' SMF89USD

 

Produce This SMF Report:

 
                                    SMF 89 - RACF INITIALIZATION
                         SUBTYPE 1 - INTERVAL STATS FOR ZPACPLX2 ON 10/02/09

   MVS     INTERVAL    INTERVAL                        TCB                      SRB
  SYSTEM     START        END         PRODUCT          TIME         TCB         TIME         SRB
   NAME      TIME        TIME           NAME         SECONDS       TIME       SECONDS       TIME
 ________ ___________ ___________ ________________ ____________ ___________ ____________ ___________

 SYSZ1    11:00:00.00 12:00:00.00 z/OS                 5,342.00 01:29:02.00       305.00 00:05:05.00
 SYSZ1    12:00:00.00 13:00:00.00 z/OS                 3,955.00 01:05:55.00       343.00 00:05:43.00
 *** TOTAL FOR z/OS             (    2 ITEMS)          9,297.00 02:34:57.00       648.00 00:10:48.00

 SYSZ1    11:00:00.00 12:00:00.00 MQM MVS/ESA             69.00 00:01:09.00         0.00 00:00:00.00
 *** TOTAL FOR MQM MVS/ESA      (    1 ITEM )             69.00 00:01:09.00         0.00 00:00:00.00

 SYSZ9    11:00:00.00 12:00:00.00 z/OS                31,090.00 08:38:10.00       318.00 00:05:18.00
 SYSZ9    12:00:00.00 13:00:00.00 z/OS                27,710.00 07:41:50.00       290.00 00:04:50.00
 *** TOTAL FOR z/OS             (    2 ITEMS)         58,800.00 16:20:00.00       608.00 00:10:08.00

 SYSZ9    11:00:00.00 12:00:00.00 IMS/ESA             13,565.00 03:46:05.00         0.00 00:00:00.00
 *** TOTAL FOR IMS/ESA          (    1 ITEM )         13,565.00 03:46:05.00         0.00 00:00:00.00

 
 ****** GRAND TOTAL (     6 ITEMS)                    81,731.00 22:42:11.00     1,256.00 00:20:56.00



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