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 64 Records
Showing Statistics for VSAM Clusters/Components

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.

In this report, we read as input the SMF file and select just the type 64 VSAM statistics records. (See SMF 64 record layout.) The report shows various VSAM statistics as of OPEN time. The statistics include number of extents, number of logical records, cumulative number of records inserted and deleted, and the cumulative number of control interval and control area splits, etc.

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

INCLUDEIF: SMF64RTY = 64

TITLE: 'VSAM COMPONENT/CLUSTER STATS FROM SMF 64 RECORDS'

COLUMNS:
     SMF64_JOBID('JOBNAME AND READER TIME')
     SMF64VSN('VOLUME')
     SMF64CUU('DEVICE' HEX)
     SMF64FCC('BEG|CCCHH' HEX)
     SMF64TCC('END|CCCHH' HEX)
     SMF64NEX('NUM|CEXTENTS' 7)
     SMF64NLR('NUM|CRECS' 9)
     SMF64NDE('NUM|CDELETES' 9)
     SMF64NCS('NUM|CCI|CSPLITS' 5)
     SMF64NAS('NUM|CCA|CSPLITS' 5)
     SMF64NEP('NUM|CEXCPS' 8)

SORT: SMF64_JOBID(1)   /* SORT AND BREAK ON UNIQUE JOB */

 

Produce This SMF Report:


                                VSAM COMPONENT/CLUSTER STATS FROM SMF 64 RECORDS
 
                                                                                           NUM   NUM
                                               BEG      END      NUM      NUM       NUM     CI    CA     NUM
    JOBNAME AND READER TIME    VOLUME DEVICE   CCHH     CCHH   EXTENTS   RECS     DELETES  SPLIT SPLIT  EXCPS
 _____________________________ ______ ______ ________ ________ _______ _________ _________ _____ _____ ________

 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  04EF0000 0520000E       1         2         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  0009000C 0009000E       1         1         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  04BD0000 04EE000E       1         2         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  00090009 0009000B       1         1         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  02DA0000 030B000E       1         2         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  04EF0000 0520000E       1         2         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  0009000C 0009000E       1         1         0     0     0        3
 CICSDNMS 05/23/08 19:59:40.05 SQK102  7308  00090006 00090008       1         1         0     0     0        3
 *** TOTAL FOR CICSDNMS 05/23/08 19:59:40.05 (    8 ITEMS)           8        12         0     0     0       24

 DLISET82 05/23/08 22:13:47.86 DB4D03  5D03  26C50000 26CE000E      15 1,115,761    25,946 1,273     0  303,715
 DLISET82 05/23/08 22:13:47.86 DB4DSP  5F06  00920002 00920004      12   296,178         1   162    17   64,141
 *** TOTAL FOR DLISET82 05/23/08 22:13:47.86 (    2 ITEMS)          27 1,411,939    25,947 1,435    17  367,856

 ERPTRKIL 07/24/06 11:49:50.74 SQK102  7308  04EF0000 0520000E       4   142,235         0     0     0        4
 ERPTRKIL 07/24/06 11:49:50.74 SQK102  7308  0009000C 0009000E       4       226         0     0     0      234
 ERPTRKIL 07/24/06 11:49:50.74 SQK051  640A  02190000 027C000E       1         0         0     0     0        0
 ERPTRKIL 07/24/06 11:49:50.74 SQK051  640A  00090000 00090005       1         0         0     0     0        0
 ERPTRKIL 07/24/06 11:49:50.74 SQK102  7308  04EF0000 0520000E       4   142,235         0     0     0        3
 ERPTRKIL 07/24/06 11:49:50.74 SQK102  7308  0009000C 0009000E       4       226         0     0     0        3
 ERPTRKIL 07/24/06 11:49:50.74 SQK102  7308  04EF0000 0520000E       4   142,235         0     0     0        4
 ERPTRKIL 07/24/06 11:49:50.74 SQK102  7308  0009000C 0009000E       4       226         0     0     0        8
 *** TOTAL FOR ERPTRKIL 07/24/06 11:49:50.74 (    8 ITEMS)          26   427,383         0     0     0      256

 NETSA01  05/23/08 19:57:23.62 TPRD07  2A18  00200000 0020000E       1         1         0     0     0        2
 NETSA01  05/23/08 19:57:23.62 TPRD07  2A18  00200000 0020000E       1         1         0     0     0        2
 NETSA01  05/23/08 19:57:23.62 TPRD07  2A18  0009000E 0009000E       1         1         0     0     0        3
 NETSA01  05/23/08 19:57:23.62 TPRD04  2F21  07050000 0705000E       1         1         0     0     0        2
 NETSA01  05/23/08 19:57:23.62 TPRD04  2F21  00A60008 00A60008       1         1         0     0     0        3
 NETSA01  05/23/08 19:57:23.62 TPRD04  2F21  07050000 0705000E       1         0         0     0     0        0
 NETSA01  05/23/08 19:57:23.62 TPRD04  2F21  00A60008 00A60008       1         0         0     0     0        0
 *** TOTAL FOR NETSA01  05/23/08 19:57:23.62 (    7 ITEMS)           7         5         0     0     0       12

 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  05160000 0529000E       1        22         0     0     0        5
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  05160000 0529000E       1        22         0     0     0        5
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  05160000 0529000E       1        22         0     0     0        5
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  052A0000 053D000E       1       440         0     0     0      583
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  05160000 0529000E       1       440         0     0     0      582
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  052A0000 053D000E       1         0         0     0     0        0
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  052A0000 053D000E       1        22         0     0     0        5
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  052A0000 053D000E       1        22         0     0     0        5
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  05160000 0529000E       1        22         0     0     0        5
 RMFDSP   05/23/08 19:58:58.13 TPVOL1  2A10  05160000 0529000E       1        22         0     0     0        5

 ...

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