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)
* 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 ' /
* show hostname for remote IP address
* show hostname for local IP address
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 22.214.171.124 99.01.4.102 SYS1 FTPJOB01 DATASET.GOING.OUT.D131102.#01
11/11/13 23:05:19.10 STOR SEQ 126.96.36.199 99.01.4.102 SYS1 FTPJOB01 DATASET.GOING.OUT.D131102.#02
11/11/13 23:25:45.22 RETR SEQ 188.8.131.52 99.01.4.98 SYS2 FTPJOB01 DATASET.GOING.OUT.D131102.#03
11/11/13 23:25:45.22 RETR SEQ 184.108.40.206 99.01.4.98 SYS2 FTPJOB01 DATASET.GOING.OUT.D131102.#04
11/11/13 23:25:45.22 RETR SEQ 220.127.116.11 99.01.4.98 SYS2 FTPJOB01 DATASET.GOING.OUT.D131102.#05
11/11/13 23:30:18.26 RETR SEQ 18.104.22.168 99.01.3.65 PLEX01 USERFTP SMF.FILE.TO.COMMON
11/11/13 23:30:26.63 RETR SEQ 22.214.171.124 99.01.3.65 PLEX01 USERFTP SMF.FILE.TO.COMMON
11/11/13 23:57:99.41 RETR SEQ 126.96.36.199 99.01.4.98 SYS2 FTPJOB01 DATASET.SPOOL.FILE.J03
12/11/13 00:02:30.40 RETR SEQ 188.8.131.52 99.01.3.65 PLEX01 USERFTP DCOLLECT.FILE.#01
12/11/13 00:01:31.59 RETR SEQ 184.108.40.206 99.01.3.65 PLEX01 USERFTP DCOLLECT.FILE.#02
12/11/13 00:02:50.33 RETR SEQ 220.127.116.11 99.01.3.65 PLEX01 USERFTP DCOLLECT.FILE.#03
12/11/13 00:02:57.31 RETR SEQ 18.104.22.168 99.01.3.65 PLEX01 USERFTP DCOLLECT.FILE.#04