|
Sample Report from SMF 100 Records (IFCID=1)
| |||||||||||||||||||||||||||
It's easy to report on SMF data!
| |
|
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!
|
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 100 DB2 accounting records with IFCID = 1. (See SMF 100 record layout.) It then prints a report line for each IFC destination entry found in these DB2 statistics records. (Note that each SMF record has a variable number of the QWSB sections containing the IFC destination information.) The report shows various error counts by destination.
All of this with just a couple of dozen lines of code!
Why not install a Spectrum SMF Writer trial right now and start making your own SMF reports!
OPTION: HDGSEP('/') /* CHANGE DEFAULT SEPERATOR CHAR */
OPTION: STCKADJ(0) /* DON'T CONVERT STCK TIMES TO GMT */
INPUT: SMF100 NORMWHEN(SM100RTY = 100 AND QWHSIID =1)
NORMALIZE(QWSB_SECTION, QWS00R2N)
TITLE: 'DB2 IFC DESTINATION STATISTICS'
TITLE: 'FROM SMF100 IFCID=1 RECORDS: QWSB SEGMENTS'
INC: SM100RTY = 100 AND QWHSIID =1
COL: SM100DTE('SMF DATE') SM100TME('SMF TIME')
SM100RTY(3 'REC')
QWHSIID(5 'IFCID')
QWSBNM('DEST/NAME')
QWSBSRSW('RECS/WRITTEN')
QWSBSRNW('RECS NOT/WRITTEN')
QWSBSBUF('BUFFER/ERRORS')
QWSBSACT('NOT ACTIVE/ERRORS')
QWSBSRNA('REC NOT/ACCEPTED')
QWSBSWF('WRITER/ERRORS')
DB2 IFC DESTINATION STATISTICS
FROM SMF100 IFCID=1 RECORDS: QWSB SEGMENTS
DEST RECS RECS NOT BUFFER NOT ACTIVE REC NOT WRITER
SMF DATE SMF TIME REC IFCID NAME WRITTEN WRITTEN ERRORS ERRORS ACCEPTED ERRORS
________ ___________ ___ _____ ____ ______________ ______________ ____________ ____________ ____________ ____________
06/12/09 12:03:46.55 100 1 SMF 286 0 0 0 0 0
06/12/09 12:03:46.55 100 1 RES 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 GTF 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 SRV 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 SR1 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 SR2 1 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP1 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP2 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP3 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP4 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP5 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP6 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP7 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 OP8 0 0 0 0 0 0
06/12/09 12:03:46.55 100 1 LOG 1 0 0 0 0 0
06/12/09 12:03:51.48 100 1 SMF 286 0 0 0 0 0
06/12/09 12:03:51.48 100 1 RES 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 GTF 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 SRV 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 SR1 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 SR2 1 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP1 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP2 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP3 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP4 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP5 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP6 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP7 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 OP8 0 0 0 0 0 0
06/12/09 12:03:51.48 100 1 LOG 2 0 0 0 0 0
06/12/09 12:03:52.19 100 1 SMF 447 0 0 0 0 0
06/12/09 12:03:52.19 100 1 RES 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 GTF 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 SRV 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 SR1 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 SR2 1 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP1 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP2 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP3 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP4 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP5 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP6 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP7 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 OP8 0 0 0 0 0 0
06/12/09 12:03:52.19 100 1 LOG 1 0 0 0 0 0
...
Home |
Products |
Documentation |
Prices |
Testimonials |
Company |
30-Day Trials
| FAQ
| Sample Reports
| SMF Records
Send Your Comments or Questions
