Go to Home Page
 
  Go to Home Page  
  See all products
  See manuals, tutorials, articles
  See price schedules
  See user testimonials
  See user testimonials
  Download a free 30-day trial
 
  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 101 Records
showing Correlation, Distribution and Data Sharing Info
for records with specified DB2PLANs

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 all of the difficult SMF record parsing for you automatically. You just specify the fields you want to see.

Plus Spectrum SMF Writer even exports SMF data as comma delimited files, to use on your PC. All of this for only $4,995!
 
Download your free trial of Spectrum SMF Writer and start making SMF reports right 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 101 (DB2 Accounting) records with IFCID 3 (accounting trace records). (See SMF 101 record layout.)

We further select on the value in the DB2PLAN field to get just the trace records for the plan we are interested in.

We then print a report showing various data fields from the SMF 101 records for that plan. We leave the report in SMF log time order.

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:

OPTION: HDGSEP('/') /* CHANGE DEFAULT SEPERATOR CHAR */

INPUT:  SMF101

INC: SM101RTY = 101 AND QWHSIID =3 /* IFCID 003 */
     AND QWHCPLAN = 'MAJSERVR'

COL: SM101DTE SM101TME
     QWHCCV('CORRELATION')
     QWHCCN('CONNECTION')
     QWHCPLAN('DB2PLAN')
     QWHCOPID('OPERATOR/ID')
     QWHDRQNM('REQUESTOR/LOCATION')
     QWHADSGN('SHARING/GROUP')
     QWHAMEMN('MEMBER/NAME')

TITLE: /'DB2 ACCOUNTING INFO FOR DB2PLAN: MAJSERVR' / #DATE ' ' #TIME

 

Produce This SMF Report:

 
                            DB2 ACCOUNTING INFO FOR DB2PLAN: MAJSERVR         07/21/09    9:23 AM

                                                      OPERATO    REQUESTOR     SHARING   MEMBER 
SM101DTE  SM101TME   CORRELATION  CONNECTION DB2PLAN     ID        LOCATION      GROUP     NAME  

09/23/08 10:40:03.28 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:40:05.26 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:13.65 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:14.98 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:20.91 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:21.99 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:40:25.47 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:40:26.94 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:34.42 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:35.11 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:41.43 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:46.74 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:48.39 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:40:53.43 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:40:53.44 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:40:56.49 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:03.01 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:10.36 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:13.04 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:41:17.30 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:24.22 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:41:25.02 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:41:25.09 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:25.41 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:31.93 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:41:33.77 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:39.88 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:45.52 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:48.58 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:41:52.39 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:41:54.54 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:01.84 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:03.32 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:42:07.97 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:15.72 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:16.88 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:18.91 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:42:24.84 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:27.82 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:42:28.41 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:42:33.09 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:38.56 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:44.68 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:45.82 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:48.66 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:42:48.87 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:42:52.25 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:42:57.25 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:43:05.92 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:43:07.10 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:43:12.74 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:43:12.99 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.25.37    DSN9KJT  DBT4
09/23/08 10:43:20.73 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4
09/23/08 10:43:23.18 db2trbWebSph  SERVER    MAJSERVR SETUP    192.168.43.100   DSN9KJT  DBT4
09/23/08 10:43:26.03 db2trbNon-de  SERVER    MAJSERVR SETUP    192.168.24.30    DSN9KJT  DBT4

...

See Other Sample SMF Reports
Copyright 2012
Pacific Systems Group.
All rights reserved.


Spectrum Writer 4GL - the economical alternative to SAS, Easytrieve, DYL-280...

Home | Products | Documentation | Prices | Testimonials | Company | 30-Day Trials | FAQ | Sample Reports | SMF Records
Send Your Comments or Questions