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 Report from SMF 15 and 17 Records
showing 'Opens for Update' and 'Deletes' for Selected DSNAME

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 is a simple example of producing a report from multiple SMF record types. It reads as input the SMF file and selects both the type 15 (DD opened for output or update) and type 17 (dataset deleted) SMF records. (See SMF 15 or SMF 17 record layout.)

This report selects only records with a specific text ("SPFTEMP") somewhere withing the DSNAME. (And note that the DSNAME field is not in the same location in type 15 and type 17 SMF records.)

It then prints a report line for each type 15 or 17 record that refers to "SPFTEMP" dataset. Each report line shows data from either the SMF 15 record or the SMF 17 record. The report is then sorted and grouped by job. (However, in this example only 1 job happened to pass the selection criteria.)

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: SMF15     /* GET TYPE 15 DEFINITIONS */
COPY:  REC17     /* GET TYPE 17 DEFINITIONS, TOO */
*
***************************************************************
* MOVE DATA FROM DIFF LOCATIONS TO WORK FIELDS                *
***************************************************************
COMPUTE: JOBID   = WHEN(SMF15RTY=15) ASSIGN(SMF15_JOBID)
                   ELSE              ASSIGN(SMF17_JOBID)
*
COMPUTE: LOGTIME = WHEN(SMF15RTY=15) ASSIGN(SMF15TME)
                   ELSE              ASSIGN(SMF17TME)
*
COMPUTE: DSN     = WHEN(SMF15RTY=15) ASSIGN(SMF15_JFCBDSNM)
                   ELSE              ASSIGN(SMF17DSN)
*
COMPUTE: MGMT    = WHEN(SMF15RTY=15) ASSIGN(SMF15MCN)
                   ELSE              ASSIGN(' ')
*
COMPUTE: DISP    = WHEN(SMF15RTY=15) ASSIGN(SMF15-DISP)
                   ELSE              ASSIGN('DELETE')
*
***************************************************************
* SELECT TYPE 15 AND TYPE 17 RECS FOR SELECTED DSNS           *
***************************************************************
INCLUDEIF: (SMF15RTY = 15 OR 17)  /* SELECT BOTH 15 AND 17*/
           AND DSN : 'SPFTEMP'    /* ":" MEANS SCAN FOR TEXT */
*
***************************************************************
* OUTPUT REPORT LINES FROM OUR COMPUTED VALUES.               *
***************************************************************
COLUMNS: JOBID('JOB NAME AND READER TIME')
         LOGTIME
         SMF15RTY(4 'SMF|TYPE' NOACC)
         DSN(30 'DATASET NAME')
         MGMT('MANAGEMENT|CLASS')
         DISP
*
SORT:  JOBID SMF15DTE SMF15TME /* SORT ON JOB, THEN DATE & TIME */
BREAK: JOBID SPACE(1) NOTOTALS /* PRT 1 BLANK LINE WHEN JOB CHGS */
*
TITLE: #DATE / 'SMF OPENS FOR UPDATE, AND DELETES' / 'PAGE' #PAGENUM
TITLE:       / 'ON DATASETS CONTAINING "SPFTEMP"' /

 

Produce This SMF Report:

 
03/19/09                       SMF OPENS FOR UPDATE, AND DELETES                      PAGE    1
                                ON DATASETS CONTAINING "SPFTEMP"

                                           SMF                                 MANAGEMENT
   JOB NAME AND READER TIME      LOGTIME   TYPE          DATASET NAME            CLASS     DISP
 _____________________________ ___________ ____ ______________________________ __________ ______

 W0TTRP1  08/02/07 10:55:36.66 12:23:48.47   15 W0TTRP1.SPFTEMP2.CNTL           TSO       OLD
 W0TTRP1  08/02/07 10:55:36.66 12:23:57.47   15 W0TTRP1.SPFTEMP1.CNTL           TSO       OLD
 W0TTRP1  08/02/07 10:55:36.66 12:23:57.65   17 W0TTRP1.SPFTEMP1.CNTL                     DELETE


 ****** GRAND TOTAL (     3 ITEMS)          

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