








	*SMF Tools*

Sample Syncsort SMF Report from SMF 208 Records

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 208 records (written by Syncsort for each sort.) (See SMF 208 record layout.)

We select only those sorts that sorted over 10 million characters. We report on the combined CPU and SRB time for each sort, along with the number of characters sorted (in Gigabytes) and a computed "CPU time per gigabyte" value.

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: SMF208   
                                                                  
INCLUDEIF: SMF208RTY = 208 AND SMF208P8SIZ > 10000000                             

COMPUTE: SMF208_CPUTM= SMF208CHCTM + SMF208CHSRB                                     
COMPUTE: GB(2) = SMF208P8SIZ / (1024 * 1024 * 1024)                                  
COMPUTE: SORT_XGB(DIVTOTS 2) =                                                       
         SMF208_CPUTM / (SMF208P8SIZ / (1024 * 1024 * 1024))                         

TITLE:     'SYNCSORT STATISTICS   '                                               

COLUMNS:   SMF208DTE                                                              
           SMF208TME(TP'99:99:99')                                                
           SMF208JBN                                                              
           SMF208STMN                                                             
           SMF208INVNM                                                            
           SMF208_CPUTM(ACCUM)                                                    
           GB(10 ACCUM)                   
           SORT_XGB(ACCUM)                

SORT:      SMF208_CPUTM SMF208DTE SMF208TME

Produce This SMF Report:

                                 SYNCSORT STATISTICS
                                                        SMF208                  SORT
 SMF208DTE SMF208TME SMF208JBN SMF208STMN SMF208INVNM    CPUTM        GB         XGB
 _________ _________ _________ __________ ___________ ___________ __________ ___________

 01/29/11   15:30:46 AJKGAU0A   UTEP99     ICEGENER   00:00:00.01       0.01 00:00:01.00
 01/29/11   15:35:29 T0E9600C   P010                  00:00:00.04       0.01 00:00:04.00
 01/29/11   10:19:41 TSTSRP     AFGSRP80              00:00:00.05       0.01 00:00:05.00
 01/29/11   10:22:21 TSTSCP     AFGSCP80              00:00:00.06       0.01 00:00:06.00
 01/29/11   15:15:33 AJKGLT1A   LTMODALL              00:00:00.06       0.02 00:00:03.00
 01/29/11   15:22:03 AJKGCP0A   UORT                  00:00:00.07       0.03 00:00:02.33
 01/29/11   15:29:55 AJKGCP1A   UORT                  00:00:00.07       0.03 00:00:02.33
 01/29/11   02:06:37 TQMST3     S016       ICEGENER   00:00:00.10       0.02 00:00:05.00
 01/29/11   02:05:28 VQMST5     S060                  00:00:00.12       0.01 00:00:12.00
 01/29/11   02:06:10 TQMST5     S090       ICEGENER   00:00:00.12       0.02 00:00:06.00
 01/29/11   14:55:33 IXUF01     S008                  00:00:00.15       0.02 00:00:07.50
 01/29/11   15:18:54 AJKGLT1A   LTMODALL              00:00:00.25       0.18 00:00:01.39
 01/29/11   15:16:29 AJKGLT1A   LTMODALL              00:00:00.30       0.18 00:00:01.67
 01/29/11   16:04:29 KSJP49     UAS        UKTHRED    00:00:00.40       0.02 00:00:20.00
 01/29/11   07:01:34 VMCSKS     S020       ICEGENER   00:00:00.85       0.16 00:00:05.31
 01/29/11   15:37:38 T0E2138X   UCA        ICEGENER   00:00:00.85       0.16 00:00:05.31
 01/29/11   17:32:30 JA0MVG     AFGMVG10              00:00:00.98       0.16 00:00:06.13
 01/29/11   16:29:39 MA08SD     AFG8SD10              00:00:00.99       0.16 00:00:06.19
 01/29/11   17:13:12 MXU368     S010                  00:00:01.13       0.02 00:00:56.50
 01/29/11   14:38:17 UWKC45     S0050                 00:00:01.45       0.21 00:00:06.90
 01/29/11   14:38:44 UWKC49     S0050                 00:00:01.62       0.22 00:00:07.36
 01/29/11   14:38:11 UWKC45     S0010                 00:00:01.70       0.21 00:00:08.10
 01/28/11   23:51:09 BG7S92     S018       ICEGENER   00:00:02.00       4.53 00:00:00.44
 01/29/11   07:51:24 VVDSBSRM   U1                    00:00:03.85       2.42 00:00:01.59
 01/29/11   10:29:00 KR9S2D     S090                  00:00:04.74       0.80 00:00:05.93
 01/29/11   10:38:22 UA1ASC     HHSSC24               00:00:04.66       0.71 00:00:06.56
 01/29/11   12:27:16 UGFG57     U200       ICEGENER   00:00:04.83       0.84 00:00:05.75
 01/29/11   10:29:24 KR9S2D     U120                  00:00:05.11       0.80 00:00:06.39
 01/29/11   12:26:18 UGFG57     S080                  00:00:06.01       0.84 00:00:07.15
 01/29/11   12:26:18 UGFG57     S080                  00:00:06.01       0.84 00:00:07.15
 01/29/11   07:57:12 UMI2MX     U700       ICEGENER   00:00:07.19       1.39 00:00:05.17
 01/29/11   02:06:59 QQMST3     S015                  00:00:09.90       1.63 00:00:06.07
 01/29/11   15:36:09 T0E9600C   S020                  00:00:09.94       1.23 00:00:08.08
 01/29/11   02:08:41 QQMST1     S016       ICEGENER   00:00:10.07       1.79 00:00:05.63

 ...

 01/29/11   01:09:01 UG7S90     S018       ICEGENER   00:00:22.70       4.05 00:00:05.60
 01/29/11   17:41:51 BCDD132X   UTEP0006   ICEGENER   00:00:23.06       4.18 00:00:05.52
 01/29/11   13:37:50 KAGPQL     U2         INZSQI20   00:00:28.67       0.89 00:00:32.21
 01/29/11   17:05:27 JA0PTD     AFGPTD40              00:00:29.64       2.03 00:00:14.60
 01/29/11   08:02:31 JA0PMG     AFGPMG05              00:00:37.89       3.77 00:00:10.05
 01/29/11   07:12:21 QMCSKS     S020       ICEGENER   00:00:47.43       7.68 00:00:06.18
 01/29/11   17:31:03 MA0UN5     AFGUN520              00:00:49.42       4.75 00:00:10.40
 01/28/11   23:49:31 BG7S90     S018       ICEGENER   00:00:54.27       8.39 00:00:06.47
 01/29/11   12:02:35 JR4SOR     S080                  00:01:04.30       5.16 00:00:12.46
 01/29/11   15:39:09 T0E2138X   UCP        ICEGENER   00:01:04.78      11.69 00:00:05.54
 01/29/11   15:34:37 KCDD122X   STEP0003   ICEGENER   00:01:11.41      13.27 00:00:05.38
 01/29/11   17:29:44 UCDD130X   STEP0003   ICEGENER   00:01:24.75      16.58 00:00:05.11
 01/29/11   15:22:21 KCDD122X   STEP0001   ICEGENER   00:01:30.63      16.60 00:00:05.46
 01/29/11   17:27:11 UCDD130X   STEP0002   ICEGENER   00:01:50.51      20.26 00:00:05.45
 01/29/11   10:49:21 UNP505     S020                  00:01:51.08      12.95 00:00:08.58
 01/29/11   15:29:29 KCDD122X   UTEP0002   ICEGENER   00:01:56.32      20.23 00:00:05.75
 01/29/11   13:07:29 UPXCOI     UXCOI02               00:02:03.11      19.86 00:00:06.20
 01/29/11   15:17:24 T0E2138X   U2                    00:05:01.29      39.26 00:00:07.67

 *** GRAND TOTAL (   633 ITEMS)                       00:40:04.59     397.34 00:00:06.05

See Other Sample SMF Reports