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 Export File from SMF 110 Subtype 2 Records
in Key-Value Format

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

In this example, we want to read CICS statistics data and output it in KEY=VALUE format. (For example: DATE=2017/12/22). This file will subsequently be used in another mainframe application.

Here is an explanation of some of the statements in the program below.

An OPTION statement specifies that we want to create a mainframe export file (as opposed to a report, or a comma delimited PC export file.) Another option specifies the data formats that we want our "values" to appear in. We also specify a large LRECL for the output file so that there is room for many pairs of values in each record.

Our INPUT statement specifies that we want to invoke the SMF file definitions for type 110 subtype 2 records. (See SMF 110-2 record layout.) The INCLUDEIF statement then selects just these type 110-2 CICS Statistics records from the SMF file.

Our COLUMNS statement then outputs the "KEY=" part of each data pair as a single literal field. We follow that with the name of an SMF 110-2 field whose value we want to follow the KEY= text in the record. Since mainframe files default to having "0" blanks between columns, we specify an explicit spacing factor of "1" between the pairs of KEY=VALUE.

That's all it takes to turn SMF data into a useful KEY-VALUE mainframe file.

All of this with just a 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:

 OPTIONS: MAINFRAME FORMAT(CHAR, NOCOMMA, YYYY-MM-DD, HH-MM-SS) 
 OPTIONS: OUTLRECL(4096)                                        

 INPUT:     SMF110S2                                               
 INCLUDEIF: SMF110RTY = 110 AND SMF110STY = 2                   
                                                                
 COLUMNS:                                                       
     'TIME='                     SMF110DTE '-' SMF110TME        
   1 'CICS='                     SMF110S2_MNJBN                 
   1 'SOG_CURR_INBOUND_SOCKETS=' SOG_CURR_INBOUND_SOCKETS(LEFT) 
   1 'SOG_PEAK_INBOUND_SOCKETS=' SOG_PEAK_INBOUND_SOCKETS(LEFT) 

 

Produce This SMF Key-Value File:


TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
TIME=2017/12/22-20:00:00.16 CICS=POLPRD   SOG_CURR_INBOUND_SOCKETS=11 SOG_PEAK_INBOUND_SOCKETS=12 
...

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