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 14 Records
Showing DSNAME and EXCP Count

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 14 records for the day we want to report on. (See SMF 14 record layout.) It prints a report line for each dataset opened on that day. The report shows job information and EXCP count. It groups report lines by unique job and puts a single blank line between jobs.

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

INPUT:  SMF14

INCLUDEIF: SMF14RTY = 14          /* SELECT JUST TYPE 14 RECORDS */

COLUMNS:
         SMF14_JOBID('JOBNAME READER TIMESTAMP' 26)
         SMF14SPN('STEPNAME')
         SMF14PGN('PGMNAME')
         SMF14TIOE5('DDNAME')
         SMF14_JFCBDSNM('DATASET NAME' 16) /* SHORTEN FOR SPACE*/
         SMF14EXCP('EXCP/COUNT' 6)
         SMF14_CRDT('CREATION/DATE')
         SMF14_JFCLRECL('LRECL' 6)
         SMF14_JFCBLKSI('BLKSIZE' 7)
         SMF14_JFCBVOLS_1('VOLSER' 8)
         SMF14MCN('SMS MGMT/CLASS')
         SMF14SCN('SMS STOR/CLASS')

SORT:  SMF14_JOBID

BREAK: SMF14_JOBID SPACE(2) NOTOTALS

TITLE: #DATE / 'DATA SET USAGE BY JOBNAME' / 'PAGE' #PAGENUM

 

Produce This SMF Report:

 08/08/07                                           DATA SET USAGE BY JOBNAME                                           PAGE    1

                                                                         EXCP  CREATION                         SMS MGMT SMS STOR
  JOBNAME READER TIMESTAMP  STEPNAME PGMNAME   DDNAME    DATASET NAME   COUNT    DATE   LRECL  BLKSIZE  VOLSER   CLASS    CLASS
 __________________________ ________ ________ ________ ________________ ______ ________ ______ _______ ________ ________ ________

 BALCOMB  08/02/07 07:41:39 BTPRMF52 IKJEFT01 SYSPROC  SYS1.TSO.CLIST.N      0 04/08/03     80  27,920  KRJSTC
 BALCOMB  08/02/07 07:41:39 BTPRMF52 IKJEFT01 SYSPROC  SYS1.TSO.CLIST.N      0 04/08/03     80  27,920  KRJSTC
 BALCOMB  08/02/07 07:41:39 BTPRMF52 IKJEFT01 SYSPROC  SYS1.TSO.CLIST.N      0 04/08/03     80  27,920  KRJSTC
 BALCOMB  08/02/07 07:41:39 BTPRMF52 IKJEFT01 SYSEXEC  TSP.SISPEXEC          0 09/18/06     80  27,920  TIMPC0
 BALCOMB  08/02/07 07:41:39 BTPRMF52 IKJEFT01 SYSEXEC  TSP.SISPEXEC          0 09/18/06     80  27,920  TIMPC0
 BALCOMB  08/02/07 07:41:39 BTPRMF52 IKJEFT01 SYSEXEC  TSP.SISPEXEC          0 09/18/06     80  27,920  TIMPC0
 
 BT910152 08/02/07 12:01:52 AT1      DFSULLS1 DFUTLP02 IMSSYST.IMS1.OLP  9,001 02/14/07 24,572  24,576  V91024  TESTBASE TESTBASE
 BT910152 08/02/07 12:01:52 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT910648 08/02/07 12:06:48 AT1      DFSULLS1 DFUTLP03 IMSSYST.IMS1.OLP  9,001 02/14/07 24,572  24,576  V91116  TESTBASE TESTBASE
 BT910648 08/02/07 12:06:48 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT911150 08/02/07 12:11:50 AT1      DFSULLS1 DFUTLP04 IMSSYST.IMS1.OLP  9,001 02/14/07 24,572  24,576  V91053  TESTBASE TESTBASE
 BT911150 08/02/07 12:11:50 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT911352 08/02/07 12:13:52 AT1      DFSULLS1 DFUTLP01 IMSSYST.IMS4.OLP 12,001 02/14/07 22,524  22,528  V91095  TESTBASE TESTBASE
 BT911352 08/02/07 12:13:52 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT911631 08/02/07 12:16:31 AT1      DFSULLS1 DFUTLP05 IMSSYST.IMS1.OLP  9,001 02/14/07 24,572  24,576  V91054  TESTBASE TESTBASE
 BT911631 08/02/07 12:16:31 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT912109 08/02/07 12:21:09 AT1      DFSULLS1 DFUTLP00 IMSSYST.IMS1.OLP  9,001 02/14/07 24,572  24,576  V91044  TESTBASE TESTBASE
 BT912109 08/02/07 12:21:09 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT912309 08/02/07 12:23:09 AT1      DFSULLS1 DFUTLP01 IMSSYST.IMS1.OLP  3,751 02/14/07 24,572  24,576  V91114  TESTBASE TESTBASE
 BT912309 08/02/07 12:23:09 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 
 BT912758 08/02/07 12:27:58 AT1      DFSULLS1 STEPLIB  IMS910T.ZRS0.SDF     73 04/27/05      0  32,760  V91013  PRIOR    TESTBASE
 BT912758 08/02/07 12:27:58 AT1      DFSULLS1 DFUTLP02 IMSSYST.IMS1.OLP  9,001 02/14/07 24,572  24,576  V91024  TESTBASE TESTBASE
 
 CSQ1BING 08/01/07 19:04:10 CSQ1BING CSQXJST  SYS00180 TCPIP.ETC.SERVIC      7 02/05/97     80   3,120  C23SP3
 
 CSQ3BING 08/01/07 19:58:36 CSQ3BING CSQXJST  SYS00122 TCPIP.ETC.SERVIC      7 02/05/97     80   3,120  C23SP3
 CSQ3BING 08/01/07 19:58:36 CSQ3BING CSQXJST  SYS00119 TCPIP.ETC.SERVIC      7 02/05/97     80   3,120  C23SP3
 
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    320 10/23/02     80   3,200  C23CL1
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    316 10/23/02     80   3,200  C23CL1
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    308 10/23/02     80   3,200  C23CL1
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    332 10/23/02     80   3,200  C23CL1
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    312 10/23/02     80   3,200  C23CL1
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    324 10/23/02     80   3,200  C23CL1
 DB29AT   08/01/07 19:09:46 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC    328 10/23/02     80   3,200  C23CL1


 08/08/07                                           DATA SET USAGE BY JOBNAME                                           PAGE    2

                                                                         EXCP  CREATION                         SMS MGMT SMS STOR
  JOBNAME READER TIMESTAMP  STEPNAME PGMNAME   DDNAME    DATASET NAME   COUNT    DATE   LRECL  BLKSIZE  VOLSER   CLASS    CLASS
 __________________________ ________ ________ ________ ________________ ______ ________ ______ _______ ________ ________ ________

 DB29AT   08/01/07 20:03:53 DB29AT   DFSMVRC0 JCLPDS   D10.TIMDSW4.PROC     64 10/23/02     80   3,200  C23CL1
 
 DUMPSMF  08/02/07 12:00:02 DUMPSMF  SMFGDG   LOG      D10.SMF.GDG.LIST     59 02/09/95     80  27,920  C23AQ2
 DUMPSMF  08/02/07 12:00:02 DUMPSMF  SMFGDG   STEPLIB  USER.LINKLIB          2 06/14/06      0  32,760  KRJSTC
 DUMPSMF  08/02/07 12:00:02 DUMPSMF  IFASMFDP SYSIN    USER.PROCLIB          2 05/08/00     80   6,400  KRJSTC
 
 DUMPSMF  08/02/07 12:08:49 DUMPSMF  IFASMFDP SYSIN    USER.PROCLIB          2 05/08/00     80   6,400  KRJSTC
 DUMPSMF  08/02/07 12:08:49 DUMPSMF  SMFGDG   LOG      D10.SMF.GDG.LIST     59 02/09/95     80  27,920  C23AQ2
 DUMPSMF  08/02/07 12:08:49 DUMPSMF  SMFGDG   STEPLIB  USER.LINKLIB          2 06/14/06      0  32,760  KRJSTC
 
 DUMPSMF  08/02/07 12:12:52 DUMPSMF  IFASMFDP SYSIN    USER.PROCLIB          2 05/08/00     80   6,400  KRJSTC
 DUMPSMF  08/02/07 12:12:52 DUMPSMF  SMFGDG   LOG      D10.SMF.GDG.LIST     59 02/09/95     80  27,920  C23AQ2
 DUMPSMF  08/02/07 12:12:52 DUMPSMF  SMFGDG   STEPLIB  USER.LINKLIB          2 06/14/06      0  32,760  KRJSTC
 
 DUMPSMF  08/02/07 12:20:14 DUMPSMF  IFASMFDP SYSIN    USER.PROCLIB          2 05/08/00     80   6,400  KRJSTC
 DUMPSMF  08/02/07 12:20:14 DUMPSMF  SMFGDG   LOG      D10.SMF.GDG.LIST     59 02/09/95     80  27,920  C23AQ2
 DUMPSMF  08/02/07 12:20:14 DUMPSMF  SMFGDG   STEPLIB  USER.LINKLIB          2 06/14/06      0  32,760  KRJSTC
 
 DUMPSMF  08/02/07 12:25:18 DUMPSMF  SMFGDG   LOG      D10.SMF.GDG.LIST     59 02/09/95     80  27,920  C23AQ2
 DUMPSMF  08/02/07 12:25:18 DUMPSMF  SMFGDG   STEPLIB  USER.LINKLIB          2 06/14/06      0  32,760  KRJSTC
 DUMPSMF  08/02/07 12:25:18 DUMPSMF  IFASMFDP SYSIN    USER.PROCLIB          2 05/08/00     80   6,400  KRJSTC
 
 IMS4     08/01/07 20:03:49 IMS4     DFSMVRC0 DFUTLP00 IMSSYST.IMS4.OLP 36,001 02/14/07 22,524  22,528  V91095  TESTBASE TESTBASE
 
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00568 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00569 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00567 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00570 SMB.SCEERUN       1,580 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00566 SYS1.LINKLIB          2 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00571 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00572 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00573 SMB.SCEERUN         748 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00575 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:03:23 LTOMA    KNJLLCRE SYS00574 SYS1.SERBLINK        47 09/20/06      0  32,760  TIMPC0
 
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00371 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00365 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00368 CWC.SCSFMOD0          2 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00369 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00366 SYS1.SERBLINK        53 09/20/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00367 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00372 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00370 SMB.SCEERUN2      1,663 09/18/06      0  32,760  TIMPC0
 LTOMA    08/01/07 19:54:26 LTOMA    KNJLLCRE SYS00373 SMB.SCEERUN          65 09/18/06      0  32,760  TIMPC0


...

See Other Sample SMF Reports
Spectrum SMF Writer - the 4GL SMF Report Writer.
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