|
Sample Report from SMF 64 Records
| ||||||||||||||||||||||||||||||||||||||
It's easy to report on SMF data!
| |
|
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 64 VSAM statistics records. (See SMF 64 record layout.) The report shows various VSAM statistics as of OPEN time. The statistics include number of extents, number of logical records, cumulative number of records inserted and deleted, and the cumulative number of control interval and control area splits, etc.
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!
INPUT: SMF64
INCLUDEIF: SMF64RTY = 64
TITLE: 'VSAM COMPONENT/CLUSTER STATS FROM SMF 64 RECORDS'
COLUMNS:
SMF64_JOBID('JOBNAME AND READER TIME')
SMF64VSN('VOLUME')
SMF64CUU('DEVICE' HEX)
SMF64FCC('BEG|CCCHH' HEX)
SMF64TCC('END|CCCHH' HEX)
SMF64NEX('NUM|CEXTENTS' 7)
SMF64NLR('NUM|CRECS' 9)
SMF64NDE('NUM|CDELETES' 9)
SMF64NCS('NUM|CCI|CSPLITS' 5)
SMF64NAS('NUM|CCA|CSPLITS' 5)
SMF64NEP('NUM|CEXCPS' 8)
SORT: SMF64_JOBID(1) /* SORT AND BREAK ON UNIQUE JOB */
VSAM COMPONENT/CLUSTER STATS FROM SMF 64 RECORDS
NUM NUM
BEG END NUM NUM NUM CI CA NUM
JOBNAME AND READER TIME VOLUME DEVICE CCHH CCHH EXTENTS RECS DELETES SPLIT SPLIT EXCPS
_____________________________ ______ ______ ________ ________ _______ _________ _________ _____ _____ ________
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 04EF0000 0520000E 1 2 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 0009000C 0009000E 1 1 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 04BD0000 04EE000E 1 2 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 00090009 0009000B 1 1 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 02DA0000 030B000E 1 2 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 04EF0000 0520000E 1 2 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 0009000C 0009000E 1 1 0 0 0 3
CICSDNMS 05/23/08 19:59:40.05 SQK102 7308 00090006 00090008 1 1 0 0 0 3
*** TOTAL FOR CICSDNMS 05/23/08 19:59:40.05 ( 8 ITEMS) 8 12 0 0 0 24
DLISET82 05/23/08 22:13:47.86 DB4D03 5D03 26C50000 26CE000E 15 1,115,761 25,946 1,273 0 303,715
DLISET82 05/23/08 22:13:47.86 DB4DSP 5F06 00920002 00920004 12 296,178 1 162 17 64,141
*** TOTAL FOR DLISET82 05/23/08 22:13:47.86 ( 2 ITEMS) 27 1,411,939 25,947 1,435 17 367,856
ERPTRKIL 07/24/06 11:49:50.74 SQK102 7308 04EF0000 0520000E 4 142,235 0 0 0 4
ERPTRKIL 07/24/06 11:49:50.74 SQK102 7308 0009000C 0009000E 4 226 0 0 0 234
ERPTRKIL 07/24/06 11:49:50.74 SQK051 640A 02190000 027C000E 1 0 0 0 0 0
ERPTRKIL 07/24/06 11:49:50.74 SQK051 640A 00090000 00090005 1 0 0 0 0 0
ERPTRKIL 07/24/06 11:49:50.74 SQK102 7308 04EF0000 0520000E 4 142,235 0 0 0 3
ERPTRKIL 07/24/06 11:49:50.74 SQK102 7308 0009000C 0009000E 4 226 0 0 0 3
ERPTRKIL 07/24/06 11:49:50.74 SQK102 7308 04EF0000 0520000E 4 142,235 0 0 0 4
ERPTRKIL 07/24/06 11:49:50.74 SQK102 7308 0009000C 0009000E 4 226 0 0 0 8
*** TOTAL FOR ERPTRKIL 07/24/06 11:49:50.74 ( 8 ITEMS) 26 427,383 0 0 0 256
NETSA01 05/23/08 19:57:23.62 TPRD07 2A18 00200000 0020000E 1 1 0 0 0 2
NETSA01 05/23/08 19:57:23.62 TPRD07 2A18 00200000 0020000E 1 1 0 0 0 2
NETSA01 05/23/08 19:57:23.62 TPRD07 2A18 0009000E 0009000E 1 1 0 0 0 3
NETSA01 05/23/08 19:57:23.62 TPRD04 2F21 07050000 0705000E 1 1 0 0 0 2
NETSA01 05/23/08 19:57:23.62 TPRD04 2F21 00A60008 00A60008 1 1 0 0 0 3
NETSA01 05/23/08 19:57:23.62 TPRD04 2F21 07050000 0705000E 1 0 0 0 0 0
NETSA01 05/23/08 19:57:23.62 TPRD04 2F21 00A60008 00A60008 1 0 0 0 0 0
*** TOTAL FOR NETSA01 05/23/08 19:57:23.62 ( 7 ITEMS) 7 5 0 0 0 12
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 05160000 0529000E 1 22 0 0 0 5
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 05160000 0529000E 1 22 0 0 0 5
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 05160000 0529000E 1 22 0 0 0 5
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 052A0000 053D000E 1 440 0 0 0 583
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 05160000 0529000E 1 440 0 0 0 582
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 052A0000 053D000E 1 0 0 0 0 0
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 052A0000 053D000E 1 22 0 0 0 5
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 052A0000 053D000E 1 22 0 0 0 5
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 05160000 0529000E 1 22 0 0 0 5
RMFDSP 05/23/08 19:58:58.13 TPVOL1 2A10 05160000 0529000E 1 22 0 0 0 5
...
Home |
Products |
Prices |
Documentation |
30-Day Trials |
Customer Reviews |
Company
| FAQ
| Sample Reports
| SMF Records
Send Your Comments or Questions
