|
Sample Report from SMF 74 Subtype 4 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.
This report reads as input the SMF file and selects just the type 74 RMF Activity records with subtype = 4. (See SMF 74 record layout.) Each of these SMF records contains multiple Request Sections. We normalize these sections in order to easily print the same report information from each request section. We then print a report line for each Request Section, showing various statistics relating to synchronous and asynchronous requests during the interval. It also shows a count of certain requests for which no resource was available.
In this report, we take advantage of several of Spectrum's special formatting options. The BIZ ("blank if zero") option suppresses 0 values, which can clutter up a report. Also, since the SMF744SASQ field encompasses a wide range of values, we used a "scaled" type of picture to format it. Spectrum automatically displays a value with the appropriate K, M, G, ... suffix as necessary. This technique lets you display more data (in smaller columns) when it is not essential to know the exact value of a field.
We also used another technique to squeeze more data columns into the report. Since the identical Sysplex and System names appear for hundreds of consecutive lines, we moved those 2 fields from the detail report lines up into the page titles. We page-break on those fields to insure that the data on each page comes from a single Sysplex-System.
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: SCALEPICS /* ALLOW VARIABLY SCALED PICTURES */ INPUT: SMF744 NORMWHEN(SMF74RTY=74 AND SMF74STY=4) NORMSMF(SMF744SO) INCLUDEIF: SMF74RTY=74 AND SMF74STY=4 TITLE: #DATE / 'RMF COUPLING ACTIVITY REPORT' / 'PAGE' #PAGENUM TITLE: 'SYSPLEX:' SMF74XNM 'SYSTEM:' SMF74SNM COLUMNS: SMF744SNAM('CONNECTED|STRUCTURE') SMF74IST('INTERVAL|START|TIME') SMF74INT_TIME(TP'ZZ:Z9.999' 'INTERVAL|LENGTH') SMF744SSIZ(8 'STRUCT|SIZE' BIZ) SMF744SARC_VAL('TOTAL|ASYNCH|OPERS' 8 BIZ) SMF744SASQ('SUM|SQRS|SERVIC|TIME|ASYNCH' 6 P'Z,ZZ9@' BIZ) SMF744SATM('SUM|SERVIC|TIME|ASYNCH' 10 BIZ) SMF744SSTA_VAL('ASYNCH|REQS|NO RESRC' 8 BIZ) SMF744SSRC_VAL('CNT|TIMES|SYNCH|REQS' 8 BIZ) SMF744SSSQ('SUM-SQRS|SERVIC|TIME|SYNCH' 10 BIZ) SMF744SSTM('SUM|SERVIC|TIME|SYNCH' 10 BIZ) SORT: SMF74XNM SMF74SNM SMF74DTE SMF74TME SMF744SNAM BREAK: SMF74SNM SPACE(PAGE)
08/14/07 RMF COUPLING ACTIVITY REPORT PAGE 1 SYSPLEX: SYSPL9 SYSTEM: S01 SUM SQRS SUM CNT SUM-SQRS SUM INTERVAL TOTAL SERVIC SERVIC ASYNCH TIMES SERVIC SERVIC CONNECTED START INTERVAL STRUCT ASYNCH TIME TIME REQS SYNCH TIME TIME STRUCTURE TIME LENGTH SIZE OPERS ASYNCH ASYNCH NO RESRC REQS SYNCH SYNCH ________________ ________ _________ ________ ________ ______ __________ ________ ________ __________ __________ ACF2_LIDS 09:30:00 10:00.000 50,048 16,034 1,004M 2,013,709 68 184,508 3,490 BERVM_SMI1 09:30:00 10:00.000 2,304 BERVM_SMS2 09:30:00 10:00.000 2,304 3,459 200M 472,144 13 261,598 1,150 BERVM_SMS3 09:30:00 10:00.000 2,304 1,025 28M 104,325 5 9,526 208 BERVM_SMT0 09:30:00 10:00.000 2,304 1,352 76M 160,125 3 4 15,481 241 BERVM_SMZ0 09:30:00 10:00.000 2,304 885 18M 87,762 6 17,237 307 BERVM_SM10 09:30:00 10:00.000 2,304 1,070 91M 177,594 5 230,667 667 CRAF_HBP0 09:30:00 10:00.000 12,544 445 14M 51,859 93 111,532 2,456 CRAF_HBP0 09:30:00 10:00.000 12,672 128 6,997K 20,516 CRAF_HBP1 09:30:00 10:00.000 20,224 117 3,568K 16,920 8 4,659 193 CRAF_HBP1 09:30:00 10:00.000 20,096 367 16M 50,839 14 26 15,918 642 CRAF_HBP16K0 09:30:00 10:00.000 5,376 14 1,471K 2,474 16 9,661 393 CRAF_HBP16K0 09:30:00 10:00.000 5,376 CRAF_HBP2 09:30:00 10:00.000 24,576 46 758K 5,104 6 3,270 140 CRAF_HBP2 09:30:00 10:00.000 24,448 183 2,708K 17,469 55 30,184 1,276 CRAF_HBP32K 09:30:00 10:00.000 13,824 63 1,575K 7,444 33 21,962 850 CRAF_HBP32K 09:30:00 10:00.000 13,824 33 674K 3,280 CRAF_HBP8 09:30:00 10:00.000 640 CRAF_HBP8 09:30:00 10:00.000 640 14 176K 1,311 15 9,393 375 CRAF_HBP8K0 09:30:00 10:00.000 5,632 191 5,466K 24,221 21 25,874 640 CRAF_HBP8K0 09:30:00 10:00.000 5,632 9 1,132K 2,970 CSAF_LOCK1 09:30:00 10:00.000 8,064 2,658 53M 220,344 10,652 *****S**** 264,935 CSAF_SCA 09:30:00 10:00.000 8,192 1,588 167M 244,692 8 52,673 649 CTBA_GBP0 09:30:00 10:00.000 2,688 37 535K 3,595 CTBA_GBP0 09:30:00 10:00.000 2,688 71 1,601K 6,251 41 28,214 1,074 CTBA_GBP1 09:30:00 10:00.000 2,304 14 217K 1,213 14 9,086 356 CTBA_GBP1 09:30:00 10:00.000 2,304 CTBA_GBP11 09:30:00 10:00.000 1,920 CTBA_GBP11 09:30:00 10:00.000 1,920 14 134K 1,108 14 8,815 351 CTBA_GBP16K0 09:30:00 10:00.000 896 15 272K 1,488 14 8,664 348 CTBA_GBP16K0 09:30:00 10:00.000 1,024 CTBA_GBP2 09:30:00 10:00.000 2,816 30 629K 3,219 CTBA_GBP2 09:30:00 10:00.000 2,688 56 772K 4,903 33 23,489 879 CTBA_GBP21 09:30:00 10:00.000 1,408 CTBA_GBP21 09:30:00 10:00.000 1,408 14 119K 1,054 14 8,754 350 CTBA_GBP32K 09:30:00 10:00.000 1,664 57 1,087K 5,867 31 21,332 812 CTBA_GBP32K 09:30:00 10:00.000 1,792 29 414K 2,642 CTBA_GBP8K0 09:30:00 10:00.000 2,048 30 352K 2,486 CTBA_GBP8K0 09:30:00 10:00.000 2,048 55 807K 5,043 34 23,816 898 CTBA_LOCK1 09:30:00 10:00.000 3,072 1,046 8,942K 78,236 3,400 22,415,563 81,367 CTBA_SCA 09:30:00 10:00.000 3,456 1,759 59M 253,463 1 13 84,538 1,048 CTLF_GBP0 09:30:00 10:00.000 8,448 10 122K 1,012 CTLF_GBP0 09:30:00 10:00.000 8,320 37 782K 4,313 16 10,471 409 CTLF_GBP1 09:30:00 10:00.000 12,544 15 359K 1,459 13 8,241 327 CTLF_GBP1 09:30:00 10:00.000 12,672 CTLF_GBP16K0 09:30:00 10:00.000 1,664 30 262K 2,249 CTLF_GBP16K0 09:30:00 10:00.000 1,664 56 443K 3,703 33 6,709,361 3,423 CTLF_GBP2 09:30:00 10:00.000 8,320 15 389K 1,656 13 8,141 325 CTLF_GBP2 09:30:00 10:00.000 8,448 CTLF_GBP32K 09:30:00 10:00.000 3,584 30 272K 2,255 CTLF_GBP32K 09:30:00 10:00.000 3,584 57 1,922K 6,194 32 22,436 846 08/14/09 RMF COUPLING ACTIVITY REPORT PAGE 2 SYSPLEX: SYSPL9 SYSTEM: S01 SUM SQRS SUM CNT SUM-SQRS SUM INTERVAL TOTAL SERVIC SERVIC ASYNCH TIMES SERVIC SERVIC CONNECTED START INTERVAL STRUCT ASYNCH TIME TIME REQS SYNCH TIME TIME STRUCTURE TIME LENGTH SIZE OPERS ASYNCH ASYNCH NO RESRC REQS SYNCH SYNCH ________________ ________ _________ ________ ________ ______ __________ ________ ________ __________ __________ CTLF_GBP8K0 09:30:00 10:00.000 4,096 15 353K 1,473 13 7,933 321 CTLF_GBP8K0 09:30:00 10:00.000 4,096 CTLF_LOCK1 09:30:00 10:00.000 4,992 1,214 11M 94,508 4,807 88,328,922 125,032 CTLF_SCA 09:30:00 10:00.000 3,328 1,581 51M 225,834 4 26,085 323 CTOC_GBP0 09:30:00 10:00.000 3,456 50 1,690K 5,850 CTOC_GBP0 09:30:00 10:00.000 3,456 117 8,598K 16,027 32 22,793 853 CTOC_GBP1 09:30:00 10:00.000 5,376 112,254 9,213M 18,493,219 4 3,040 35,668,753 110,881 CTOC_GBP1 09:30:00 10:00.000 5,376 555 21M 84,176 CTOC_GBP16K0 09:30:00 10:00.000 1,280 CTOC_GBP16K0 09:30:00 10:00.000 1,280 14 105K 1,061 14 8,260 340 CTOC_GBP2 09:30:00 10:00.000 5,504 1,033 115M 222,123 787 38,159,579 24,539 CTOC_GBP2 09:30:00 10:00.000 5,504 732 39M 127,868 1 529 23 CTOC_GBP32K 09:30:00 10:00.000 1,536 30 320K 2,389 CTOC_GBP32K 09:30:00 10:00.000 1,536 58 895K 4,993 33 5,624,615 3,203 CTOC_GBP8K0 09:30:00 10:00.000 2,048 56 626K 4,361 33 22,278 856 CTOC_GBP8K0 09:30:00 10:00.000 2,048 30 725K 3,022 CTOC_LOCK1 09:30:00 10:00.000 4,096 5,707 130M 520,062 10,994 *****S**** 338,972 CTOC_SCA 09:30:00 10:00.000 1,920 1,606 55M 242,189 1 6 39,090 484 CTTF_GBP0 09:30:00 10:00.000 8,320 919 26M 112,207 1 529 23 CTTF_GBP0 09:30:00 10:00.000 8,320 4,400 325M 645,466 153 1,551,026 6,028 CTTF_GBP1 09:30:00 10:00.000 32,512 57,719 2,150M 5,634,117 1,071 6,178 33,254,757 163,883 CTTF_GBP1 09:30:00 10:00.000 32,640 5,404 206M 724,337 81 45,930 1,924 CTTF_GBP16K0 09:30:00 10:00.000 5,376 CTTF_GBP16K0 09:30:00 10:00.000 5,376 15 77K 951 13 8,035 323 CTTF_GBP2 09:30:00 10:00.000 32,512 17,088 1,177M 2,471,064 1,131 7,981 61,967,099 203,089 CTTF_GBP2 09:30:00 10:00.000 32,512 3,385 423M 515,302 151 84,553 3,571 CTTF_GBP32K 09:30:00 10:00.000 10,752 656 64M 165,137 42 21,778 956 CTTF_GBP32K 09:30:00 10:00.000 10,752 1,293 108M 319,735 191 351,906 5,634 CTTF_GBP8 09:30:00 10:00.000 512 318 3,979K 26,878 251 109,958 5,242 CTTF_GBP8 09:30:00 10:00.000 512 13 460K 2,267 CTTF_GBP8K0 09:30:00 10:00.000 5,632 270 9,077K 39,335 CTTF_GBP8K0 09:30:00 10:00.000 5,632 1,160 42M 140,510 68 174,474 2,032 CTTF_LOCK1 09:30:00 10:00.000 29,184 25,062 730M 2,086,495 72,151 *****S**** 1,831,872 CTTF_SCA 09:30:00 10:00.000 8,192 1,667 90M 248,925 5 31,698 398 CTZF_GBP0 09:30:00 10:00.000 7,552 129 6,075K 20,228 1 841 29 CTZF_GBP0 09:30:00 10:00.000 7,552 479 20M 73,993 1 36 24,738 942 CTZF_GBP1 09:30:00 10:00.000 15,104 2,328 85M 325,305 145 431,041 4,537 CTZF_GBP1 09:30:00 10:00.000 15,104 1,080 37M 146,591 7 3,848 164 CTZF_GBP16K0 09:30:00 10:00.000 1,664 30 368K 2,500 CTZF_GBP16K0 09:30:00 10:00.000 1,664 57 745K 4,820 31 21,507 815 CTZF_GBP2 09:30:00 10:00.000 8,576 455 27M 61,207 40 30,271 1,085 CTZF_GBP2 09:30:00 10:00.000 8,576 298 22M 41,913 1 784 28 CTZF_GBP32K 09:30:00 10:00.000 2,304 29 1,461K 3,752 CTZF_GBP32K 09:30:00 10:00.000 2,304 56 1,006K 5,024 34 23,225 887 CTZF_GBP8 09:30:00 10:00.000 512 117 1,930K 12,466 38 29,333 1,015 CTZF_GBP8 09:30:00 10:00.000 640 67 1,486K 8,575 CTZF_GBP8K0 09:30:00 10:00.000 4,864 42 1,794K 7,158 3 1,638 70 CTZF_GBP8K0 09:30:00 10:00.000 4,864 184 15M 37,988 54 27,391 1,213 CTZF_LOCK1 09:30:00 10:00.000 5,888 4,592 144M 384,811 8,320 *****S**** 230,595 CTZF_SCA 09:30:00 10:00.000 3,328 1,861 94M 284,565 5 31,692 398 DFHXQLS_DFHTSA01 09:30:00 10:00.000 1,408 ...
Home |
Products |
Prices |
Documentation |
30-Day Trials |
Customer Reviews |
Company
| FAQ
| Sample Reports
| SMF Records
Send Your Comments or Questions