








	*SMF Tools*

Sample Report from SMF 101 Records
showing SQL Statement Counts

It's easy to report on SMF data!

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.

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. (See SMF 101 record layout.) It then prints a report line for each DB2 accounting record written. The report shows statistical information about those DB2 jobs, including a count of the number of DB2 statements executed by each one.

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:


INPUT:  SMF101V9                                               
                                                             
INCLUDEIF: SM101RTY = 101                                    
                                                             
COLUMNS: SM101DTE('SMF DATE')  SM101TME('SMF TIME')          
         QMDACORR('CORRELATION|NAME')                        
         QMDAAUTH('AUTHORIZATION|ID')                        
         QMDAPLAN('DB2 PLAN|NAME')                           
         QXSELECT('NUM OF|SELECTS')                          
         QXUPDTE('NUM OF|UPDATES')                           
         QXDELET('NUM OF|DELETES')                           
         QXOPEN('NUM OF|OPENS')                              
         QXFETCH('NUM OF|FETCHS')                            
                                                             
TITLE: 'SQL STATEMENT EXECUTION COUNTS BY JOB'

Produce This SMF Report:


                                               SQL STATEMENT EXECUTION COUNTS BY JOB                                                 

                     CORRELATION  AUTHORIZATION DB2 PLAN    NUM OF       NUM OF      NUM OF      NUM OF       NUM OF      
SMF DATE  SMF TIME       NAME          ID         NAME     SELECTS      UPDATES     DELETES       OPENS       FETCHS      
________ ___________ ____________ _____________ ________ ___________ ___________ ____________ ____________ ___________  
                                                                                
06/17/09 21:32:57.06 JDB2           TTAP01B     SPECT300           0           0            0            1          19 
06/17/09 21:32:57.06 JDB2           TTAP01B     SPECT300           0           0            0            1          19 
06/17/09 21:36:48.13 JDB2           TTAP01B     SPECT300           0           0            0            1          19 
06/17/09 21:36:54.70 JDB2C          TJSK01A     SPECT300           0           0            0            1          19 
06/17/09 21:37:07.35 JDB2A          TJSK01A     SPECT300           0           0            0            1          19 
                                                                                
*** GRAND TOTAL (     5 ITEMS)                                     0           0            0            5          95

See Other Sample SMF Reports

Sample Report from SMF 101 Records showing SQL Statement Counts

It's easy to report on SMF data!

These Spectrum SMF Writer Statements:

Produce This SMF Report:

Sample Report from SMF 101 Records
showing SQL Statement Counts