Sample Report from SMF 94 Records (IFCID=1)
Showing Tape Library System Statistics
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 94 subtype 1 tape library system records. (See SMF 94 record layout.) It selects the record for the hourly statistics for 11AM and prints various statistics for that hour.
All of this with just a few simple 4GL statements! 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) /* DON'T CONVERT STCK TIMES TO GMT */
TITLE: 'HOURLY TAPE STATISTICS FROM SMF 94 RECORDS FOR: 11AM'
INC: SMF94RTY = 94 AND SMF94STP = 1
AND SMF94HHI = 11
COMPUTE: SMF94ADV0-10 =
WHEN(SMF942OF <> 0) ASSIGN(SMF94ADV05 + SMF94ADV10)
COMPUTE: SMF94ADV10-20 =
WHEN(SMF942OF <> 0) ASSIGN(SMF94ADV15 + SMF94ADV20)
COMPUTE: SMF94ADV20-30 =
WHEN(SMF942OF <> 0) ASSIGN(SMF94ADV25 + SMF94ADV30)
COMPUTE: SMF94ADV30-40 =
WHEN(SMF942OF <> 0) ASSIGN(SMF94ADV35 + SMF94ADV40)
COMPUTE: SMF94ADV40-50 =
WHEN(SMF942OF <> 0) ASSIGN(SMF94ADV45 + SMF94ADV50)
COMPUTE: SMF94ADV50-100 =
WHEN(SMF942OF <> 0) ASSIGN(SMF94ADV55 + SMF94ADV60
+ SMF94ADV65 + SMF94ADV70
+ SMF94ADV75 + SMF94ADV80
+ SMF94ADV85 + SMF94ADV90
+ SMF94ADV95 + SMF94ADV00)
COMPUTE: THRES = WHEN(SMF942OF <> 0) ASSIGN(SMF94THRES)
COMPUTE: SRTCT = WHEN(SMF942OF <> 0) ASSIGN(SMF94SRTCT)
COMPUTE: PRICT = WHEN(SMF942OF <> 0) ASSIGN(SMF94PRICT)
COMPUTE: MTVCA = WHEN(SMF942OF <> 0) ASSIGN(SMF94MTVCA)
COL: SMF94DTE('SMF DATE') SMF94TME('SMF TIME')
SMF94HHI(4 'HOUR' NOACC)
SMF94MTO(6 BIZ 'TOTAL|MOUNTS|PENDING')
SMF94DTO(6 BIZ 'TOTAL|DISMOUNTS|PENDING')
SMF94MT3(6 BIZ 'AVG|MOUNT|TIME')
SMF94DT3(6 BIZ 'AVG|DISMOUNT|TIME')
SMF94ADV10-20(6 BIZ 'VOLS|10-20%|ACTIVE')
SMF94ADV20-30(6 BIZ 'VOLS|20-30%|ACTIVE')
SMF94ADV30-40(6 BIZ 'VOLS|30-40%|ACTIVE')
SMF94ADV40-50(6 BIZ 'VOLS|40-50%|ACTIVE')
SMF94ADV50-100(6 BIZ 'VOLS|50-100%|ACTIVE')
THRES(7 BIZ 'RECLAIM|THRESH|PERCENT')
SRTCT(7 BIZ 'SCRATH|STACKED|VOL CNT')
PRICT(7 BIZ 'PRIVATE|SCRATCH|VOL CNT')
MTVCA(7 BIZ 'MAX TAPE|VOLUME|CACHE|AGE')
Produce This SMF Report:
HOURLY TAPE STATISTICS FROM SMF 94 RECORDS FOR: 11AM
TOTAL TOTAL AVG AVG VOLS VOLS VOLS VOLS VOLS RECLAIM SCRATH PRIVATE VOLUME
MAX MOUNTS DISMOU MOUNT DISMOU 10-20% 20-30% 30-40% 40-50% 50-100 THRESH STACKED SCRATCH CACHE
SMF DATE SMF TIME HOUR DRIVES PENDIN PENDIN TIME TIME ACTIVE ACTIVE ACTIVE ACTIVE ACTIVE PERCENT VOL CNT VOL CNT AGE
________ ___________ ____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _______ _______ _______ ________
11/02/07 12:18:29.88 11 15 37 32 73 66 1 74 252 40 275 329 4,099
*** GRAND TOTAL ( 1 ITEM)
15 37 32 73 66 1 74 252 40 275 329 4,099