








	*SMF Tools*

Sample Report from SMF 119 Subtype 70 Records
Showing Information about each FTP File Transfer
Including the Host Names via Lookups from a VSAM file

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.

In this report, we read as input the SMF file and select just the type 119 subtype 70 FTP Server Transfer Completion records. (See SMF 119 Subtype 70 record layout.) The report shows information about FTP transfers, including remote and local IP values, FTP Command, transfer start time and the z/OS DSN of the file transferred. All of this information is stored in the SMF 119 record.

However, in this report we would also like to see the actual host names associated with the IPs. The host names do not appear in the SMF records. But we do have a local VSAM file which contains this information. To get the names, we just read two records from this VSAM file, using the two IPs as keys. Our report can now contain information from the SMF record and each of our two directly-read VSAM records.

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: STCKADJ(0)  NOGRANDTOTAL
 
* Define the SMF input file
INPUT: SMF119 NORMWHEN(SMF119RTY=119 AND SMF119STY=70)
        NORMALIZE(SMF11970_FTP_COMP_SECTION, SMF119S1Num)
 
* The VSAM file is an ipaddr-to-hostname translation table.
FILE:  IPKEYF DDNAME(IPKEY) TYPE(VSAM) LRECL(100)

* VSAM file record layout
FIELD: IP-ADDR LEN(15)
FIELD: IP-HOST LEN(8)
FIELD: IP-PLEX LEN(8)

* Sample record: 99.01.3.65    SYS1    PLEX01
* Associate SMF record fields to VSAM file fields.
* Note that the same VSAM file is used for both local and remote
* IP address translation.
READ:  IPKEYF READKEY(SMF119FT_FSDRIP_IPV4) RECNAME(FSDRIP)
READ:  IPKEYF READKEY(SMF119FT_FSDLIP_IPV4) RECNAME(FSDLIP)
 
* Include SMF records where the IP address is in the translation table.
IncludeIf: SMF119RTY = 119 and SMF119STY =  70
           and fsdlip.ip-host <> '        '
 
Title: '119 Subtype 70 - FTP server transfer completion ' /

Col: SMF119FT_FSSDate('Date')
     SMF119FT_FSSTime('Time')
     SMF119FT_FSCmd('Cmd')
     SMF119FT_FSFType('Type')
     SMF119FT_FSDRIP_IPV4('Rmt-ip')
* show hostname for remote IP address
     fsdrip.ip-host('Rmt-host')
     SMF119FT_FSDLIP_IPV4('Local-ip')
* show hostname for local IP address
     fsdlip.ip-host('Lcl-host')
     SMF119FT_FSSUser('Lcl-user')
     SMF119FT_FSfileName1(100 'Filename')

Produce This SMF Report:


119 Subtype 70 - FTP server transfer completion

  Date      Time     Cmd  Type     Rmt-ip      Rmt-host    Local-ip     Lcl-host Lcl-user                Filename
________ ___________ ____ ____ _______________ ________ _______________ ________ ________ _____________________________
 

11/11/13 23:05:19.09 STOR SEQ  181.59.217.216           99.01.4.102     SYS1     FTPJOB01 DATASET.GOING.OUT.D131102.#01
11/11/13 23:05:19.10 STOR SEQ  181.59.217.216           99.01.4.102     SYS1     FTPJOB01 DATASET.GOING.OUT.D131102.#02
11/11/13 23:25:45.22 RETR SEQ  131.156.225.182          99.01.4.98      SYS2     FTPJOB01 DATASET.GOING.OUT.D131102.#03
11/11/13 23:25:45.22 RETR SEQ  181.59.255.248           99.01.4.98      SYS2     FTPJOB01 DATASET.GOING.OUT.D131102.#04
11/11/13 23:25:45.22 RETR SEQ  120.1.64.111             99.01.4.98      SYS2     FTPJOB01 DATASET.GOING.OUT.D131102.#05
11/11/13 23:30:18.26 RETR SEQ  120.1.100.93             99.01.3.65      PLEX01   USERFTP  SMF.FILE.TO.COMMON
11/11/13 23:30:26.63 RETR SEQ  120.1.100.93             99.01.3.65      PLEX01   USERFTP  SMF.FILE.TO.COMMON
11/11/13 23:57:99.41 RETR SEQ  181.59.165.151           99.01.4.98      SYS2     FTPJOB01 DATASET.SPOOL.FILE.J03
12/11/13 00:02:30.40 RETR SEQ  120.1.100.93             99.01.3.65      PLEX01   USERFTP  DCOLLECT.FILE.#01
12/11/13 00:01:31.59 RETR SEQ  120.1.100.94             99.01.3.65      PLEX01   USERFTP  DCOLLECT.FILE.#02
12/11/13 00:02:50.33 RETR SEQ  120.1.100.93             99.01.3.65      PLEX01   USERFTP  DCOLLECT.FILE.#03
12/11/13 00:02:57.31 RETR SEQ  120.1.100.94             99.01.3.65      PLEX01   USERFTP  DCOLLECT.FILE.#04

See Other Sample SMF Reports

Sample Report from SMF 119 Subtype 70 Records Showing Information about each FTP File Transfer Including the Host Names via Lookups from a VSAM file

It's easy to report on SMF data!

These Spectrum SMF Writer Statements:

Produce This SMF Report:

Sample Report from SMF 119 Subtype 70 Records
Showing Information about each FTP File Transfer
Including the Host Names via Lookups from a VSAM file