Home

How to Make an SMF Report.fm

1. 89 Hardware Capacity and Stastistics Report from SMF 113 91 Buffer Pool Statistics Report from SMF 115 92 Queue CPU Time Report from SMF 116 93 TCP Connection Report from SMF 119 2 94 OpenSSH SFTP Transfer Report from SMF 119 96 and 119 97 95 FTP Transfers Report from SMF 119 70 97 Java CPU Times Report from SMF 120 5 98 WebContainer Servlet Times Report from SMF 120 7 99 Introduction This tutorial teaches you how to use Spectrum SMF Writer control statements to request custom reports from your SMF files Spectrum SMF Writer s language is non procedural which means you describe the result you want not the programming steps needed to do it And that means you can produce new reports in a matter of minutes rather than days or weeks You will describe your report with a few simple control statements You can create an SMF report with as few as three control statements For example INPUT SMF14 INCLUDEIF SMF14RTY 14 COLUMNS SMF14DTE SMF14TME SMF14JBN SMF14PGN SMF14T
2. m eye PHYSICAL CPU S N 04299E LPARS ONLINE TIME PERCENTAGE REPORT 03 02 10 FAMILY amp MODEL 2094 742 BY LOGICAL PROCESSOR PAGE 2 CAPACITY 387 MSU S 15 00 MINUTE INTERVAL ENDING 11 02 07 AT 12 00 106 ACTUAL EFFECT PCT PROC PCT PROC WEIGHT RMF ONLINE WAIT PCT DISPATCH EFF DISP PROC ADDR FACTOR INTERVAL TIME ONLINE TIME WAIT TIME DISP TIME DISP SYSTEM 73 SYSTEM NAME J80 PARTITION NUM 2 PARTITION NAME J80 LPAR CLUSTER UTCPLXJ8 LPAR DEFINED CAPACITY LIMIT 0 MSU S STORAGE 112 640 MB LOGICAL PROCESSOR INFO 47 PROCESSORS de de ae de ae ae 3e oe ae de ae ae 3e cooooooomn m e eee de ae ae cOooooococorm CO OO CS Sa lt Ce ORN de de 99 de 99 se se se se e gt lt gt Ce gt gt Figure 15 This report features nested normalization of SMF sections and customized break headings Spectrum SMF Writer Tutorial 55 is a summary of what we learned in this lesson e useoneor more statistical parms to request that statistical lines print at a control break e use HEADING and FOOTING parms in your BREAK statement to completely customize the lines printed around your control groups e the custom lines that you
3. TITLE JES2 JOB STATISTICS TITLE FOR EACH QUARTER HOUR OF THE DAY KKK KKK KKK ee ee ee k ee ek ee ek ee ke KEK kok kok KK KKK ek ee ek k kok COMPUTE SOME SPECIAL VALUES FOR THE REPORT FEI III II COMPUTE BEG TIME WHEN SMF30RST lt gt 00 00 ASSIGN SMF3ORST RDR ELSE ASSIGN SMF30SIT INIT COMPUTE TIME WHEN BEG TIME WHEN BEG TIME WHEN BEG TIME WHEN BEG TIME WHEN BEG TIME WHEN BEG TIME 00 15 00 ASSIGN 00 00 00 30 00 ASSIGN 00 15 00 45 00 ASSIGN 00 30 01 00 00 ASSIGN 00 45 01 15 00 ASSIGN 01 00 01 30 00 ASSIGN 01 15 70 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports These Control Statements cont HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN
4. 36 Using COMPUTEs to Report on Different SMF Record Types 38 Lesson 8 How to Specify the Sort Order and Control Breaks 42 How to Use the SORT 1 4 42 How to Use the BREAK Statement esee m me 44 Control Break Spacing Ress re eee REI EET er Rc eee eae RES 44 How to Create a Summary 1 2 2 46 Multple Control Breaks u u edu us ata uya M DER b reed 48 Lesson 9 Customizing the Control Breaks 51 How to Print Statistics at a Control 51 Customized Break Heading and Footing Lines 51 Using Break Headings for Hierarchical Report Layouts 53 Appendix A Conditional Expressions 57 Appendix B Examples of SMF Reports 60 Examples of SMF Reports 60 CICS Up Time Report from SMF 5 60 Dataset Usage by Jobname from SMF 14 Records 62 Count of Tasks by Type of Work
5. 01 400 5 122 1 VPWRKC 256 01 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B AP400 ASM 13 1 VPWRKC 256 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 7 4 SYST1B 6 160 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B SPFTEMPO CNT b 176 5 5 320 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B SPFTEMPO CNT 4 7 800 10 06 17 09 12 48 31 95 01 5 19 166 1 SYSTIE 27 998 SMF101 06 17 09 12 48 31 95 BATMDM BATCH TTAPO1B SW COPYLIB 39 7 5 5 23 440 SMF10 06 17 09 12 48 31 95 BATMDM BATCH TTAPO1B AP400 LOADLI 20 28 VPWRKB 23 440 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER 01 400 5 42 7 VPWRKC 23 440 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF b 4 SYSTIB 6 160 01 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 6 4 SYST1B 6 160 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 6 4 SYSTIB 6 160 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 6 4 SYSTIB 6 160 01 06 17 09 12 45 56 94 001 SOOTHER TTAPO1B ISPF ISPPROF 6 4 SYSTIB 6 160 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISR2469 BACK 6 iL 1 296 01 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 5 4 SYSTIB 6 160 TAPO1B 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B SPFTEMPO CNT 6 176 5 5 320 01 06 17 09 12 45 56 94 5001 SOOTHER 01 5 0 5 AE 800
6. Spectrum SMF Writer Tutorial 93 Appendix B Examples of SMF Reports TCP Connection Report from SMF 119 2 Records In this report we read as input the SMF file and select just the type 119 subtype 2 TCP Connection Termination records The report shows information about terminated TCP connections including start time end time and computed elapsed time It also shows the total number of bytes sent and received during the connection and the termination code The record definition also expands the 1 byte termination code into a readable descriptive text See this in member REC119 of your Spectrum SMF copy library The report is grouped by TCP IP Stack and Resource The report includes subtotals for each Resource These Control Statements INPUT SMF119 LIST YES INCLUDEIF SMF119RTY 119 AND SMF119STY 2 COMPUTE MY DURATION 2 5 119 TTEDATE 86400 MAKENUM SMF119AP_TTETIME 4MAKENUM SMF119AP TTSDATE 86400 MAKENUM SMF119AP_TTSTIME TITLE Z OS TCP DAILY CONNECTIONS REPORT TITLE SYSTEM 5 119 SYSNAME SYSPLEX SMF119TI SYSPLEXNAME STACK 5 119 STACK TITLE SORTED BY STACK AND RESOURCE NAME COLUMNS SMF119AP TTRNAME RESOURCE SMF119AP TTSDATE DATE STARTED SMF119AP TTSTIME TIME STARTED SMF119AP TTEDATE DATE ENDED SMF119AP TTETIME TIME ENDED MY DURATION CONNECTION DURATION HH MM SS SS ACCUM 77 77 79 99
7. Rights Reserved Pacific Systems Group PO Box 790 Lake Oswego OR 97034 Toll Free 1 800 572 5517 International 1 503 675 5982 WWW pacsys com Table of Contents IntPodue lom 5 ul e Game eua Seals e du a dee ek 1 Lesson 1 How to Make an SMF Report 5 3 How to Use the INPUT 2 3 How to Use the INCLUDEIF Statement 4 5 How to Use the COLUMNS 5 Putting Together 22 eps hi oA 6 What Files and Fields Are Available 6 What about non SME Files Reg CP ice td cw add 6 Lesson 2 How to Export SMF Data to PC 9 Making Multiple Reports Export Files ina Single 11 Lesson 3 How to Report on Multiple Occurrences of a 13 Reporting on Data from the First Occurrence of a Section 14 Reporting on Data from Occurrences of a 15 How to Normalize Multiple Nested Sections 19 Lesson 4 How to Make Y
8. 119 _ TINBYTES INBOUND BYTES SMF119AP TTOUTBYTES OUTBOUND BYTES SMF119AP TTTERMCODE HEX TERM CODE SMF119AP TTTERMCODE DESC TERM CODE DESC SORT 5 119 STACK SMF119AP TTRNAME SMF119AP TTSDATE SMF119AP TTSTIME BREAK SMF119AP TTRNAME Produce this Report 7 05 TCP DAILY CONNECTIONS REPORT SYSTEM 5 SYSPLEX SYPROD STACK SO1QDAS SORTED BY STACK AND RESOURCE NAME CONNECTION DATE TIME DATE TIME DURATION INBOUND OUTBOUND TERM RESOURCE STARTED STARTED ENDED ENDED HH MM SS SS BYTES BYTES CODE TERM CODE DESC 5 03 21 09 14 04 06 81 03 21 09 14 04 07 46 0 65 257 537 3 052 61 CLIENT SENT 5 03 21 09 14 05 35 59 03 21 09 14 05 45 67 10 08 27 043 329 52 APPL ISSUED CLOSE 5 03 21 09 14 12 13 81 03 21 09 14 12 14 51 0 70 257 537 3 052 61 CLIENT SENT 5 03 21 09 14 12 27 35 03 21 09 14 12 37 42 10 07 27 043 329 52 APPL ISSUED CLOSE 5 03 21 09 15 30 34 96 03 21 09 15 30 35 64 0 68 257 3537 3 052 61 CLIENT SENT RESET 5 03 21 09 15 35 13 92 03 21 09 15 35 24 00 10 08 27 043 329 52 APPL ISSUED CLOSE TOTAL FOR 5 6 ITEMS 32 26 853 740 10 143 94 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports OpenSSH SFTP Transfer Report from SMF 119 96 and 119 97 Records In the first report we read the SMF file and select just the type 119 subtype 96 OpenSSH Server Transfer Completion
9. 5 119597 SSH FCLPORT Lclport 12 P ZZZZZZ9 5 119597 SSH FCRIP Remote 5 119597 SSH FCRPORT Rmtport 12 P ZZZZZZ9 5 119597 SSH FCUSERID Userid 20 5 119597 SSH FCPATH Path 40 Produce this Report 119 97 CLIENT TRANSFER COMPLETION RECORD System Asname Userid Cmd Mode Begdate Begtime Duration Bytes Stat Local IP Lclport Remote Rmtport Userid Path 5 51 VXATP70I PGASHC PUT S 28 02 11 03 00 44 19 00 00 00 00 144 OK 11 22 33 2 36823 123 234 567 999 22 244112 data browse tmp LogFile 20110228 030042 83952264 5 51 I4ATP70I PGAI4A PUT A 8 28 02 11 03 14 30 93 00 00 00 01 144 0 11 22 33 2 37744 123 234 567 999 22 zutil2 data browse tmp LogFile 20110228 031429 83953426 SYS2 VXATP70I PGASHC PUT S 01 03 11 03 04 34 61 00 00 00 00 144 OK 11 22 33 6 32453 123 234 567 999 22 zutil2 data browse tmp LogFile 20110301 030432 67241185 5 51 I4ATP70I PGAI4A PUT A 01 03 11 03 05 54 57 00 00 00 00 144 OK 11 22 33 2 7441 123 234 567 999 22 zutil2 data browse tmp LogFile 20110301 030553 67175216 SYS2 VXATP7OI PGASHC PUT A S 02 03 11 03 02 27 21 00 00 00 00 144 OK 11 22 33 6 45256 123 234 567 999 22 201112 data browse tmp LogFile 20110302 030224 84019194 5 52 14 701 PGAI4A PUT A S 02 03 11 03 21 33 48 00 00 00 00 144 OK 11 22 33 6 46235 123 234 567 999 22 zutil2 data browse tmp LogFile 20110302 032132 67240410 SYS2 VXATP70I PGASHC PUT S 03 03 11 03
10. The above control statements produce the report in Figure 4 That report shows data for all of the EXCP sections in the type 30 records Notice that the data from the other non EXCP sections which all occur only once in the physical record is the same in all of the logical EXCP records created from the physical SMF record Normalizing Non Standard Sections Some repeating sections especially in the newer SMF records are not defined by standard triplets To use the NORMSMF parm there must be a standard triplet defined as an 8 byte area in the SMF record containing a 4 byte offset to the first segment a 2 byte length for each segment and a 2 byte number of segments present in that order There are non standard repeating segments in some SMF records For example the SMF120 subtype 7 record uses 4 bytes each for the offset length and number of segments See fields SMF120WA1 SMF120WA2 and SMF120WA3 Another example the SMF 70 records define one repeating section by specifying the beginning section number within a repeating section to start with rather than an offset from the beginning of the record It also uses 4 byte field to specify how many times the segment occurs The length of those sections is specified in a non contiguous field elsewhere in the record See fields SMF70BDS SMF70BDN and SMF70BCL The two non standard sections described above can be handled with the NORMALIZE parm This parm is discussed in t
11. COL SMF SMF SMF SMF SMF SMF ACT SMF SMF SMF SMF SMF 20RST 3 SUB 20TME SMF T 20WAA 6 TRAN 20WAB 8 TRAN 20WAF ACTIV 20WAG ACTIV DUR ACTIVITY 20CL4 CELL 20 04 20WAH 4 NUM 20WAQ EBC 20 20CPU CPU T SUBTYPE 7 WEBCONTAINER ACTIVITY S SERVER HOST S SERVER NAME TY START TY END DURATION TPIC Z9 999999 1 SESS CREA BIZ SERVLET NAME TPIC ZZ Z9 999999 Produce this Report 7 05 WEBSPHERE APPLICATION SMF 120 DATA SUBTYPE 7 WEBCONTAINER ACTIVITY TRANS RANS NUM SUB SERVER SERVER ACTIVITY ACTIVITY ACTIVITY SESS SERVLET CPU SMF TIME 05 START END DURATION CELL NODE CREA NAME TIME 7 00 00 01 50 AWX4 451 04 59 56 643606 04 59 56 676287 0 032681 ATX4 ATX44 en_US common locale 0 000034 7 00 00 01 50 AWX4 ATX4S1C 04 59 56 643606 04 59 56 676287 0 032681 ATX44 en_US common recent 0 000030 7 00 00 01 50 AWX4 451 04 59 56 643606 04 59 56 676287 0 032681 ATX4 44 en US common footer 0 000027 7 00 00 01 50 AWX4 451 04 59 56 643606 04 59 56 676287 0 032681 ATX44 en_US common header 0 000170 7 00 00 01 50 AWX4 ATX4S1C 04 59 56 643606 04 59 56 676287 0 032681 44 en US cp TPAInvesti 0 028294 7 00 00 01 50 AWX4 451 04 59 56 643606 04 59 56 676287 0 032681 ATX4 ATX44 ActionServlet 0 029511 7 00 00 06 50 AWX4 451 05 00 03 649787 05 00 04 4
12. Produce this Report ADDRESS SPACE ACTIVITY SMF30DTE SMF30TME SMF30SID SMF30JBN SMF30PGM SMF30STM SMF30JNM SMF30DEV SMF30DDN SMF30BLK 07 19 08 6 00 03 48 DEV1 5148 BPXPRECP STEP1 57 07283 32 51500001 1 07 19 08 6 00 03 48 DEVI 5148 BPXPRECP STEPI 57 07283 32 5 500002 6 035 07 19 08 6 00 03 48 DEVI BCA5148 BPXPRECP STEPI 57 07283 32 SYS00003 07 19 08 6 00 03 48 DEVI 5148 BPXPRECP STEPI 57 07283 32 SYS00004 3 078 07 19 08 6 00 03 48 DEVI BCA5148 BPXPRECP STEPI 57 07283 32 5 500005 18 07 19 08 6 00 03 48 DEVI BCA5148 BPXPRECP STEPI 57 07283 32 SYS00006 6 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT STC07285 0 SYSOUT 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT STC07285 32 SORTWKOI 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT STC07285 32 SORTWKO2 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT 57 07285 32 SORTWKO3 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT 5707285 32 SORTIN 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT 57 07285 32 SORTOUT 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT 5707285 32 SYSIN 0 07 19 08 6 00 14 57 DEVI SMFSLRD SOR SORT 57 07285 0 SORTSNAP 0 07 19 08 6 00 14 57 DEVI SMFSLRD IFASMFDP SELESLR 57 07285 64 1 077 952 576 07 19 08 6 00 14 57 SMFSLRD IFASMFDP CLEAR S1C07285 64 1 077 952 576 07 19 08 6 01 05 38 DEVI _ M99RPTI2 SOR STP01020 10807284 0 SYSOUT 0 07 19 08 6 01 05 38 M99RPT12 SOR STP01020 30807284 32 SORTWK02 2 07 19 08 6 01 05 38 DEVI _ M99RPTI2 SOR 5 01020 10807284 32
13. SYSNAME SYSPLEX 5 119 SYSPLEXNAME TITLE SORTED BY TRANSFER START TIME COLUMNS SMF119TI STACK STACK SMF119FT FSCMD CMND SMF119FT FSDRIP IPVA REMOTE IP SMF119FT FSDLIP IPVA LOCAL IP SMF119FT FSSUSER CLIENT USERID MY DATA TYPE DATA TYPE SMF119FT FSSTIME TRANSFER START TIME 5 119 FSDUR 7 TRANSFER DURATION SECS SMF119FT FSBYTES NUM BYTES 7 P ZZ9 9 B SMF119FT FSFILENAME1 DISP 30 DSNAME SORT 5 119 FSSTIME Produce this Report 2 05 FTP FILE TRANSFER LOG FROM SMF 119 70 RECORDS SYSTEM PD1 SYSPLEX PLX11 SORTED BY TRANSFER START TIME TRANSFER TRANSFER REMOTE LOCAL CLIENT DATA START DURATION NUM STACK CMND TP IP USERID TYPE TIME SECS BYTES DSNAME STXA81A STOR 100 59 162 15 00 62 110 26 C931169 ASCI 13 04 07 40 0 06 0 3 MB 009082 STXA81A STOR 100 59 162 15 00 62 110 26 C931169 ASCI 13 05 38 64 0 06 0 3 MB 009082 STXA81A STOR 100 59 162 15 00 62 110 26 C931169 5 13 07 26 74 0 11 0 3 009082 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 24 81 0 00 30 0 KB PRD1 PO M0143181 JAIS 000002 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 25 12 0 00 13 3 KB PRD1 P0 M0143181 JAIS 4000002 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 28 89 0 01 71 3 KB PRD1 PO M0143181 JAIS 0000
14. 8 TOTAL FOR ERPTRKIL 07 24 06 11 49 50 74 8 ITEMS 26 427 383 0 0 0 256 5 01 05 23 08 19 57 23 62 TPRDO7 2A18 00200000 0020000E 1 0 8 4 2 5 01 05 23 08 19 57 23 62 TPRDO7 2A18 00200000 0020000E 1 9 2 5 01 05 23 08 19 57 23 62 TPRDO7 2A18 0009000 0009000E 1 0 6 04 3 5 01 05 23 08 19 57 23 62 TPRDO4 2 21 07050000 0705000E 1 00004 2 5 01 05 23 08 19 57 23 62 TPRDO4 2 21 00A60008 00A60008 1 0004 3 5 01 05 23 08 19 57 23 62 TPRDO4 2 21 07050000 0705000E 0 0 o 00 0 5 01 05 23 08 19 57 23 62 TPRDO4 2 21 00A60008 00460008 0 80 6 0 TOTAL FOR NETSAO1 05 23 08 19 57 23 62 7 ITEMS 7 5 0 0 0 J2 78 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports RMF Coupling Report from SMF 74 Records This report reads as input the SMF file and selects just the type 74 RMF Activity records with subtype 4 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 Als
15. FSOPER Oper 4 5 119596 SSH FSCMD Cmd 5 119596 SSH FSSTAT Stat 5 119596 SSH FSLIP Lpcate 5 119596 SSH FSRIP Remote 5 119596 SSH FSHOSTNAME Host 4 5 119596 SSH FSPATHl Pathl 45 Produce this Report 119 96 Server Transfer Completion record Startdate Starttime Userid Oper Cmd Stat Locate IP Remote IP Host Pathl 01 03 11 07 00 19 21 TPADMIN6 TPADMIN get GET OK 55 66 77 88 11 22 33 44 5 52 SYS2 tmp payment_detail SYS2 01 03 11 07 00 19 61 TPADMIN7 TPADMIN get GET OK 55 66 77 88 11 22 33 44 2 SYS2 var hkeeping payment_history SYS2 Spectrum SMF Writer Tutorial 95 Appendix B Examples of SMF Reports These Control Statements OPTION NOGRANDTOTAL INPUT SMF11997 COPIES FILE DEF STMTS AUTOMATICALLY INCLUDEIF SMF119897 RIY 119 RECORD TYPE AND 5 119597 5 97 RECORD SUB TYPE TITLE 119 97 CLIENT TRANSFER COMPLETION RECORD SORT 5 119597 SSH FCSDATE 5 119597 SSH FCSTIME 5 119597 SID COLUMNS 5 119597 SID System 5 119597 SSH TI ASNAME Asname 5 119597 SSH TI USERID Userid 5 119596 SSH FSCMD CMD SMF119597 SSH FCTTYPE Type 5 119597 SSH FCMODE Mode 5 119597 SSH FCSDATE Begdate 5 119597 SSH FCSTIME Begtime 5 119597 SSH FCDUR Duration 5 119597 SSH FCBYTES Bytes 5 119597 SSH FCSTAT Stat 5 119597 SSH FCLIP Local
16. SMFI5RTY 15 OR 17 SELECT BOTH 15 AND 17 We also want to restrict the records in our report to just those which contain the text SPFTEMP somewhere within the dataset name However the dataset name in SMF15 records is not in the same place as it is in SMF17 records So we can not make this test directly on any one field in the input record This is where a conditional COMPUTE statement is useful COMPUTE DSN WHEN SMFIBRTY 15 ASSIGN SMF15 JFCBDSNM ELSE ASSIGN SMF17DSN The COMPUTE statement assigns SMF15 JFCBDSNM to DSN when the input record is type 15 Otherwise it assigns SMF17DSN from a different part of the record to DSN Now we have a single field where we can look for the text SPFTEMP So our final INCLUDEIF statement will be this INCLUDEIF SMF15RTY 15 OR 17 SELECT BOTH 15 AND 17 AND DSN SPFTEMP MEANS SCAN FOR TEXT Now that the input and inclusion criteria have been specified we just need to specify what columns to put in the report Once again for some items we must make COMPUTE fields to use in the COLUMNS statement rather than a field name which may or may not be valid for a given record Other fields such as SMF15DTE and SMF15TME are located in the standard SMF header and can be used with any type of SMF record The report in Figure 8 page 39 now has one line for each type 15 or 17 record that refers to a SPFTEMP dataset Each report line shows relevant data taken from either S
17. Spectrum SMF Writer Release 3 0 4 Our Customers Say It Best I only used the product today and saw how easy it was to generate these reports It would save me a lot of time from writing assembler routines to do this It is easy to use and presents a very nice report Fantastic tooll Your product totally satisfies our requirements Tomorrow I will do a training session with z OS system programmers so that they will be able to do their own SMF reports We are convinced that we are buying very good and useful software I do like the product because of its ease An associate asked at the begin ning of this week if I had a way to see how many VSAM files and sequential files we had on our systems I informed him that with this product I could quickly generate a report using the SMF type62 records for VSAM cluster opens and go back however far we keep our SMF records Perfect BRAVOI Our system programming department has seen a demo of the product and is also enthusiastic about your product Your product was simple to install and so far it is pretty straight forward Nice tool Thank you for your support and again a great compliment to your product You are truly a breath of fresh air in an industry that has level level2 level3 support I have been twiddling bits in the mainframe for 40 years and the last 10 it s been scarce to find support like you have provided Copyright 2012 Pacific Systems Group
18. 0 SHOW STCKS AS INTERVALS NOT TIMES OF DAY OPTION NOGRANDTOTALS INPUT SMF70 NORMWHEN SMF7ORTY 70 AND SMF70STY 1 AND SMF70BCN gt 0 NORMSMF SMF70BCS OUTER LEVEL NORMALIZE SMF70 PRSMLPD SECTION SMF7OBDN NESTED LVL LUDEIF SMF7ORTY 70 AND 5 705 1 AND SMF70BDN gt 0 LE PHYSICAL CPU S N SMF7OSER HEX LPARS ONLINE TIME PERCENTAGE REPORT RUN DATE DATE LE FAMILY amp MODEL SMF70MOD HEX SMF70MDL 5 BY LOGICAL PROCESSOR PAGE PAGENUM LE CAPACITY 0 SMF7OWLA 6 MSU S SMF700IL MINUTE INTERVAL ENDING SMF70DTE SMF7OTME HH MM SORT DATE TIME FORMAT SMF7ODTE YYYYMMDD FORMAT SMF70TME HHMMSS SORT PARTITION 55 5 705 FORMAT SMF7OLPN 4 SORT_DATE_TIME PAGE NOTOTALS SORT_PARTITION NOTOTALS SMF70VPA BREAK SORT PARTITION HEADING PARTITION INFO HEADING HEADING SYSTEM 5 705 SYSTEM NAME SMF7OSTN HEADING PARTITION NUM SMF7OLPN 2 PARTITION NAME SMF7OLPM HEADING LPAR CLUSTER SMF7OSPN HEADING LPAR DEFINED CAPACITY LIMIT 0 SMF70MSU 6 MSU S HEADING STORAGE SMF7OCSF 7 MB HEADING HEADING LOGICAL PROCESSOR INFO 0 SMF70BDN 4 PROCESSORS HEADING COLUMNS SMF70VPA LOG PROC ADDR HEX 7 NEIGHT FACTOR 6 SMF7OINT_TIME ACTUAL RMF INTERVAL BM 7 ONLINE TIME SMF700NT PCT PCT ONLINE AJ SMF7OWST HAIT TIME SM
19. AND LAYOUT FOR THIS RUN KKK KKK KK kok KKK KK KK KK kekok RK KK KK KK KKK KK KKK kk k KEKE RRR INPUT SMF30 KKK KKK KK KK KKK KK KKK KKK KKK KK KK KK KKK RK KK KKK RRR ERK KOR RK SPECIFY WHICH SMF RECORDS TO INCLUDE IN REPORT KKK KK ek KK KKK KK KKK KKK KKK KK KK KK RK KKK KERR KR EKER KEKE RK INCLUDEIF SMF30RTY 30 AND SMF30STP 5 KKK ee KK KK KKK KK KKK KKK KKK KK kk ee eek ek dede ke ke SPECIFY REPORT TITLE KKK KKK ek ee KKK KK KKK KKK KKK ee KK ee KKK ek KKK KKK KEKE RK KER TITLE NUMBER OF TASKS BY WORD TYPE INDICATOR SMF30WID KK KK KKK KK KKK KKK KKK KK KKK KKK KKK KKK KKK KEKE RR dede COMPUTE THE NUMBER OF ELAPSED SECOND BY SUBTRACTING SMF LOG DATE TIME FROM JOB START DATE TIME kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk COMPUTE ELAPSED SECS 4MAKENUM SMF30DTE 86400 MAKENUM SMF30TME 5 305 0 86400 MAKENUM SMF30SIT COMPUTE ELAPSED HRS 4 ELAPSED SECS 3600 Spectrum SMF Writer Tutorial 63 Appendix B Examples of SMF Reports These Control Statements cont KK KK KK eek ee ek ee ek ee ke KK e ke KEK KK KKK ek ee SPECIFY WHICH SMF FIELDS AND COMPUTED FEILDS TO SHOW IN THE REPORT COLUMNS kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk COLUMNS SMF30WID SMF30JBN SMF30JNM SMF30DTE SMF30TME SMF30STD SMF30SIT ELAPSED SECS 8 ELAPSED HRS 7 KK KKK KKK ek ee
20. records We expand the operation codes from the SMF record into text descriptions And we reformat the four 1 byte binary IP values into the familiar character IP4 format You can see the IP formatting code in member REC11996 of your Spectrum SMF copy library The second report is similar It uses the SMF 119 subtype 97 records OpenSSH Client Transfer Completion This shows the client transfer completion information Note that we specified lower case headings in thess reports purely for style These Control Statements OPTION NOGRANDTOTAL INPUT SMF11996 INCLUDEIF 5 119596 RTY 119 RECORD TYPE 59 AND 5 119596 STY 96 RECORD SUB TYPE TITLE 119 96 Server Transfer Completion record COMPUTE FSOPER 8 WHEN SMF119S96 SSH FSOPER 1 ASSIGN RMDIR WHEN SMF119S96 SSH FSOPER 2 ASSIGN RM WHEN SMF119S96 SSH FSOPER 3 ASSIGN RENAME WHEN SMF119S96 SSH FSOPER 4 ASSIGN GET WHEN SMF119S96 SSH FSOPER 5 ASSIGN PUT WHEN SMF119S96 SSH FSOPER 6 ASSIGN CHMOD WHEN SMF119S96 SSH FSOPER 7 ASSIGN CHOWN WHEN SMF119S96 SSH FSOPER 8 ASSIGN MKDIR WHEN SMF119S96 SSH FSOPER 9 ASSIGN SYMLINK ELSE ASSIGN FORMAT SMF119S96 SSH FSOPER SORT 5 119596 SSH FSSDATE 5 119596 SSH FSSTIME 5 119596 SID COLUMNS 5 119596 SSH FSSDATE Startdate 5 119596 SSH FSSTIME Starttime 5 119597 SSH TI ASNAME Asname 5 119596 SSH TI USERID Userid
21. 0 0 0 0 ZSA 11 00 07 11 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 12 0 0 0 0 0 0 0 0 0 0 ZSA 11 00 07 13 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 14 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 15 0 0 0 0 0 0 0 0 0 0 ZSA 00 36 0 50 000 49 972 49 972 0 38 0 0 28 0 0 ZSA 11 00 36 1 20 000 19 999 19 999 0 0 0 0 0 0 0 ZSA 00 36 2 50 000 49 995 49 995 0 1 0 5 0 0 ZSA 11 00 36 S 20 000 19 992 19 992 0 20 4 0 20 0 0 92 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports MQ Queue CPU Time Report from SMF 116 Records In this report we read the SMF file and select just the type 116 subtype 1 Websphere MQ accounting statistics records We use all of the the recurring WQST Queue Statistics sections from each SMF record to show queue statistics These Control Statements INPUT SMF116 NORMWHEN SMF116RTY 116 AND 5 1165 1 AND WQST NUM gt 0 NORMALIZE WQST WQST NUM INC SMF116RTY 116 AND SMF116STF 1 COL SMF116TME LOG TIME WTIDCCN CONNECTION NAME OBJNAME QUEUE NAME 20 BASE QUEUE NAME 30 OPENTIME QUEUE OPEN TIME TPIC 99 99 99 99 CLOSTIME QUEUE CLOSE TIME TPIC 99 99 99 99 GETCT CPU TIME FOR MQGETS PUTICT CPU TIME FOR MQPUT1 S TITLE SMF 116 WEBSPHERE MQ ACCOUNTING STATS TITLE QUEUE CPU TIME FOR MQGET S AND MQPUTI S Produce this Report SMF 116 WEBSPHERE MQ ACCOUNTING STATS QUEUE
22. 0 006 0 006 0 004206 0 004206 0 004206 5 AWT4 7451 Default 74 744 Tonam Inf invoke java lang String j 1 0 004 0 004 0 003605 0 003605 0 003605 5 AWT4 7451 Default 74 AXZ44 Tonam Inf invoke java lang String j 1 0 007 0 007 0 004831 0 004831 0 004831 5 AWTA 7451 Default 74 AXZ44 Tonam Inf invoke java lang String j 2 0 005 0 010 0 005650 0 001264 0 010036 GRAND TOTAL 6 ITEMS 98 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports WebContainer Servlet Times Report from SMF 120 7 Records 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 120 WebSphere Application records for WebContainer Servlets It then prints a report line for each Servlet section found The report shows elapsed time and CPU time information about those Servelets Note that a single SMF 120 record can contain information about multiple servers and each server can have multiple servlets These Control Statements INPUT NORMWHEN SMF120RTY 120 AND SMF120RST 7 AND SMF120WA9 gt 0 NORMALIZE SMF120 WEBAPP SECTION SMF120WA9 NORMALIZE SMF120 WEBAPP TRIP SECTION SMF120WAM NORMALIZE SMF120 SERVLET SECTION SMF120WAP 5 12007 INCLUDEIF SMF120RTY 120 SMF120RST 7 TITLE Z OS WEBSPHERE APPLICATION SMF 120 DATA TETEE COMPUTE ACT_DUR MAKETIME MAKENUM SMF120WAG MAKENUM SMF120WAF
23. 00042 8 25 50 21 0 00 00 00 13 64 00 00 13 34 7144597 714 77 0 01 50 77 0 04 5 25 50 21 0 00 00 00 20 84 00 00 20 49 TOTALS PZ14 1 001 10 01 0 53 2 78 0 00 00 03 02 23 00 02 59 06 00200021 0020 123 1630 0 01 1 53 0 06 5 25 0 32 0 00 00 00 00 15 00 00 00 11 00200095 0020 123 14 598 0 01 145 98 1742 5525 59 14 0 01 00 00 33 80 00 00 33 80 additional lines not shown U0240052 024 123 9 969 0 01 99 69 1 32 5 25 6 93 0 01 00 00 20 62 00 00 20 62 00240082 024 123 9 975 0 01 99 75 1 34 5 25 7 04 0 04 00 00 29 82 00 00 29 82 00240021 10024 123 9 957 0 01 99 57 1 27 5 28 6 67 0 01 00 00 21 39 00 00 21 39 TOTALS U024 935 117 9 351 17 119 44 627 30 0 98 00 43 12 78 00 43 11 88 WSWS1 WSWS 140 0 01 51 40 0 03 65 25 50 16 0 01 00 00 00 31 00 00 00 31 WSWS2 WSWS 36 0 01 50 36 0 04 5 25 50 21 0 00 00 00 00 19 00 00 00 19 WSWS9 WSWS 138 0 01 1 38 0203 19205 0 16 0 00 00 00 00 23 00 00 00 23 TOTALS WSWS 314 3 14 0 10 0 53 0 01 00 00 00 73 00 00 00 73 GRAND TOTAL 200 ITEMS 1 676 156 16 761 56 206 32 1 083 58 2 55 01 21 07 95 01 20 24 09 76 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports DFSMS Usage and Performance Report for Selected Datasets from 42 This example reads as input the SMF file and selects just the type 42 DFSMS statistics records It then prints a report line for each CLOSE of a dataset with a name matching the test criteria The report shows job id
24. 01 0 JOB INITIATION TSO LOGO Password not val U078044 5 6 7 000001 07 24 06 11 40 28 83 STRT2 A800 01 0 JOB INITIATION TSO 1060 Password not val U078044 5 6 7 000001 07 24 06 11 55 27 14 STRT2 A800 01 0 JOB INITIATION TSO LOGO Password not val U078044 5 6 7 000001 07 24 06 11 55 27 27 STRT2 A800 01 0 JOB INITIATION TSO LOGO Password not val U078044 5 6 7 000001 07 24 06 11 30 10 60 USROO32 A800 D 0 CHECK ACCESS TO DIRECTORY Not authorized USRO032 MONFLOT 090C14D7 07 24 06 11 30 10 60 580032 800 D 0 CHECK ACCESS TO DIRECTORY Not authorized 0580032 MONFLOT 090C14D7 07 24 06 11 36 19 20 USROO48 800 E 0 CHECK ACCESS TO FILE Not authorized USRO048 MONFLOT 090C112B 07 24 06 11 30 39 32 USRO097 A800 1E 01 CHECK ACCESS TO FILE Not authorized 580097 MONFLOT COA8198A 07 24 06 11 47 18 81 XX4DMGS A800 01 0 JOB INITIATION TSO LOGO Password not val XXTIDM4 XXTADMGP 07 24 06 11 55 21 94 XX6ADM 800 0 DIRECTORY SEARCH Not authorized XX6ADM XX6CFG 09418620 Spectrum SMF Writer Tutorial 81 Appendix B Examples of SMF Reports RACF Usage Statistics from SMF 89 Records This example reads as input the SMF file and selects just the type 89 RACF Usage records We print a report showing the TCB and SRB time for each monitored product during each recording interval The information is sorted and report by Sysplex name then by System name and finally by Product name with subtotals for eac
25. 01 58 84 00 00 00 00 144 OK 11 22 33 6 58076 123 234 567 999 22 zutil2 data browse tmp LogFile 20110303 030155 50466520 A S 03 03 11 03 13 10 92 00 00 00 00 144 OK 11 22 33 6 58652 123 234 567 999 22 zutil2 data browse tmp LogFile 20110303 031309 84017320 SYS2 14 701 PGAI4A PUT 96 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports FTP Transfers Report from SMF 119 70 Records In this report we read as input the SMF file and select just the type 119 subtype 70 FTP Server Transfer Completion records The report shows information about FTP transfers including remote and local IP values FTP Command transfer start time duration and the 2 05 DSN of the file transferred It also shows the type of transfer which we translate from the single byte in the SMF record into a user friendly word and the total number of bytes transferred The report is sorted by transfer begin time as opposed to the SMF file s native order which is transfer end time These Control Statements OPTION SCALEPICS INPUT SMF119 LIST YES INCLUDEIF SMF119RTY 119 AND SMF119STY 70 COMPUTE MY DATA TYPE WHEN SMF119FT_FSTYPE WHEN SMF119FT_FSTYPE WHEN SMF119FT_FSTYPE WHEN SMF119FT_FSTYPE WHEN SMF119FT_FSTYPE ASSIGN ASCII E ASSIGN EBCDIC 1 ASSIGN IMAGE ASSIGN DBL BYTE ASSIGN UCS 2 TITLE Z OS FTP FILE TRANSFER LOG FROM SMF 119 70 RECORDS TITLE SYSTEM 5 119
26. 06 00 14 57 SMFEXTR 06 01 33 76 G99D0010 06 02 38 59 AROTRA23 06 06 49 94 AROPRM23 06 07 21 59 AROCON23 06 09 06 37 BBIPOST 06 09 15 99 BB06101 10 800 00 00 00 00 00 00 00 00 00 00 0 00 00 00 00 00 00 00 00 00 00 0 00 00 00 00 00 00 00 00 00 00 0 00 00 00 00 00 00 00 00 00 00 52 987 893 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 00 24 06 09 18 17 9514 00 00 00 04 00 00 00 00 00 90 06 11 23 89 FTPD4 00 00 00 00 00 00 00 00 00 00 06 11 26 16 9514 10 574 100 00 00 00 00 00 00 00 00 00 00 06 25 49 35 02900715 3 649 536 00 00 00 00 00 00 00 00 00 00 06 41 26 16 5 0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 24 90 00 00 00 00 cOooocowooowu 09 3 9 521229 gt 5 gt GRAND TOTAL 13 512291 67 222 329 Figure 6 Computing your own fields for a report COMPUTE statements usually come after the INPUT statement so that you can refer to fields from the input file And your COMPUTE statement must appear before any control statement that uses the field being created Beyond that the precise location of a COMPUTE statement is not important The contents of a COMPUTE field is calculated once for each new record from the input file Technical Discussion When is the Computation Actually Performed Feel free to skip over this section if you like Sin
27. 20 41 8 PDSETST1 IKJEFT01 ISP23330 TESTCA PDSE TEST 80 4 14 11 2 2009 20 42 5 ZP144431 IKJEFT01 SYSEXEC UAS REXX 255 2 15 11 2 2009 20 42 5 ZP144431 IKJEFT01 STEPLIB D10INFO2 LOAD 0 2 16 11 2 2009 20 52 1 DUMPSMF SMFGDG LOG UAS SMF GDG LIST 80 59 17 11 2 2009 20 52 2 DUMPSMF SMFGDG STEPLIB USER LINKLIB 0 2 18 11 2 2009 20 52 9 PDSETST1 IKJEFTOL PDSESKEL UAS TAP JOBS 80 2 19 11 2 2009 20 53 4 PDSETST1 IKJEFTO1 15 23331 TESTCA PDSE TEST 80 4 20 11 2 2009 20 53 8 PDSETST1 IKJEFTOL 5 505621 TESTCA PDSE TEST 80 4 21 11 2 2009 21 09 1 PDSETST1 IKJEFTOL PDSESKEL UAS TAP JOBS 80 2 22 11 2 2009 21 09 3 PDSETST1 IKJEFTO1 15 23332 TESTCA PDSE TEST 80 4 23 11 2 2009 21 09 4 DBRC91T DFSMVRCO JCLPDS UAS TAPDSWA PROCLIBT 80 324 24 11 2 2009 21 10 2 ZP144452 IKJEFTO1 SYSEXEC UAS REXX 255 2 25 11 2 2009 21 10 2 ZP144452 IKJEFTO1 STEPLIB D10INFO2 LOAD 0 2 25 31 2 2nna _ 21 18 9 AT1221na nESIIARCO INACCVCT INAC1 21572 Figure 2 An Excel spreadsheet containing data from SMF 14 records 10 Spectrum SMF Writer Tutorial Lesson 2 How to Export SMF Data to Programs Making Multiple Reports Export Files in a Single Run Sometimes you might want SMF data both as a printed report and as an export file Spectrum SMF Writer lets you get both outputs during the same run Producing multiple outputs in a single run lets you avoid having to read and process the large SMF file more than once That can save lots of I O and CPU time an importan
28. 2815 30 4 FTPSERVE 1 OMVSEX 0000 02 06 08 12 15 30 4 FTPSERVE 1 STEPI 0000 02 06 08 2519 30 4 FTPSERVE 1 OMVSEX 0000 02 06 08 12 17 30 4 ASMX 1 5 0806 5806 02 06 08 12 20 30 4 TTAPOIA 1 STEPI 0000 02 06 08 12 39 30 4 ASMX 1 5 000 12 02 06 08 12 40 30 4 ASMX 1 ASM 000 12 02 06 08 12 50 30 4 BPXAS 0 IEFPROC 0000 02 06 08 13 01 30 4 ASMX 1 5 0000 02 06 08 13 04 30 4 ASMX 1 ASM 0000 02 06 08 3 08 30 4 1 1 SPFPROCE 0622 S622 02 06 08 13 09 30 4 TTAPOIA 1 SPFPROCE 0000 02 06 08 6 46 30 4 FTPSERVE ih STEPI 0000 02 06 08 16 47 30 4 FTPSERVE 1 OMVSEX 0000 02 06 08 6 47 30 4 FTPSERVE 1 STEP1 0000 02 06 08 6 47 30 4 FTPSERVE 1 OMVSEX 0000 02 06 08 16 57 30 4 TTAPOIA 1 STEP1 0000 GRAND TOTAL 46 ITEMS Spectrum SMF Writer Tutorial 69 Appendix B Examples of SMF Reports Job Statistics by Time of Day from SMF 30 Records This example reads as input the SMF file and selects just the type 30 subtype 5 job termination records For this report we include only JES2 submitted jobs no started tasks TSO sessions UNIX OMVS tasks etc We assigned each job to a quarter hour time slot We also computed some useful data items to include in the report We sorted the records by time slot and printed only the total information for each time slot The SUMMARY option suppessed the detailed information for each job You may want to include the detail information as you are developing your report and then add th
29. 31 05 00 07 24 31 05 12 B S SYSUP 07 24 09 11 31 06 67 07 24 31 06 76 BPXPRECP 5 500001 SYS1 TCPPARMS SYSUP 07 24 09 11 31 06 67 07 24 31 06 78 BPXPRECP 5 500004 TCPIP STANDARD USTTAO14 07 24 09 12 00 44 10 07 24 00 44 20 BPXPRFC SYS00001 SYS1 TCPPARMS B 5 B E B C B 5 B E B C B 5 USTTAO14 07 24 09 12 00 44 10 07 24 00 44 25 BPXPRFC SYS00004 TCP ANDARD TCPXL USTTAO14 07 24 09 12 00 44 10 07 24 00 44 30 BPXPRFC 5 500006 TCPIP ETC SERVICES A035 07 24 09 11 33 30 45 07 24 33 30 62 BPXPRFC SYS00001 SYS1 TCPPARMS A035 07 24 09 11 33 30 45 07 24 33 30 84 BPXPRFC SYS00004 TCP ANDARD TCPXL A035 07 24 09 11 33 30 45 07 24 33 30 90 BPXPRFC 5 500006 TCPIP ETC SERVICES A035 07 24 09 11 58 53 19 07 24 58 53 31 BPXPRFC SYS00001 SYS1 TCPPARMS A035 07 24 09 11 58 53 19 07 24 58 53 34 BPXPRFC SYS00004 TCPIP STANDARD TCPXL A035 07 24 09 11 58 53 19 07 24 58 53 37 BPXPRFC SYS00006 TCPIP ETC SERVICES CO1 07 24 09 09 28 53 31 07 24 32 00 55 IKJEFTO1 SYS00053 OMVSSPN MBS NAMES 01 07 24 09 09 28 53 31 07 24 48 37 80 IKJEFTO1 SYS00058 OMVSSPN MBS NAMES CO1 07 24 09 09 28 53 31 07 24 43 21 39 IKJEFTO1 SYS00056 OMVSSPN MBS NAMES 01 07 24 09 09 28 53 31 07 24 43 26 46 IKJEFTO1 SYS00057 OMVSSPN SHELLS 01 07 24 09 09 28 53 31 07 24 34 39 98 IKJEFTO1 SYS00054 OMVSSPN SHELLS 01 07 24 09 09 28 53 31 07 24 34 45 02 IKJEFTO1 SYS00055 OMVSSPN SHELLS C011 07 24 09 11 35 08 53 07 24 35 10 69 BPXPRECP SYSLIB CEX SDFVLKEX C011 07 24 09 11
30. 35 08 53 07 24 35 10 70 BPXPRECP C896 CEX SDFVOBJ C011 07 24 09 11 35 08 53 07 24 35 10 04 BPXPRECP C8920 YS06205 7113509 C011 07 24 09 11 35 08 53 07 24 35 10 28 BPXPRECP SYSLIN SYS06205 T113510 C011 07 24 09 11 35 08 53 07 24 35 09 92 5 500002 5 506205 7113509 011 07 24 09 11 35 08 53 07 24 35 10 04 SYSLIN SYS06205 T113510 C011 07 24 09 11 35 08 53 07 24 35 10 04 8920 5 506205 7113509 C011 07 24 09 11 35 27 70 07 24 35 30 06 BPXPRECP SYSLIB CEX SDFVLKEX C011 07 24 09 11 35 27 70 07 24 35 30 06 BPXPRECP C896 CEX SDFVOBJ C011 07 24 09 11 35 27 70 07 24 35 29 50 BPXPRECP SYSLIN SYS06205 T113529 additional lines not shown Figure 9 Using a SORT statement to specify the sort order of a report Spectrum SMF Writer Tutorial 43 Lesson 8 How to Specify the Sort Order and Control Breaks By default Spectrum SMF Writer sorts reports into ascending order on each sort field If you want to sort the report into descending order for a field put the DESCENDING parm or just DESC or D in parentheses immediately after the field name How to Use the BREAK Statement Consider the result of sorting the report in Figure 9 on the SMF14 JOBID field As you can see it causes all of the records for a given job to be grouped together Often it is desirable to perform special processing whenever one such group of records en
31. 576 11 02 09 12 21 19 08 UASUARCO STEPLIB IMS910T TAPO SUASRESL 73 2 391 480 EXCP COUNT AVERAGE 4 537 MAX 9 001 TOTAL FOR AUABB109 11 02 09 12 21 09 33 2 ITEMS 9 074 223 600 056 AVERAGE VALUE 4 537 111 800 028 MAXIMUM VALUE 9 001 221 208 576 EXCP COUNTS FOR JOB DCRC91T 11 01 09 19 09 46 82 FOLLOW 11 02 09 12 21 09 39 UASMVRCO JCLPDS D10 TAPDSW4 PROCLIBT 1 036 800 EXCP COUNT AVERAGE 324 MAX 324 TOTAL FOR DCRC91T 11 01 09 19 09 46 82 1 ITEM 1 036 800 AVERAGE VALUE 1 036 800 MAXIMUM VALUE 1 036 800 EXCP COUNTS FOR JOB DUMPSMF 11 02 09 12 20 14 79 FOLLOW 11 02 09 12 20 52 07 SMFGDG LOG D10 SMF GDG LIST 1 647 280 11 02 09 12 20 52 22 SMFGDG STEPLIB USER LINKLIB 65 520 11 02 09 12 20 15 43 IFASMFDP SYSIN USER PROCLIB 12 800 EXCP COUNT AVERAGE 21 MAX 59 TOTAL FOR DUMPSMF 11 02 09 12 20 14 79 3 ITEMS 1 725 600 AVERAGE VALUE 575 200 MAXIMUM VALUE 1 647 280 additional lines not shown GRAND TOTAL 32 ITEMS 282 543 376 AVERAGE VALUE 8 829 481 MAXIMUM VALUE 221 208 576 Figure 13 Printing statistics and custom headings and footings at control breaks 52 Spectrum SMF Writer Tutorial Lesson 9 Customizing the Control Breaks expression Print expressions are combinations of literal text and field names of the sort that we have used earlier in the COLUMNS statement and the TITLE statement One powerful feature of the FOOTING parm is that
32. 6 00000000000000 1 337 526 720 861 9 51 56 10 01 56 02 16 11 0 2 6 00000000000000 1 337 526 720 861 9 51 56 10 01 56 02 16 11 0 3 16 FFFF000000000000 1 337 526 720 861 9 51 56 10 01 56 02 16 11 0 4 29 FFFFFFF800000000 1 337 526 720 861 9 51 56 10 01 56 02 16 11 1 1 6 FC00000000000000 1 295 074 113 188 9 51 56 10 01 56 02 16 11 1 2 6 FC00000000000000 1 295 074 113 188 9 51 56 10 01 56 02 16 11 1 3 16 FFFF000000000000 1 295 074 113 188 9 51 56 10 01 56 02 16 11 1 4 29 FFFFFFF800000000 1 295 074 113 188 Spectrum SMF Writer Tutorial 91 Appendix B Examples of SMF Reports Buffer Pool Statistics Report from SMF 115 Records In this report we read the SMF file and select just the type 115 subtype 2 Websphere MQ performance statistics records We use all of the the recurring QPST Buffer Pool Management sections from each SMF record to show statistics for each subpool during the period just ended The statistics include number of buffer pools number of stealable buffers lowest number of stealable buffers during the period actual number of buffer steals number of get page old and get page new requests count of DASD read and write ops pages written to DASD etc These Control Statements INPUT SMF115 NORMWHEN SMF115RTY 115 AND SMF115STF 2 AND SMF115_QPSTN gt 0 NORMSMF SMF115 QPSTO INCLUDEIF SMF115RTY 115 AND SMF115STF 2 COLUMNS SMF115SID Z OS
33. 74 CICS monitoring records 89 performance report 88 regions 63 reports 60 transaction time report 89 Client SFTP transfer report 95 COBOL record layouts 7 Colon after statement name 3 in conditional expressions 57 Column headings default 6 how to change 26 in PC files 12 Columns in control statements 3 22 of data in report 5 COLUMNS statement 5 column headings 26 formatting dates times and numbers 25 width of columns 28 Combining character fields 34 Comma for decimal digits 26 Comma delimited files see also Exporting 9 Completion code example 68 in SMF 30 record 36 37 Computational expressions character how to write 34 numeric how to write 31 COMPUTE statement 31 assigning different values based on conditions 36 column headings for computed fields 26 concatenation operation 34 conditional 36 creating character fields 34 creating numeric fields 31 creating time fields 33 math operations 31 time operations 33 when is computation performed 32 Concatenation how to perform 34 Conditional expressions 57 lists of values 58 syntax 57 Continuation of control statements 22 50 Control Areas VSAM reporting 78 Control breaks 44 multiple 48 printing blank lines at 44 Index Control Intervals VSAM reporting 78 Control statements columns 3 22 continuation lines 22 59 Copy library 3 5 6 13 COPY statement 40 Count of records in report 6 CPU time reducing CPU used 11 report example 74 93 98
34. 8 942K 078 236 3 400 22 415 563 81 367 CTBA SCA 09 30 00 10 00 000 3 456 1 759 59 253 463 1 3 84 538 1 048 CTLF GBPO 09 30 00 10 00 000 8 448 0 122K 1 012 CTLF GBPO 09 30 00 10 00 000 8 320 37 782K 4 313 6 10 471 409 CTLF GBP1 09 30 00 10 00 000 12 544 5 359 1 459 3 8 241 327 CTLF_GBP1 09 30 00 10 00 000 12 672 CTLF_GBP16KO 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 5 389 1 656 3 8 141 325 CTLF GBP2 09 30 00 10 00 000 8 448 CTLF GBP32K 09 30 00 10 00 000 3 584 30 272 2 25 CTLF GBP32K 09 30 00 10 00 000 3 584 57 1 922K 6 194 32 22 436 846 CTLF_GBP8KO 09 30 00 10 00 000 4 096 5 353K 1 473 3 7 933 321 CTLF_GBP8KO 09 30 00 10 00 000 4 096 CTLF_LOCK1 09 30 00 10 00 000 4 992 1 214 11 94 508 4 807 88 328 922 125 032 CTLF_SCA 09 30 00 10 00 000 3 328 1 581 5 225 834 4 26 085 323 CTOC_GBPO 09 30 00 10 00 000 3 456 50 1 690K 5 850 CTOC_GBPO 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_GBP16KO 09 30 00 10 00 000 1 280 CTOC_GBP16KO 09 30 00 10 00 000 1 280 4 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 80 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Repo
35. 99 Creating your own fields 31 D DASD read and write operations 92 Database ID expanding to object name 86 Dataset deleted 38 opened for input 52 opened for output 38 Dates current day of week 23 date literals 57 delimiter to use 29 displaying as DD MM YY 25 displaying in long form 25 formatting in report 25 in conditional expressions 58 Julian 58 packed 58 STCK 58 system date 23 DB2 access report 86 accounting statistics 85 as input to Spectrum SMF Writer 7 86 audit report 86 IFC destination report 84 plan 85 DD for output 11 DD MM YY format using in control statements 29 DD MM YYYY format 58 Decimal point using comma instead 26 Spectrum SMF Writer Tutorial 101 Index Default column headings 6 grand totals 6 report title 6 22 showing dates as DD MM YY 29 Definitions of SMF records 3 5 6 Delete datasets deleted 38 Delimiter tab character 12 used to format dates 20 used to format times 20 DESC parm in SORT statement 44 Detail report lines suppressing 46 DFSMS reports 77 Display formats in COLUMNS statement 25 Dollar displaying data as dollars 26 Downtime report 60 DSNAME in SMF records 59 62 E Elapsed time calculating from SMF fields 33 computing 89 in SMF 30 records 33 ELSE parm in COMPUTE statement 36 European formatting conventions 29 Event RACF 81 Excel example 9 10 EXCP section of SMF 30 record 15 18 67 Exporting column headings in export file 12 deli
36. CPU TIME FOR MQGET S AND MQPUTI S BASE QUEUE QUEUE CPU TIME CPU TIME CONNECTION QUEUE QUEUE OPEN CLOSE FOR FOR LOG TIME NAME NAME NAME TIME TIME MQGETS MQPUTI S 12 20 28 48 00200021 MQGT OTMA QUE MQGT OTMA QUEUE 6 20 28 09 16 20 28 43 00 00 00 000000 00 00 00 000000 12 20 28 65 CICS3A1A CICS BRIDGE R SYSTEM CLUSTER TRANSMIT QUEUE 6 20 28 64 16 20 28 64 00 00 00 000000 00 00 00 000363 12 20 28 65 CICS3A1A CICS BRIDGE Q CICS BRIDGE QUEUE 6 20 28 50 16 20 28 66 00 00 00 000120 00 00 00 000000 12 20 29 36 CICS3A1A CICS BRIDGE R SYSTEM CLUSTER TRANSMIT QUEUE 6 20 28 64 16 20 28 64 00 00 00 000000 00 00 00 000310 12 20 29 36 CICS3A1A CICS BRIDGE Q CICS BRIDGE QUEUE 6 20 28 49 16 20 28 66 00 00 00 000096 00 00 00 000000 12 20 29 36 00240087 DQMIPV6 CSQ1 RE DQMIPV6 CSQ1 REPLYQ 6 20 28 89 16 20 29 36 00 00 00 009340 00 00 00 000000 12 20 29 36 U0240087 DQMIPV6 CSQ2 DQMIPV6 CSQ1 XMITQ 6 20 27 22 16 20 28 64 00 00 00 000000 00 00 00 000000 12 20 29 80 CICS3A1A CICS BRIDGE REPLY Z3 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 29 80 16 20 29 80 00 00 00 000000 00 00 00 000328 12 20 29 80 CICS3A1A CICS BRIDGE Q CICS BRIDGE QUEUE 6 20 29 76 16 20 29 80 00 00 00 000116 00 00 00 000000 12 20 30 09 CICS3A1A CICS BRIDGE R 73 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 30 09 16 20 30 09 00 00 00 000000 00 00 00 000416 12 20 30 09 CICS3A1A CICS BRIDGE QUEUE CICS BRIDGE QUEUE 6 20 30 00 16 20 30 10 00 00 00 000112 00 00 00 000000 12 20 30 12 00200021 MQGT OTMA REPLYQ OTMA R
37. Control Breaks Multiple Control Breaks You may designate more than one sort field as a control break field Use a separate BREAK statement for each sort field that you want to break on Consider these control statements COMPUTE SMF14 TIMESTAMP FORMAT SMF14RSD FORMAT SMF14RST SORT SMF14JBN SMF14 TIMESTAMP SMFIAEXCP D BREAK SMF14JBN SPACE 3 BREAK SMF14 TIMESTAMP SPACE 1 In this example we have in effect split the SMF14 JOBID field into two components the jobname alone SMF14JBN and the reader start date time in a separate field SMF14 TIMESTAMP By sorting on both of these fields plus SMF30EXCP as the tie breaker our report remains in the same order as in the previous example But now we can break separately on two occasions First we can break as before when each individual job ends and show its EXCP total The break on SMF14 TIMESTAMP does that for us That break s total line is followed by 1 blank line And now we can have an additional break each time the jobname alone changes The totals at that break will include all runs of a job with that name in the SMF file The jobname break is followed by 3 blank lines Notice that the number of asterisks in the default total lines serves as a visual indicator of the level of the break BREAK statements must appear after the SORT statement When multiple BREAK statements are used the BREAK statements may appear in any order Note that the ord
38. DFHWBGB 5 5 08 24 10 11 45 43 110 3 CWBG W24AA01 10 43 27 10 43 27 329171 DFHWBGB CICSCPSM 08 24 10 11 47 28 110 3 CWBG W24AA01 10 47 05 10 47 04 996727 DFHWBGB 5 5 08 24 10 11 48 17 110 3 CWBG W24AA01 10 47 05 10 47 05 001450 DFHWBGB 5 5 08 24 10 11 55 21 110 3 CWBG W24AA01 10 54 59 10 54 58 978051 DFHWBGB CICSCPSM 08 24 10 11 56 21 110 3 CWBG W24AA01 10 55 06 10 55 06 317385 DFHWBGB 5 5 08 24 10 11 56 47 110 3 CWBG W24AA01 10 55 40 10 55 40 387347 DFHWBGB 5 5 08 24 10 11 57 49 110 3 CWBG W24AA01 10 57 23 10 57 22 894420 DFHWBGB 5 5 88 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports CICS Transaction Time Report from SMF 110 Records In this report we show timing statistics for each execution of a CICS transaction To do this we select just the SMF type 110 subtype 1 CICS Monitoring records We normalize the performance segments in those records That means in essence that Spectrum SMF Writer steps through each performance section within a single record processing each section as if it was a separate record The normalization logic is handled automatically for you From these SMF records we print the CICS transaction name and the CICS program name under which it executed We print the transaction s start and stop time Notice that Spectrum SMF Writer takes the raw 8 byte STCK times and automatically reformats them for yo
39. Figure 15 page 55 shows an example of including file data in a title How to Align the Title Consider this TITLE statement again TITLE DATE SPECTRUM SMF WRITER REPORT CPU TIMES PAGE PAGENUM Notice that it contains two slashes These are a powerful formatting device that let you easily align your titles in the customary way without having to carefully count up the number of columns in your report lines And then carefully counting them again when you make a minor change to the report When slashes are not used the whole title is centered over the report But when slashes are used they divide the title line into three parts The first part of the title HDATE in the example above will be aligned with the left margin of the report The middle part the literal text will be centered over the report And the last part PAGE and PAGENUM will be aligned with the right margin of the report Figure 5 page 27 shows a report that uses a TITLE statement similar to the one above Note You can also use a single slash in your TITLE statement That results in a 2 part title where the first part is left justified and the second part is right justified Spectrum SMF Writer Tutorial 23 Lesson 4 How to Make Your Own Report Titles Note you can also use two slashes but leave one or more of the three title parts empty The report in Figure 15 page 55 shows an example of doing this Summary Here is a summary of
40. SMF10 06 17 09 12 51 35 33 BATMDM BATCH 01 5 19 19 27 998 SMF10 06 17 09 12 51 35 33 BATMDM BATCH TTAPO1B SW COPYLIB 4 23 440 Spectrum SMF Writer Tutorial 77 Appendix B Examples of SMF Reports VSAM File Activity Report from SMF 64 Records In this report we read as input the SMF file and select just the type 64 VSAM statistics records 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 These Control Statements 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 Produce this Report VSAM COMPONENT CLUSTER STATS FROM SMF 64 RECORDS NUM NUM BEG END NUM NUM NUM Gil 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 04 0000 0520000E 1 2 0 o 06 3 CICSDN
41. SMF30SCC P ZZZZ9 WHEN CC NIB1 ASSIGN S SUBSTR CC HEX 2 3 WHEN CC NIB1 ASSIGN U FORMAT CC DROP 8 P ZZZ9 COMPUTE JOB ELAPSED SECONDS MAKENUM SMF30DTE 86400 MAKENUM SMF30TME MAKENUM SMF30STD 86400 MAKENUM SMF30SIT COMPUTE JOB ELAPSED TIME MAKETIME JOB ELAPSED SECONDS COMPUTE JOB ELAPSED HOURS 2 JOB ELAPSED SECONDS 3600 COMPUTE ABEND WHEN ABEND BIT 1 ASSIGN ABEND INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT TYPE 30 SUBTYPE 5 COLUMNS SMF30DTE SMF30TME SMF30STD SMF30SIT JOB ELAPSED SECONDS 8 JOB ELAPSED HOURS 7 JOB ELAPSED TIME 13 SMF30STI HEX ABEND SMF30SCC HEX COMP CODE TITLE SMF 30 JOB TERMINATIONS WITH ELAPSED TIME AND COMPLETION CODE Produce this Report SMF 30 JOB TERMINATIONS WITH ELAPSED TIME AND COMPLETION CODE JOB JOB JOB ELAPSED ELAPSED ELAPSED COMP SMF30DTE SMF30TME 5 05 SMF30SIT SECONDS HOURS TIME SMF30STI A2END SMF30SCC CODE 07 25 09 06 00 03 48 07 25 09 05 59 58 40 08 07 25 09 06 00 14 57 07 25 09 06 00 14 46 n 07 25 09 06 01 33 76 07 25 09 06 01 31 67 09 07 25 09 06 02 38 59 07 25 09 05 59 36 87 07 25 09 06 06 49 94 07 25 09 06 05 43 66 07 25 09 06 07 21 59 07 25 09 06 07 21 16 07 25 09 06 09 06 37 07 25 09 06 08 45 17 07 25 09 06 09 15 99 07 25 09 06 07 54 82 07 25 09 06 09 18 17 07 25 09 05 56 56 36 07 25 09 06 11 23 89 07 25 09 06 11 23 54 07 25 09 06 11 26 16 07 25 09 06 11 23 89 07 25 09 06 25 49 35 0
42. SMF30STP SMF30JBN SMF30INP SMF30SCC SMF30DDN SMF30BLK SMF30BSZ 07 25 09 06 00 03 30 07 25 09 06 00 03 30 07 25 09 06 00 03 30 07 25 09 06 00 03 30 07 25 09 06 00 03 30 07 25 09 06 00 03 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 00 14 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 07 21 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 07 25 09 06 09 06 30 BCA9514 BCA9514 BCA9514 BCA9514 BCA9514 BCA9514 SMFEXTR SMFEXTR SMFEXTR SMFEXTR SMFEXTR SMFEXTR SMFEXTR SMFEXTR ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 ROCON23 0000 ROCON23 0000 ROCON23 0000 05 0000 05 0000 05 0000 05 0000 05 0000 SYSUT2 05 0000 SY
43. SORTWKO3 2 Spectrum SMF Writer Tutorial 67 Appendix Examples of SMF Re ports Job Completion Report from SMF 30 Records This example reads as input the SMF file and selects just the type 30 records with a subtype tion records It prints data to identify the job and step and indicate how of 4 step termina it completed The SMF record itself just contains a 2 byte binary value for step completion code SMF30SCC Depending on the form of the value in SMF30SCC we format it as a system abend code user abend code user return code or a normal zero completion code A useful modification to this job would be to select only records with a non zero completion code That could be the basis of a daily exception report These Control Statements KKK KK KK KKK eek eek ee ek ee ek ee ke KEK e ke KK KERR ek ee ek eee SPECIFY THE INPUT FILE AND LAYOUT FOR THIS RUN coke ee KK ee hee eek ee ek ee ek KKK KK KK KEK KK KKK ek ee ek INPUT SMF30 oko eee KK KK eek ee ek ee ek eee KEK e ke KEK KK KKK ek RRR KERR KEE SPECIFY WHICH SMF RECORDS TO INCLUDE IN REPORT KKK KK KK KK KK KK k k k KKK KKK ek e e ke KKK KEK EK KKK ek dee de eee INCLUDEIF SMF30RTY 30 AND SMF30STP 4 KK KKK KKK KKK KK KKK KKK KKK KKK KK KEK KK KK KK KKK KK kok k KERR KEK CREATE A FORMATTED COMP CODE TO SHOW IN REPORT SMF30SCC CAN BE ONNN SYSTEM ABEND CODE x 8NNN USER ABEND CODE 0000 NOR
44. VOLS VOLS VOLS VOLS VOLS RECLAIM SCRATH PRIVATE STACKED SCRATCH TIME ACTIVE ACTIVE ACTIVE ACTIVE ACTIVE PERCENT VOL CNT VOL CNT Spectrum SMF Writer Tutorial 83 Appendix B Examples of SMF Reports DB2 IFC Destination Statistics SMF 100 Records This example reads as input the SMF file and selects just the type 100 DB2 accounting records with IFCID 1 It then prints a report line for each 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 These Control Statements INC 5 100 COL SM100 SM100 QWHSI QWSBN QWSBS QWSBS QWSBS QWSBS QWSBS QWSBS OPTION STCKADJ 0 DON T CONVERT STCK TIMES TO GMT INPUT SMF100 NORMWHEN SM100RTY 100 AND QWHSIID 1 NORMSMF QWSOOR20 ACT NO WF WRI TITLE DB2 IFC DESTINATION STATISTICS TITLE FROM SMF100 IFCID 1 RECORDS QWSB SEGMENTS 100 QWHSIID 1 DTE SMF DATE SMIOOTME SMF TIME RTY 3 REC ID 5 IFCID RSW RECS WRITTEN RNW RECS NOT WRITTEN BUF BUFFER ERRORS ACTIVE ERRORS RNA REC NOT ACCEPTED ER ERRORS Produce this Report DEST RECS SMF DATE SMF TIME REC IFCID NAME WRITTEN 06 12 09 12 03 46 55 100 SMF 06 12 09 12 03 46 55 100 RES 06 12 09 12 03 46 55 10
45. and statistical information about the datasets including average response time and total number of I O s These Control Statements INPUT SMF42 SET DSN TEXT BELOW ALSO SET COMPDSN TO SAME LENGTH COMP TESTDSN LOOK FOR THESE DSN PREFIXES COMP COMPDSN 7 SMF42DSNAM TRUNCATE DSN TO TESTDSN S SIZE INC SMF42RTY 42 TYPE 42 DFSMS STAT RECORDS sy AND 5 425 6 SUBTYPE 6 DASD STATS 7 AND SMF42JDCOD 0 CLOSE STATS NOT INTERVAL STATS AND COMPDSN TESTDSN SELECT DSN S THAT START WITH THIS COLUMNS SMF42JDJNM 8 JOBNAME SMF42JDRSD 8 READER DATE SMF42JDRST 11 READER TIME SMF42JDWSC 8 SMFA42JDWLD 8 SMF42DSNAM 20 SMF42DSIOR 7 IO RATE SMF42DSION 8 NUM IO S SMFA2DSVOL 8 VOLUME SMFA2DSSC 8 STORAGE CLASS SMF42DSBSZ 6 BLOCK SIZE TITLE SMF 42 SUBTYPE 6 DFSMS DATASET CLOSING STATISTICS TITLE FOR DATASETS BEGINNING WITH TESTDSN Produce this Report SMF 42 SUBTYPE 6 DFSMS DATASET CLOSING STATISTICS FOR DATASETS BEGINNING WITH TTAPO1B READER READER I0 NUM STORAGE BLOCK JOBNAME DATE TIME SMF42JDW SMF42JDW 5 4205 RATE 10 S VOLUME CLASS SIZE 01 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 40 4 SYST1B 6 160 01 06 17 09 12 45 56 94 5001 SOOTHER TTAPO1B ISPF ISPPROF 8 4 SYST1B 6 160 01 06 17 09 12 45 56 94 5001 SOOTHER
46. beginning or end of a control group The parms in the BREAK statement to do this are e the HEADING parm e the FOOTING parm You can specify any number of these parms Each parm results in one line that will be printed at the beginning or end of the control group Within these parms specify a print Spectrum SMF Writer Tutorial 51 Lesson 9 Customizing the Control Breaks These Control Statements INPUT SMF14 COPIES SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS A COMPUTE SMF14 JOBID SMF14JBN FORMAT SMF14RSD FORMAT SMF14RST COMPUTE MAX EXCP BYTES SMF14EXCP SMF14 JFCBLKSI COLUMNS SMF14DTE SMF LOG DATE SMFIATME SMF LOG TIME SMF14PGN PROGRAM NAME SMFI4TIOE5 DDNAME SMF14_JFCBDSNM DSNAME 25 SMF14 JFCLRECL LRECL 7 BIZ NOACCUM SMF14EXCP EXCP COUNT FOR DDNAME 9 MAX EXCP BYTES SMF14 JOBID SMF14EXCP D SMF14 JOBID AVERAGE MAXIMUM HEADING EXCP COUNTS FOR JOB SMF14 JOBID FOLLOW FOOTING EXCP COUNT AVERAGE SMF14EXCP AVG 14 EXCP STATISTICS FROM 5 14 RECORDS Produce this Report EXCP STATISTICS FROM SMF 14 RECORDS EXCP SMF SMF COUNT MAX 106 106 PROGRAM FOR EXCP DATE TIME NAME DDNAME DSNAME LRECL DDNAME BYTES EXCP COUNTS FOR JOB AUABB109 11 02 09 12 21 09 33 FOLLOW 11 02 09 12 21 18 82 UASUARCO UASOMPOO 55 5 51 0 0 24 572 9 001 221 208
47. feature of Spectrum SMF Writer It allows you to scan a field to see if a given text appears anywhere within it This is a very handy feature for writing condition expressions with Spectrum SMF Writer For example INCLUDEIF SMF30JBN ACCT1000 OR SMF30 JFCBDSN PROD ACCT The above statement will include any record whose jobname is AccT1000 or where the dataset name contains the characters PROD ACCT somewhere within it Character Literals Character literals must appear within single or double quote marks To embed the same quote character within the literal double it The following are all valid examples of a character literal JONES JONES JONE S JONE S Character literals can also be specified in hexadecimal format by prefixing the literal with an X like this X FFFF Numeric Literals Numeric literals should not be contained within quotes No punctuation is allowed other than a minus sign and a decimal point Date Literals Date literals should be in either MM DD YY or MM DD YYYY format leading zeros not required If you use YY in your date literals it is understood to represent a year between 1951 and 2050 However you can specify your own cutover year by specifying the CENTURY option Spectrum SMF Writer Tutorial 57 Appendix A Conditional Expressions International Customers you may want to specify the following option near the beginning of your control statements OPTION DDMMYY
48. ke ko e ke koe EK RRR ek SORT AND BREAK ON SMF30WID WHICH IS THE WORK TYPE INDICATOR FIELD TO GET SUBTOTALS III III III SORT SMF30WID BREAK SMF30WID SPACE 1 KKK KKK KK KKK KK RK KKK KKK KK KKK RK KK KEK KK KKK KK KKK KEK KEK NOW DEFINE A NEW REPORT TO MAKE FROM THE SAME PASS OF THE SMF FILE KK KKK KK KK KEK KK KKK KK KK KK KK KK KKK KK KK ek NEWOUTPUT KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KK KKK KK RRR KERR EK SPECIFY WHICH SMF RECS TO INCLUDE IN THIS REPORT KK KKK KK KK KKK KKK KKK KK KK KK KKK KEK KK KK KK KERR KK ee KEK RE KEK INCLUDEIF SMF30RTY 30 AND SMF30STP 5 KKK ee KKK KKK KKK KKK KKK KK KKK RK KK KK KK KKK KK RRR BREAK THE TASK DOWN INTO CATEGEORIES THAT ARE MORE USEFUL FOR THIS SHOP THAN SMF30WID VALUES KEK KER ke he ke RRR e k k k k k k k k k k k COMPUTE WORK TYPE WHEN SMF30JBN CICS ASSIGN CICS REGIONS WHEN SMF30JBN DB2 ASSIGN DB2 REGIONS WHEN SMF30WID STC ASSIGN STARTED TASKS WHEN SMF30WID TSO ASSIGN TSO SESSIONS ELSE ASSIGN BATCH JOBS TITLE NUMBER OF TASKS BY TYPE COLUMNS WORK TYPE SMF30JBN SMF30JNM SMF30DTE SMF30TME SMF30STD SMF30SIT ELAPSED SECS 8 ELAPSED HRS 7 SORT WORK TYPE BREAK WORK TYPE SPACE 1 KKK KKK KKK KK KK KKK KK KK KK KKK KK RK KK KK KK KKK KK KR KK RRR KEK NOW DEFINE ANOTHER REPORT TO MAKE FROM THE SAME
49. logical records Each logical record contains just a single EXCP section Using this logically expanded input file it is then easy to use the standard 4GL syntax to make useful reports from the array of EXCP data in each type 30 record That is because normalization puts a single EXCP section at the same location in each logical record Since the main purpose here is just to illustrate how to normalize an input file this example simply lists some fields from the EXCP sections of a few records Specifically we list the SMF30DEV device class SMF30DDN DDNAME and SMF30BLK block count fields from the EXCP section The other report fields all come from the constant portion of the SMF 30 record By the way there are many different kinds of variable sections in the SMF type 30 record not just EXCP sections For example there are I O activity sections processor accounting sections performance sections storage sections and others You can normalize any of these sections using this same technique with Spectrum Writer You can even normalize more than one section of the record in the same run These Control Statements INPUT SMF30 NORMWHEN SMF30RTY 30 NORMSMF SMF30E0F INCLUDEIF SMF30RTY 30 amp SMF30SID DEV1 amp SMF30STP 4 KERLE ADDRESS SPACE ACTIVITY COLUMNS SMF30DTE SMF30TME SMF30SID SMF30JBN SMF30PGM SMF30STM SMF30JNM SMF30DEV SMF30DDN SMF30BLK SORT SMF30DTE SMF30TME
50. much the same way that we normally include data from only a single SMF record type in a given report Spectrum SMF Writer however does support the normalization of more than one section at a time And we will discuss that in the section that follows How to Normalize Multiple Nested Sections There is one case where it actually does make sense to normalize multiple sections in the same report And that is when one section contains an embedded section In that case you may well want to first normalize the outer section so your report includes all occurrences of that section And then for each of those occurrences you would also want to see all occurrences of the section that is embedded within it The SMF 70 record RMF Processor Activity provides just such a situation So we will use it for an example In the fixed portion of the SMF 70 subtype 1 record there is this standard triplet SMF80BCS SMF80BCL and SMF80BCN These fields define an Partition Data Section which occurs once for each configured logical partition Within this LPAR Data Section there are two additional fields SMF70BDN and SMF70BDS These fields when used together with an additional triplet SMF70BVS SMF70BVS and SMF70BVS identify a number of LPAR Processor Data Sections These sections contain information about all of the logical processors associated with that LPAR Have we lost you yet Spectrum SMF Writer Tutorial 19 Lesson 3 How to Repo
51. of the past month each of our CICS regions was up and running or what percentage it was down by deduction To do this we read that full month s SMF records We must also ensure that we read enough records from the current month to get the job termination record for the final CICS session that began in the previous month From this input we select just the SMF type 5 Job Termination records for jobs beginning with CICSP SMF writes one type 5 record each time a background job terminates This record includes the job s begin and end date time which we can use to compute the session s elapsed time For the final session of the month we use the end of the month as the end time for our elapsed time computation And for the first session of the month we use the beginning of the month as the begin time for the computation We sort the report on CICS region to sort all of the sessions for each region together We add a BREAK statement on region to get region totals for the month These totals that automatically print tell us the total up hours for each region for the last month For each session we also compute its elapsed time as a percentage of the total hours in the month While not very meaningful for an individual session in the total line we can see what percentage of the month the CICS region was available a very useful number to monitor on a month to month basis By uncommenting the SUMMARY option statement below you can omi
52. on the INPUT statement to limit the records read from the SMF file during testing page 542 how to use the MAXINCLUDE and MAXINPUT options to limit the records read from the SMF file during testing the complete syntax for the INPUT INCLUDEIF and COLUMNS statements in Chapter 10 Control Statement Syntax 8 Spectrum SMF Writer Tutorial Lesson 2 How to Export SMF Data to PC Programs This lesson teaches you how to turn your SMF data into PC export files It also explains how to produce two or more different outputs reports and or files during a single pass of the input file The control statements discussed are e the PC parm of the OPTIONS statement e the NEWOUT statement To create a PC export file instead of a report just add this OPTION statement near the beginning of your control statements OPTION PC MAKE A PC FILE INSTEAD OF A REPORT INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS x COLUMNS SMFI4DTE 5 14 SMF14JBN SMF14PGN SMF14TIOE5 5 14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP Figure 2 shows a portion of the PC file created with the above statements It also shows the spreadsheet obtained after importing the PC file into Excel Let s examine what each statement does The OPTION statement above tells Spectrum SMF Writer that you want to produce a comma delimited PC file instead of a report in this run Such PC files can be imported into virtua
53. the above INPUT statement in Figure 15 page 55 20 Spectrum SMF Writer Tutorial Lesson 3 How to Report on Multiple Occurrences of Section Summary Here is a summary of what we learned in this lesson add a NORMWHEN and a NORMSMF parm to your INPUT statement to process all of with certain non standard sections you will NORMWHEN and a NORMLIZE parm inetad you can use multiple NORMSMF NORMALIZE parms to process nested recurring sections The next lesson will teach you how to customize the titles in your report To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can learn more about the normalization process in these places e afuller explanation of the normalization process is found in Chapter 4 Beyond the Basics beginning on page 237 e the complete syntax for the parms related to normalization is found in Chapter 10 Control Statement Syntax page 542 Spectrum SMF Writer Tutorial 21 Lesson 4 How to Make Your Own Report Titles This lesson teaches you how to specify your own report titles The control statement discussed is e the TITLE statement How to Use the TITLE Statement As we ve seen in the previous lessons a TITLE statement is not required to produce a report If you do not supply a TITLE statement Spectrum SMF Writer provides a default title To specify your own report titles simply use one or more TITLE
54. 0 ASSIGN 21 45 WHEN BEG TIME 22 15 00 ASSIGN 22 00 WHEN BEG TIME 22 30 00 ASSIGN 22 15 WHEN BEG TIME lt 22 45 00 ASSIGN 22 30 WHEN BEG TIME 22 00 00 ASSIGN 22 45 WHEN BEG TIME 23 15 00 ASSIGN 23 00 WHEN BEG TIME 23 30 00 ASSIGN 23 15 WHEN BEG TIME lt 23 45 00 ASSIGN 23 30 ELSE ASSIGN 23 45 COMPUTE ELAPSED TIME MKNUM SMF30TME SMF30PPS COMPUTE CPU_SECS MKNUM SMF30CPT COMPUTE JOB QUEUE 0 SMF30JQT 1024 COMPUTE STORAGE_USED SMF30PRV SMF30SYS COMPUTE TAPE_MOUNTS SMF30PTM SMF30TPR COMPUTE PAGE SWAPS SMF30PGI SMF30PGO COMPUTE JOB COUNT 1 KK KKK ek ee KK KKK KK KKK KKK KKK KKK KEK KK KKK KK KERR KERR KEK SPECIFY WHICH SMF FIELDS TO SHOW IN RPT COLUMNS WE ALSO OVERIDE SOME COLUMN WIDTHS AND HEADINGS KKK KKK KK KK KK KKK KKK KKK KK KKK KEK KK KK KK KKK KK ee ek RRR KEK COLUMNS TIME JOB BEGIN TIME JOB COUNT 5 CPU SECS AVG CPU TIME SECS 9 CPU SECS MAX CPU TIME SECS 9 ELAPSED TIME AVG ELAPSED TIME SECS 9 ELAPSED TIME MAX ELAPSED TIME SECS 9 JOB QUEUE TIME AVG SECS IN JOB QUEUE 7 STORAGE USED AVG STORAGE PER JOB K S 7 TAPE MOUNTS AVG NUM TAPE MOUNTS 7 PAGE SWAPS AVG NUM PAGE SWAPS 7 coke eee KK KK eek ee ek ee KK KKK ko KK KEK KK KKK ek eee SUMMARIZE BY TIME SLOT KK KKK KK KK ee ek eek ee ek ee ek ee ke ko e ke KEK KK KKK ek ee ek RRR KEK SORT TIME BREAK
55. 0 00 142 00 00 00 000000 00 00 00 000000 00 30 00 1428 12 30 09 00 52 39 COIO CICSVTIN 00 20 32 782153 00 50 32 667259 29 59 885 00 00 00 000000 00 00 00 000000 00 29 59 8851 12 30 09 00 30 16 CICSVWRS 23 59 08 538353 00 29 08 419178 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 01 15 17 COIO CICSVWRS 00 59 08 299732 01 14 08 502507 15 00 203 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 52 54 CSKL CICSVATM 23 52 54 197580 00 22 54 077883 29 59 880 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 01 00 38 CSNC CICSVWLK 00 15 37 607961 00 45 37 488564 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 27 32 CSNE CICSVBKT 23 38 16 277222 00 08 16 158398 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 51 06 CSSY CICSEAI 00 06 06 134042 00 21 06 336672 15 00 203 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 29 09 23 57 38 CSSY CICSVCRD 23 25 46 020150 23 55 45 901009 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 00 27 39 CSSY CICSVCRD 23 55 45 901009 00 25 46 043884 30 00 143 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 23 00 CSSY CICSVTIN 23 50 32 901126 00 20 32 782049 29 59 881 00 00 00 000000 00 00 00 000000 00 29 59 8809 12 30 09 01 07 43 CSSY CICSVTIN 00 50 32 667043 01 05 32 867509 15 00 201 00 00 00 000000 00 00 00 000000 00 15 00 2004 2 30 09 00 00 07 CSSY CICSVWRS 23 29 08 395441 23 59 08 538121 30 00 143 00 00 00 000000 00 00 00 000000 00 00
56. 0 53 09 169786 0 005 00 00 00 001802 00 00 00 001798 00 00 00 0032 12 30 09 01 05 33 NA20 CICSVTIN 01 00 41 360650 01 00 41 366474 0 005 00 00 00 001834 00 00 00 001799 00 00 00 0039 12 30 09 01 15 16 NA20 CICSVTIN 01 08 13 559012 01 08 13 563552 0 005 00 00 00 001847 00 00 00 001838 00 00 00 0026 12 30 09 01 22 48 NA20 CICSVTIN 01 15 45 758016 01 15 45 762949 0 005 00 00 00 001797 00 00 00 001794 00 00 00 0031 12 30 09 01 30 20 NA20 CICSVTIN 01 23 17 955831 01 23 17 961375 0 005 00 00 00 001818 00 00 00 001804 00 00 00 0037 90 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports Hardware Capacity and Stastistics Report from SMF 113 Records In these reports we read the SMF file and select just the type 113 Hardware Capacity Reporting and Statistics records The first report shows the contents of all Counter Set segments It also shows the actual counter value for the first counter of the first counter set The second report shows the contents of all of the actual counters themselves You can use the two reports together along with a key to the counter maps for your level of z OS to assign meanings to the counter values These Control Statements INPUT SMF113 NORMWHEN SMF113RTY 113 AND SMF113STY 2 NORMSMF SM INCLUDEIF SMF113RTY 113 TITLE SMF113 HARDWAR TITLE ONE LINE PER COU COLUMNS SMF113 2 CTS STAR SMF113 2 CTM END C SMF113DTE END COLL SMF113 2 CPU PROC SMF113 2 CST C
57. 0 GTF 06 12 09 12 03 46 55 100 SRV 06 12 09 12 03 46 55 100 SR1 06 12 09 12 03 46 55 100 SR2 06 12 09 12 03 46 55 100 0 1 06 12 09 12 03 46 55 100 0 2 06 12 09 12 03 46 55 100 0P3 06 12 09 12 03 46 55 100 0 4 06 12 09 12 03 46 55 100 0 5 06 12 09 12 03 46 55 100 0 6 06 12 09 12 03 46 55 100 0 7 06 12 09 12 03 46 55 100 0 8 06 12 09 12 03 46 55 100 106 06 12 09 12 03 51 48 100 SMF 06 12 09 12 03 51 48 100 RES 06 12 09 12 03 51 48 100 GTF 06 12 09 12 03 51 48 100 SRV 06 12 09 12 03 51 48 100 SR1 06 12 09 12 03 51 48 100 SR2 06 12 09 12 03 51 48 100 0 1 06 12 09 12 03 51 48 100 0 2 06 12 09 12 03 51 48 100 0P3 06 12 09 12 03 51 48 100 0 4 06 12 09 12 03 51 48 100 0 5 06 12 09 12 03 51 48 100 OP6 06 12 09 12 03 51 48 100 OP7 06 12 09 12 03 51 48 100 0 8 06 12 09 12 03 51 48 100 106 06 12 09 12 03 52 19 100 SMF 06 12 09 12 03 52 19 100 RES 84 Spectrum SMF Writer Tutorial DB2 IFC DESTINATION STATISTICS FROM SMF100 IFCID 1 RECORDS QWSB SEGMENTS RECS NOT BUFFER NOT ACTIVE REC NOT WRITTEN ERRORS ERRORS ACCEPTED E Ocwoooooooooooooooeoooooooooocoooo Seo S soe Se 55505 gt gt gt S S S 63 2 oe S E20 S S 63 WRITER ERRORS Appendix B Examples of SMF Reports DB2 Accounting Statistics by Plan from SMF 101 Records This example reads as input the SMF file and selects just the type 101 DB2 Accounting records wit
58. 00 ASSIGN 3 15 00 ASSIGN 3 30 00 ASSIGN 3 45 00 ASSIGN 4 00 00 ASSIGN 4 15 00 ASSIGN 4 30 00 ASSIGN 4 45 00 ASSIGN 5 00 00 ASSIGN 5 15 00 ASSIGN 5 30 00 ASSIGN 5 45 00 ASSIGN 6 00 00 ASSIGN 6 15 00 ASSIGN 6 30 00 ASSIGN 6 45 00 ASSIGN 7 00 00 ASSIGN 7 15 00 ASSIGN 7 30 00 ASSIGN 7 45 00 ASSIGN 8 00 00 ASSIGN 8 15 00 ASSIGN 8 30 00 ASSIGN 8 45 00 ASSIGN 9 00 00 ASSIGN 9 15 00 ASSIGN 9 30 00 ASSIGN 9 45 00 ASSIGN 20 00 00 ASSIGN 20 15 00 ASSIGN 20 00 20 30 00 ASSIGN 20 15 20 45 00 ASSIGN 20 30 21 00 00 ASSIGN 20 45 XO tO tO tO OO OY OY OY Ov Oi S S O O N Pe PONY UN KU ROI AG Ra AG A iN OA A ce A UN Ao UN LIN A A IN UN AP PN X X 4 3X 4X 34 X 4 3X X X X 40 X X 4X X m 40 X 45 45 mu s X m Spectrum SMF Writer Tutorial 71 Appendix B Examples of SMF Reports These Control Statements cont WHEN BEG TIME 21 15 00 ASSIGN 01 00 WHEN BEG TIME 21 30 00 ASSIGN 21 15 WHEN BEG TIME lt 21 45 00 ASSIGN 21 30 WHEN BEG TIME 21 00 0
59. 00 000 24 448 183 2 708 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 3 15 9 393 375 CRAF_HBP8KO 09 30 00 10 00 000 5 632 191 5 4666 24 22 21 25 874 640 CRAF_HBP8KO 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 GBPO 09 30 00 10 00 000 2 688 37 535 3 595 CTBA GBPO 09 30 00 10 00 000 2 688 71 1 601K 6 25 41 28 214 1 074 09 30 00 10 00 000 2 304 14 217K 1 213 14 9 086 356 09 30 00 10 00 000 2 304 6 11 09 30 00 10 00 000 920 CTBA_GBP11 09 30 00 10 00 000 920 14 134K 1 108 14 8 815 351 GBP16K0 09 30 00 10 00 000 896 15 272K 1 488 14 8 664 348 GBP16K0 09 30 00 10 00 000 024 CTBA GBP2 09 30 00 10 00 000 2 816 30 629 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 408 _6 21 09 30 00 10 00 000 408 14 119K 1 054 14 8 754 350 CTBA GBP32K 09 30 00 10 00 000 664 57 1 087 5 867 31 21 332 812 CTBA GBP32K 09 30 00 10 00 000 792 29 414K 2 642 CTBA_GBP8KO 09 30 00 10 00 000 2 048 30 352 2 486 CTBA_GBP8KO 09 30 00 10 00 000 2 048 55 807 5 043 34 23 816 898 CTBA LOCKI 09 30 00 10 00 000 3 072 1 046
60. 00 0000 12 30 09 00 45 37 CSSY CICSVWLK 23 45 37 726665 00 15 37 607789 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 01 23 29 CSTP CICLUTIN 00 23 28 680285 00 53 28 561157 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 01 00 45 CSTP CICSVCRD 00 25 46 043924 00 55 45 928358 29 59 884 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 01 30 45 CSTP CICSVCRD 00 55 45 928358 01 25 46 067593 30 00 140 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 29 09 23 46 30 10 CICSVWRS 23 45 09 415186 23 45 09 417277 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 29 09 23 57 55 10 CICSVWRS 23 56 42 786625 23 56 42 788684 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 00 09 00 10 CICSVWRS 00 07 46 010429 00 07 46 012820 0 003 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 11 33 NA10 CICSVWRS 00 10 16 743547 00 10 16 745772 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 14 06 NA10 CICSVWRS 00 12 47 475928 00 12 47 478273 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 00 16 40 10 CICSVWRS 00 15 18 208815 00 15 18 211266 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 28 05 NA10 CICSVWRS 00 26 51 579611 00 26 51 581779 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 36 36 NA10 CICSVWRS 00 35 24 072558 00 35 24 074685 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 00 39 09 10 CICSVWRS 00 37 54 803954 00 37 54 806177 0 0
61. 02 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 30 26 0 00 26 2 KB PRD1 PO M0143181 JAIS 000002 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 31 01 0 01 36 8 KB PRD1 PO M0143181 JAIS 000002 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 31 63 0 00 4 1 PRD1 PO M0143181 JAIS 000002 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 31 99 0 00 6 2 KB PRD1 PO M0143181 JAIS 000002 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 32 61 0 00 6 5 LMA PRD1 P0 M0143181 JAIS 000 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 08 33 66 0 00 1 5 KB LMA PRD1 P0 M0143181 JAIS 000 STXA81A STOR 100 59 162 15 00 62 110 26 C931169 ASCI 13 09 29 15 0 07 0 3 MB TO WH PO BATCHABS NONE D09082 STXA81A STOR 100 59 162 15 00 62 110 26 C931169 ASCI 13 10 27 04 0 05 0 3 009082 STXA81A STOR 100 59 162 15 00 62 110 26 C931169 ASCI 13 11 16 71 0 06 0 3 MB TO WH PO BATCHABS CSS512 D090 STXA81A STOR 199 8 12 25 00 62 110 26 MCMX98 ASCI 13 11 28 90 0 01 0 1 MB PRD1 P0 S3230860 JAIS 000003 Spectrum SMF Writer Tutorial 97 Appendix B Examples of SMF Reports Java CPU Times Report from SMF 120 5 Records 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 120 WebSphere Application records for Java 2 Enterprise Edition containers It then prints a report line fo
62. 02 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 41 43 NA10 CICSVWRS 00 40 25 537018 00 40 25 539253 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 30 09 00 44 16 10 CICSVWRS 00 42 56 269533 00 42 56 271769 0 002 00 00 00 000000 00 00 00 000000 00 00 00 0000 2 29 09 23 45 50 NA20 CICSVTIN 23 38 47 471498 23 38 47 476270 0 005 00 00 00 001843 00 00 00 001778 00 00 00 0029 2 29 09 23 50 33 NA20 CICSVTIN 23 46 19 671154 23 46 19 675617 0 005 00 00 00 001718 00 00 00 001708 00 00 00 0027 2 30 09 00 00 24 NA20 CICSVTIN 23 53 21 721659 23 53 21 726867 0 005 00 00 00 001815 00 00 00 001812 00 00 00 0033 12 30 09 00 07 56 NA20 CICSVTIN 00 00 53 919979 00 00 53 924962 0 005 00 00 00 001821 00 00 00 001815 00 00 00 0031 12 30 09 00 15 28 NA20 CICSVTIN 00 08 26 118493 00 08 26 123417 0 005 00 00 00 001948 00 00 00 001831 00 00 00 0029 2 30 09 00 20 33 NA20 CICSVTIN 00 15 58 316783 00 15 58 324343 0 007 00 00 00 001817 00 00 00 001803 00 00 00 0057 12 30 09 00 30 33 NA20 CICSVTIN 00 23 30 519874 00 23 30 524807 0 005 00 00 00 001896 00 00 00 001815 00 00 00 0030 12 30 09 00 38 05 NA20 CICSVTIN 00 31 02 713904 00 31 02 718752 0 005 00 00 00 001805 00 00 00 001768 00 00 00 0030 12 30 09 00 45 37 NA20 CICSVTIN 00 38 34 912368 00 38 34 917524 0 006 00 00 00 001834 00 00 00 001804 00 00 00 0033 12 30 09 00 50 33 NA20 CICSVTIN 00 46 07 113059 00 46 07 117908 0 005 00 00 00 001818 00 00 00 001817 00 00 00 0030 12 30 09 01 00 11 NA20 CICSVTIN 00 53 09 164768 0
63. 1 58 53 19 ITEMS additional lines not shown Figure 10 Using the BREAK statement to create a control break Spectrum SMF Writer Tutorial 45 Lesson 8 How to Specify the Sort Order and Control Breaks If you want to skip to a new page whenever the contents of a field changes use the PAGE spacing parm like this BREAK SMF14SID SPACE PAGE The SPACE PAGE parm specifies that rather than printing 2 blank lines whenever the SMF14SID field the System Identification changes the report should skip to a new page Note you also specify the NOTOTALS parm on the BREAK statement if you only want blank lines or a new page at the break and do not also want totals BREAK SMF14SID NOTOTALS How to Create a Summary Report A summary report is one which does not show the detail information for every record included in the report Instead the detail information is summarized and only the totals are printed in the report Control breaks are used to create the desired total lines Consider again the report in Figure 10 page 45 It is a detail report that lists the EXCP count for every DDNAME accessed by a job in the SMF file The control break on SMF14 JOBID causes a total line to print after the detail lines for each job By just adding the following statement we can suppress the detail lines and print only those job totals OPTIONS SUMMARY Figure 11 shows a summary report that uses the above sta
64. 10S1_MNDRA F SMF110RTY 110 AND SMF110STY 1 ODTE SMF DATE OTME SMF TIME TP 99 99 99 ORTY 3 REC TYP OSTY 3 SUB TYP 0S1 1 4 CLASS OF DATA 0S1 TRAN TRAN 0S1 USERID 051 START START TIME TP 99 99 99 0S1 STOP 0S1 PGMNAME 0S1 SRVCLSNM 8 SERVICE CLASS SMF 110 SUBTYPE 1 CICS MONITORING DATA PERFORMANCE RECORDS FOR SMF110DTE SORTED BY CICS TRANSACTION F110S1 TRAN 2 NOTOTALS Produce this Report SMF 110 SUBTYPE 1 CICS MONITORING DATA PERFORMANCE RECORDS FOR 08 24 10 SORTED BY CICS TRANSACTION CLAS REC SUB SMF110S1 START SMF110S1 SMF110S1 SERVICE SMF DATE SMF TIME TYP DATA TRAN USERID TIME STOP PGMNAME CLASS 08 24 10 11 47 28 110 3 CRSQ W24AA01 10 47 04 10 47 03 618166 DFHCRQ CICSCPSM 08 24 10 11 48 17 110 3 CRSQ W24AA01 10 47 03 10 47 03 448452 DFHCRQ CICSCPSM 08 24 10 11 58 28 110 3 CRSQ W24AA01 10 58 13 10 58 12 701763 DFHCRQ CICSCPSM 08 24 10 11 59 41 110 3 CRSQ W24AA01 10 59 40 10 59 39 733808 DFHCRQ CICSCPSM 08 24 10 11 31 37 110 3 CSKP W24AA01 10 30 56 10 30 56 408895 DFHRMXN3 CICSMISC 08 24 10 11 33 46 110 3 CSKP W24AA01 10 31 57 10 31 56 772842 DFHRMXN3 CICSMISC 08 24 10 11 38 48 110 3 CSKP W24AA01 10 38 38 10 38 38 174839 DFHRMXN3 CICSMISC 08 24 10 11 48 51 110 3 CSKP W24AA01 10 48 44 10 48 43 822947 DFHRMXN3 CICSMISC 08 24 10 11 59 33 110 3 CSKP W24AA01 10 57 38 10 57 37 741627 DFHRMXN3 CICSMISC 08 24 10 11 42 06 110 3 CWBG W24AA01 10 40 01 10 40 00 609872
65. 200 C23CL1 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 308 10 23 02 80 35200 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 332 10 23 02 80 3 200 C23CL1 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 312 10 23 02 80 3 200 23 11 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 324 10 23 02 80 352008 6029 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 328 10 23 02 80 352008 DB29AT 08 01 07 20 03 53 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 64 10 23 02 80 3 200 23 11 62 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports Count of Tasks by Type of Work Report from SMF 30 In this example we read the SMF file once and make 3 separate reports during that single pass of the large SMF file In this example each report selects the same records just the type 30 records with a subtype of 5 job termination records But Spectrum SMF Writer allows you to specify different selection criteria for each report if desired We then compute the elapsed time by subtracting the Job start date time from the date time the log record is written at job termination time We computed the elapsed time both in seconds and in hours For a job run monthly you would probably want the hours to print in the report For a days worth of data you could show seconds Or create an elapased minutes field Or print the ela
66. 3 00 00 05 28 00 00 04 73 122109 12 18 002 0 0 180 02 0 60 5225 3 15 0 46 00 00 09 80 00 00 09 01 TOTALS 12 25 646 256 46 0 91 4 78 0 69 00 00 15 08 00 00 13 74 DUMPSMF DUMP 38 489 0 0 384 89 1 07 5 25 5 62 0 39 00 00 37 44 00 00 00 29 TOTALS DUMP 38 489 384 89 55 62 0 39 00 00 37 44 00 00 00 29 LOGWRTR LOGW 18 0 0 0 18 0 26 5 25 1 37 0 00 00 00 00 92 00 00 00 37 TOTALS LOGW 18 0 18 0 26 1 37 0 00 00 00 00 92 00 00 00 37 Spectrum SMF Writer Tutorial 75 Appendix B Examples of SMF Reports Produce this Report cont PZ144431 714 71 0401 0 77 0 02 0 78 0 21 0 00 00 00 11 11 00 00 10 80 7144557 714 77 0 01 0 77 225 50 21 0 00 00 00 20 59 00 00 20 44 PZ144452 714 77 0 01 50 77 0 04 5 25 50 21 0 00 00 00 16 69 00 00 16 25 PZ144683 714 S ET 0 77 0 04 5 25 0 21 0 00 00 00 10 60 00 00 10 42 PZ144664 714 LP 0 01 0 77 0204 5225 50 21 0 00 00 00 18 88 00 00 18 53 PZ144548 714 9 0 01 0 77 0 04 5 25 0 21 0 00 00 00 08 69 00 00 08 49 PZ144589 714 0 77 3087 uH 25 0 26 0 00 00 00 08 68 00 00 08 51 2144577 714 777 0 01 50 77 0 04 5 25 0 21 0 00 00 00 11 96 00 00 11 77 PZ144518 714 0 77 0 04 5 25 0 21 0 00 00 00 15 80 00 00 15 63 PZ144656 714 feo MESE 50 77 0 04 5 25 0 21 0 00 00 00 08 91 00 00 08 73 7144405 714 77 0 01 50 77 0 04 5 25 0 21 0 00 00 00 15 84 00 00 15 66 PZ144488 714 0 01 50 77
67. 30STI BITS 7 1 COMPUTE CC HEX FORMAT SMF30SCC HEX COMPUTE SUBSTR CC HEX 1 1 COMPUTE CC DROP 8 SMF30SCC 32768 BIN VALUE W O LEADING X 8 COMPUTE COMP CODE WHEN SMF30SCC WHEN ABEND BIT 0 ASSIGN FORMAT SMF30SCC P ZZZZ9 0 _ ASSIGN S SUBSTR CC HEX 2 3 8 ASSIGN U FORMAT CC MINUS 8 P ZZZ9 WHEN CC NIB1 0 ASSIGN WHEN CC NIB1 The above code first extracts just the abend bit out of the 2 byte SMF30STI field Two other COMPUTE statements extract Just the first nibble from the SMF30SCC field Another calculates the binary value of the SMF30SCC field after ignoring the X 8 user abend indicator which is in the sign bit The conditional COMPUTE statement for COMP CODE formats our final result When 5 05 is 0 we just set COMP CODE to blanks Otherwise if the abend bit is off we set COMP CODE to a normal completion code value Otherwise if the first nibble of SMF30SCC is 0 we format the remaining three hex digits with an S prefix as a system abend code Otherwise if the first nibble is 787 we format the rest of the SMF30SCC field as a binary user abend value with a U prefix The report in Figure 7 page 37 uses these COMPUTE statements Using COMPUTEs to Report on Different SMF Record Types Here is a technique for reporting on two different SMF record types in the same report Let s say that we want a report that shows all changes made to any dat
68. 4 COMP SRB CPU MAKENUM SMF30CPS CHG TIME TO SECS KK KKK KK ek eee eek ee ek ee ek eee KKK KK KK KKK KK KERR KERR KEK COMPUTE ELAPSED TIME IN SYSTEM KKK KK KKK KK ek e e ke KEK k ke KK EK KKK ek ee ek COMP ELAP SYS MAKENUM SMF30DTE 86400 MAKENUM SMF30TME 4MAKENUM SMF3ORSD 86400 MAKENUM SMF3ORST 74 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports These Control Statements cont KKK ee ek KK KKK e ke KKK KKK KKK KK KK KK KKK KKK KKK KERR COMPUTE ELAPSED EXECUTION TIME k k k k k k k k k k k k k k k k kk kk kk k x COMP ELAP EX WHEN SMF30PPS lt ASSIGN MAKENUM SMF30TME MAKENUM SMF30PPS ELSE ASSIGN MAKETIME 88640 MAKENUM SMF30TME MAKENUM SMF30PPS KKK KK KK KK KKK KK KK KK KK KKK KK KK ee KKK KK KK KKK RRR ERR ASSIGN A MADE UP COST FOR DEMO PURPOSES wi FEI II III III I COMP FAKE IO RATE 01 PENNY PER EXCP COMP FAKE IO CHG SMF30TEX FAKE IO RATE COMP SMF30CPT SECS COMP FAKE CPU RATE COMP FAKE CPU CHG 2 MAKENUM SMF30CPT 5 25 5 25 PER CPU SECOND MAKENUM SMF30CPT FAKE_CPU_RATE KKK KKK KKK KKK KK KKK KKK KKK KK KK ee KEK KKK KK KKK KEKE k Xk kok SPECIFY WHICH SMF FIELDS TO SHOW IN RPT COLUMNS WE ALSO OVERIDE SOME COLUMN WIDT
69. 46123 0 796336 44 1 acessLogon jsp 0 214795 7 00 00 11 51 AWX4 451 05 00 07 361743 05 00 07 370785 0 009042 ATX44 userhome jsp 0 005556 7 00 00 16 51 AWX4 451 05 00 11 728713 05 00 11 759218 0 030505 ATX4 ATX44 en_US common locale 0 000034 7 00 00 16 51 AWX4 451 05 00 11 728713 05 00 11 759218 0 030505 ATX4 ATX44 en_US common recent 0 000032 7 00 00 16 51 AWX4 451 05 00 11 728713 05 00 11 759218 0 030505 ATX4 44 en US cp TPAInvesti 0 025579 7 00 00 16 51 AWX4 451 05 00 11 728713 05 00 11 759218 0 030505 ATX4 ATX44 en_US common footer 0 000028 7 00 00 16 51 AWX4 451 05 00 11 728713 05 00 11 759218 0 030505 ATX4 ATX44 en_US common header 0 000176 7 00 00 16 51 AWX4 451 05 00 11 728713 05 00 11 759218 0 030505 ATX4 ATX44 ActionServlet 0 026826 7 00 00 16 51 AWX4 451 05 00 14 025154 05 00 14 033578 0 008424 ATX44 en_US common locale 0 000033 7 00 00 16 51 AWX4 451 05 00 14 025154 05 00 14 033578 0 008424 ATX44 en_US common recent 0 000031 7 00 00 16 51 AWX4 451 05 00 14 025154 05 00 14 033578 0 008424 ATX44 en_US common footer 0 000028 7 00 00 16 51 AWX4 451 05 00 14 025154 05 00 14 033578 0 008424 ATX44 en_US common header 0 000172 GRAND TOTAL 20 ITEMS 140 1 235038 1 Spectrum SMF Writer Tutorial 99 Index Symbols DATE built in field 22 23 DAYNAME built in field 23 ZHHMMSS
70. 69 12 98 CICSPX23 09 05 10 00 48 43 33 09 05 10 01 03 26 26 0 245258 0 03 CICSPX23 09 05 10 01 11 04 59 09 12 10 01 03 04 44 167 866625 22 56 CICSPX23 09 12 10 01 08 17 10 09 19 10 01 02 48 56 167 908739 22 57 CICSPX23 09 19 10 01 28 24 12 09 25 10 02 11 32 29 144 718936 9 45 5 23 09 25 10 03 15 42 77 09 26 10 01 02 28 82 21 779458 2 93 5 23 09 26 10 01 07 15 02 10 03 10 01 03 14 93 118 878883 15 98 TOTAL FOR CICSPX23 7 ITEMS 718 097368 96 52 CICSPX24 08 29 10 01 09 54 35 09 05 10 00 41 33 96 96 692767 13 00 CICSPX24 09 05 10 00 48 41 31 09 05 10 01 03 00 58 0 238686 0 03 CICSPX24 09 05 10 01 11 02 67 09 12 10 01 02 45 38 167 861864 22 56 CICSPX24 09 12 10 01 08 15 06 09 19 10 01 02 22 82 167 902155 22 575 CICSPX24 09 19 10 01 28 22 10 09 25 10 02 11 13 33 144 714230 19 45 CICSPX24 09 25 10 03 15 41 74 09 26 10 01 02 15 26 21 775978 2 93 CICSPX24 09 26 10 01 07 13 00 10 03 10 01 02 58 30 118 879444 15 98 TOTAL FOR CICSPX24 7 ITEMS 718 065124 96 51 additional lines not shown Spectrum SMF Writer Tutorial 61 Appendix B Examples of SMF Reports Dataset Usage by Jobname from SMF 14 Records This example reads as input the SMF file and selects just the type 14 records for the day we want to report on It prints a report line for each dataset opened on that day The report shows job information and EXCP count for each dataset accessed It groups report lines by unique job and puts a single blank li
71. 7 LPAR section in SMF 70 record 19 53 Maximum records read from input file 8 value in control group printing 51 which columns receive 28 MAXIMUM MAX parm in BREAK statement 51 in COLUMNS statement 28 Microsoft Excel example 9 10 Midnight elapsed times that cross 34 Minimum value in control group printing 51 which columns receive 28 MINIMUM MIN parm in BREAK statement 51 in COLUMNS statement 28 Minus sign blanks required around 31 Missing data 14 Months abbrevations 25 spelling out name 25 MQ Websphere MQ queue report 93 Multiple control breaks 48 input files 86 nested triplets 19 NORMSMF or NORMALIZE parms 19 report lines per record 8 reports per run 11 63 SMF record types in same report 38 titles 22 N Names getting list of field names 6 Spectrum SMF Writer Tutorial 103 Index Narrower making a column narrower 28 Nested normalization 54 55 sections in SMF records 13 19 New page skipping to in report 46 NEWOUT statement 9 11 Next page skipping to new page 46 Nibble testing value of 38 NOACCUM parm in COLUMNS statement 28 in FIELD statement 29 Non zero average value in control group printing 51 Non zero minimum value in control group printing 51 NORMALIZE parm in INPUT statement 13 17 multiple 19 NORMSMF parm in INPUT statement 13 15 multiple 19 NORMWHEN parm in INPUT statement 13 16 17 NOT in conditional expressions 57 Number sign meaning of 22 Nu
72. 7 25 09 06 25 06 68 07 25 09 06 41 26 16 07 25 09 05 57 39 62 2 626 00 00 00 05 08 0000 0000 00 00 00 00 11 0200 A2END 0000 00 00 00 02 09 0000 0000 05 00 03 01 0000 0000 02 00 01 06 0000 0000 00 00 00 00 0000 0000 0000 0000 02 0200 0622 o2 osse 0200 0622 00 00 00 00 0000 0000 00 00 00 02 0000 0000 01 00 00 42 0000 0000 73 00 43 46 0000 0000 GRAND TOTAL 13 ITEMS 405 Figure 7 Assigning values to computed fields based on conditions Spectrum SMF Writer Tutorial 37 Lesson 7 Conditional COMPUTE Statements But we might want to format that code in a more useful way There are several different types of non zero completion codes system abends user abends and regular non abend completion codes Each of these cases is usually formatted a little differently in for example a job s SYSLOG 50 4 for System ABEND codes S hex value U1000 for User ABEND codes U decimal value 0012 for non abend completion codes decimal value We can use a conditional COMPUTE statement along with some built in functions to format a new COMP CODE field in one of these standard ways To choose the format we will examine the abend bit in SMF30STI step termination indicator as well as the first nibble of the SMF30SCC field A first nibble value of X 8 signals a user abend as opposed to a system abend COMPUTE ABEND BIT SUBSTR 4FORMAT SMF
73. 9 00 0 00 00 00 00 00 TOTAL FOR MQM MVS ESA 1 ITEM 69 00 00 01 09 00 0 00 00 00 00 00 SYSZ9 11 00 00 00 12 00 00 00 2 05 31 090 00 08 38 10 00 318 00 00 05 18 00 SYSZ9 12 00 00 00 13 00 00 00 2 05 27 710 00 07 41 50 00 290 00 00 04 50 00 TOTAL FOR 2 05 2 ITEMS 58 800 00 16 20 00 00 608 00 00 10 08 00 SYSZ9 11 00 00 00 12 00 00 00 IMS ESA 13 565 00 03 46 05 00 0 00 00 00 00 00 TOTAL FOR IMS ESA 1 ITEM 13 565 00 03 46 05 00 0 00 00 00 00 00 Sco GRAND TOTAL 6 ITEMS 81 731 00 22 42 11 00 1 256 00 00 20 56 00 82 Spectrum SM F Writer Tutorial Appendix B Examples of SMF Reports Tape Library Statistics from SMF 94 IFCID 1 Records This reads as input the SMF file and selects just the type 94 subtype 1 tape library system records It selects the record for the hourly statistics for 11AM and prints various statistics for that hour These Control Statements OPTION STCKADJ 0 DON T CONVERT STCK TIMES TO GMT INPUT SMF94 TITLE HOURLY TAPE STATISTICS FROM SMF 94 RECORDS FOR 11 INC SMF94RTY 94 AND 5 945 1 AND SMF94HHI 11 COMPUTE SMF94ADVO 10 WHEN SMF9420F lt gt 0 ASSIGN SMF94ADVO5 SMF94ADV10 COMPUTE SMF94ADV10 20 WHEN SMF9420F lt gt 0 ASSIGN SMF94ADV15 SMF94ADV20 COMPUTE SMF94ADV20 30 WHEN SMF9420F lt gt 0 ASSIGN SMF94ADV25 SMF94ADV30 COMPUTE SMF94ADV30 40 WHEN SMF9420F lt gt 0 ASSIGN SMF94ADV35 SMF94AD
74. 9 06 09 15 99 30 07 25 09 06 09 18 17 30 07 25 09 06 11 23 89 30 07 25 09 06 11 26 16 30 07 25 09 06 25 49 35 30 07 25 09 06 41 26 16 30 BCA9514 5 500001 SMFEXTR SYSOU G99D0010 SORTMSG AROTRA23 SYSOU AROPRM23 STEPLIB AROCON23 SYSOU BBIPOST SYSPRINT BB06101 SYSHELP BCA9514 SYSHELP FTPD4 BCA9514 5 500001 02400715 STEPLIB BPXAS 10 800 O Q Q Q wom Oo e GRAND TOTAL 13 ITEMS 515291 Figure 3 SMF 30 report with data from only the first occurrence of various sections Reporting on Data from Occurrences of a Section Now let s look at the more complex case As noted the EXCP section can occur from 0 to n times in an SMF 30 record Specifically there is one EXCP section in the SMF 30 record for each DDNAME used by the job But the report in Figure 3 only shows the DDNAME EXCP count and maximum blocksize for a single DDNAME for each job Whichever DDNAME the SMF system happened to put in the first occurrence of the EXCP section To report on the DDNAME the EXCP count and the maximum block size for each DD in the job you must add an additional parm to your INPUT statement the NORMSMF parm INPUT SMF30 NORMSMF SMF30E0F NORMSME Parm Syntax Let s look at the syntax of the NORMSMF parm The NORMSMF parms simply names the first field of a standard SMF triplet the offset field The SMF30 record has a fiel
75. 9 30 85 10 64 26 71 0 1 010 0 0 Spectrum SMF Writer Tutorial 73 Appendix B Examples of SMF Reports Simple Chargeback Report from SMF 30 Records This report reads the SMF file and selects just the type 30 subtype 5 job termination records It prints a detail report one line per job that shows some ID information jobname accounting data along with the job s total CPU time and total count of EXCPs We also print a few more items that could potentially be involved in a chargeback formula elapsed times the SRB time component of the total CPU time etc For demo purposes we have multiplied the EXCP count and the CPU seconds by arbitrary per unit costs Now the chargeback costs can be shown directly in this SMF data extraction report One important task is choosing the info in the SMF 30 record that will assign each job to its appropriate cost center for charge back purposes Possibilities include the job card accounting field or part of the jobname itself For this demo report we used the first four bytes of the jobname as the cost center identifier We grouped the jobs according to this jobname prefix We sort and break on this job prefix to get total EXCP and CPU for each of these cost centers And also the total chargeback dollars for each cost center Once the report is fully developed and looks good at the individual job level we would simply uncomment the SUMMARY statement at the top to suppress all the
76. 9 35 07 25 08 06 25 06 68 42 67 0 0119 TOTAL FOR JES2 6 ITEMS 314 39 0 0874 OMVS 5 9514 STC07283 07 25 08 06 00 03 48 07 25 08 05 59 58 40 5 08 0 0014 OMVS FTPD4 STC07283 07 25 08 06 11 23 89 07 25 08 06 11 23 54 0 35 0 000 OMVS B5A9514 57 07283 07 25 08 06 11 26 16 07 25 08 06 11 23 89 2 27 0 0006 TOTAL FOR OMVS 3 ITEMS 7 70 0 002 STC SMFSLRD 57 07285 07 25 08 06 00 14 57 07 25 08 06 00 14 46 0 11 0 0000 STC B9AAQ 57 07283 07 25 08 06 41 26 16 07 25 08 05 57 39 62 2 626 54 0 7296 TOTAL FOR STC 2 ITEMS 2 626 65 0 7296 TSO 0016101 TSU07288 07 25 08 06 09 15 99 07 25 08 06 07 54 82 81 17 0 0225 TSO 5 9514 5107280 07 25 08 06 09 18 17 07 25 08 05 56 56 36 741 81 0 2061 AAS FOR Toe 2 ITEMS 822 98 0 2286 GRAND TOTAL 13 5 997775105712 Y50477 And this Report NUMBER OF TASKS BY TYPE WORK ELAPSED ELAPSED TYPE SMF30JBN SMF30JNM SMF30DTE SMF30TME SMF30STD SMF30SIT SECS HRS BATCH JOBS B5A9514 57 07283 07 25 08 06 00 03 48 07 25 08 05 59 58 40 5 08 0 0014 BATCH JOBS 04 57 07283 07 25 08 06 11 23 89 07 25 08 06 11 23 54 0 35 0 0001 BATCH JOBS B5A9514 57 07283 07 25 08 06 11 26 16 07 25 08 06 11 23 89 2 27 0 0006 BATCH JOBS 01 20715 00807291 07 25 08 06 25 49 35 07 25 08 06 25 06 68 42 67 0 0119 BATCH JOBS 05110010 00802576 07 25 08 06 01 33 76 07 25 08 06 01 31 67 2 09 0 0006 BATCH JOBS AMTTRA23 20807284 07 25 08 06 02 38 59 07 25 08 05 59 36 87 181 72 0 0505 BATCH
77. AS TAP JOBS 11 02 09 20 41 PDSETST1 IKJEFTO1 15 23330 TESTCA PDSE TEST 11 02 09 20 42 ZP144431 IKJEFTO1 SYSEXEC UAS REXX 11 02 09 20 42 7 144431 1 STEPLIB DIOINFO2 LOAD 11 02 09 5054 DUMPSMF SMFGDG 106 UAS SMF GDG LIST 11 02 09 20 52 DUMPSMF SMFGDG STEPLIB USER LINKLIB 11 02 09 20 52 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 11 02 09 2205838 PDSETST1 IKJEFTO1 15 23331 TESTCA PDSE TEST 11 02 09 20 53 PDSETST1 IKJEFTO1 SYS05621 TESTCA PDSE TEST 11 02 09 2 21 09 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 11 02 09 2 21 09 PDSETST1 IKJEFTO1 15 23332 TESTCA PDSE TEST 11 02 09 2 21 09 DBRC91T DFSMVRCO JCLPDS UAS TAPDSWA PROCLIBT 11 02 09 21 10 7 144452 IKJEFTO1 SYSEXEC UAS REXX 11 02 09 pb eine 7 144452 1 STEPLIB DIOINFO2 LOAD 11 02 09 7 122109 DFSUARCO DFSOLPOO 55 5 51 01 0 11 02 09 TB122109 DFSUARCO 5 IMS910T TAPO SDFSRESL 11 02 09 21 28 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 11 02 09 21 28 PDSETST1 IKJEFTO1 15 23333 TESTCA PDSE TEST 11 02 09 21 28 PDSETST1 IKJEFTO1 SYS05623 TESTCA PDSE TEST 11 02 09 2 21 40 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 11 02 09 21 41 PDSETST1 IKJEFTO1 15 23334 TESTCA PDSE TEST 11 02 09 21 42 7 144488 IKJEFTO1 SYSEXEC 11 02 09 21 42 7 144488 IKJEFTO1 STEPLIB DI10INFO2 LOAD 11 02 09 21 43 TPA1NOAQ DFSRRCOO PROCLIB UAS TAPDSWA4 PROCLIBT Additional lines not shown GRAND TOTA
78. BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME HEN BEG TIME 01 45 00 ASSIGN 01 30 02 00 00 ASSIGN 01 45 02 15 00 ASSIGN 02 00 02 30 00 ASSIGN 02 15 02 45 00 ASSIGN 02 30 03 00 00 ASSIGN 02 45 03 15 00 ASSIGN 03 00 03 30 00 ASSIGN 03 15 03 45 00 ASSIGN 03 30 04 00 00 ASSIGN 03 45 04 15 00 ASSIGN 04 00 04 30 00 ASSIGN 04 15 04 45 00 ASSIGN 04 30 05 00 00 ASSIGN 04 45 05 15 00 ASSIGN 05 00 05 30 00 ASSIGN 05 15 05 45 00 ASSIGN 05 30 06 00 00 ASSIGN 05 45 06 15 00 ASSIGN 05 00 06 30 00 ASSIGN 06 15 06 45 00 ASSIGN 06 30 07 00 00 ASSIGN 06 45 07 15 00 ASSIGN 06 00 07 30 00 ASSIGN 07 15 07 45 00 ASSIGN 07 30 08 00 00 ASSIGN 07 45 08 15 00 ASSIGN 08 00 08 30 00 ASSIGN 08 15 08 45 00 ASSIGN 08 30 09 00 00 ASSIGN 08 45 09 15 00 ASSIGN 09 00 09 30 00 ASSIGN 09 15 09 45 00 ASSIGN 09 30 0 00 00 ASSIGN 09 45 0 15 00 ASSIGN 0 30 00 ASSIGN 0 45 00 ASSIGN 1 00 00 ASSIGN 1 15 00 ASSIGN 1 30 00 ASSIGN 1 45 00 ASSIGN 2 00 00 ASSIGN 2 15 00 ASSIGN 2 30 00 ASSIGN 2 45 00 ASSIGN 3 00
79. Breaks Summary Here is a summary of what we learned in this lesson e use the SORT statement to sort your report e youcan sort on multiple sort fields youcan sort in either ascending or descending order e usethe BREAK statement to specify a control break field e control break fields must also be sort fields e usethe SPACE parm to specify your own spacing at the control break e youcan specify multiple control breaks in the same report The next lesson will show you how to print statistics at control breaks and how to write your own custom lines at the beginning and end of a control group To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn how to create a control break with the SORT statement page 177 e specify control break spacing with the SORT statement page 178 e request totals and statistics in the SORT statement page 186 e use additional control break spacing parms including one that skips to a new sheet of paper page 178 e compute percentages and ratios that apply to an entire control group page 202 e create multiple levels of summarization page 204 e the complete syntax for the SORT and BREAK statements is given in Chapter 10 Control Statement Syntax page 595 and page 481 50 Spectrum SMF Writer Tutorial Lesson 9 Customizing the Control Breaks This lesson introduces additional parms available t
80. CS START REPORT MONTH 1ST SESS ASSIGN MAKENUM SMF5DTE 86400 MAKENUM SMF5TME 3600 amp MAKENUM REPORT MONTH 86400 MAKENUM 00 00 00 3600 ELSE LAST SESSION IN MONTH ASSIGN MAKENUM REPORT MONTH E 86400 MAKENUM 23 59 59 3600 amp MAKENUM SMF5DTE 86400 MAKENUM SMF5TME 3600 COMPUTE PCT MONTH 6 ELAPSED HOURS 100 24 MAKENUM REPORT MONTH E MAKENUM REPORT MONTH 1 EEUU CICS UP TIME REPORT FOR MONTH REPORT MONTH THRU REPORT MONTH E COLUMNS SMF5JBN SMF5RSD SMF5RST SMF5DTE SMF5TME ELAPSED HOURS PCT MONTH PIC Z9 99 SORT SMF5JBN SMF5DTE SMF5TME BREAK SMF5JBN Produce this Report CICS UP TIME REPORT FOR MONTH 09 01 10 THRU 09 30 10 ELAPSED PCT SMF5JBN SMF5RSD SMF5RST SMF5DTE 5 5 HOURS MONTH CICSPX22 08 29 10 01 09 58 41 09 05 10 00 41 46 84 96 696344 12 97 CICSPX22 09 05 10 00 48 45 41 09 05 10 01 03 18 31 0 242472 0 03 CICSPX22 09 05 10 01 11 06 60 09 12 10 01 02 54 80 167 863389 22 56 CICSPX22 09 12 10 01 08 19 14 09 19 10 01 02 37 10 167 904989 22 57 CICSPX22 09 19 10 01 28 26 17 09 25 10 02 11 13 49 144 713145 9 45 CICSPX22 09 25 10 03 15 43 81 09 26 10 01 02 19 81 21 776667 2 93 CICSPX22 09 26 10 01 07 17 08 10 03 10 01 02 59 65 118 878311 15 98 TOTAL FOR CICSPX22 7 ITEMS 718 075317 96 52 CICSPX23 08 29 10 01 09 56 36 09 05 10 00 41 58 09 96 6994
81. CSQ1 DQMIPV6 CSQ1 REPLYQ 6 20 30 77 16 20 31 22 00 00 00 010303 00 00 00 000000 12 20 31 25 U0240058 DQMIPV6 CSQ2 DQMIPV6 CSQ1 XMITQ 6 20 29 52 16 20 30 62 00 00 00 000000 00 00 00 000000 12 20 31 27 00240073 DQMIPV6 CSQ1 REPLYQ DQMIPV6 CSQ1 REPLYQ 6 20 31 06 16 20 31 27 00 00 00 004597 00 00 00 000000 12 20 31 27 00240073 DQMIPV6 CSQ2 TPN QUE DQMIPV6 CSQ1 XMITQ 6 20 29 73 16 20 30 76 00 00 00 000000 00 00 00 000000 12 20 31 39 U0240027 DQMIPV6 CSQ1 REPLYQ DQMIPV6 CSQ1 REPLYQ 6 20 30 84 16 20 31 28 00 00 00 008269 00 00 00 000000 12 20 31 39 00240027 DQMIPV6 CSQ2 TPN QUE DQMIPV6 CSQ1 XMITQ 6 20 29 40 16 20 30 64 00 00 00 000000 00 00 00 000000 12 20 31 42 CICS3A1A CICS BRIDGE REPLY Z3 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 31 40 16 20 31 40 00 00 00 000000 00 00 00 000285 12 20 31 42 CICS3A1A CICS CICS BRIDGE QUEUE 6 20 31 14 16 20 31 41 00 00 00 000098 00 00 00 000000 12 20 31 53 CICS3A1A CICS Y Z3 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 31 53 16 20 31 53 00 00 00 000000 00 00 00 000336 12 20 31 53 CICS3A1A CICS E CICS BRIDGE QUEUE 6 20 31 51 16 20 31 54 00 00 00 000145 00 00 00 000000 12 20 31 72 CICS3A1A CICS Y Z3 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 31 72 16 20 31 72 00 00 00 000000 00 00 00 000455 12 20 31 72 CICS3A1A CICS BRIDGE QUEUE CICS BRIDGE QUEUE 6 20 31 70 16 20 31 72 00 00 00 000087 00 00 00 000000 12 20 31 72 10240039 DQMIPV6 CSQ1 REPLYQ DQMIPV6 CSQ1 REPLYQ 6 20 31 56 16 20 31 66 00 00 00 002926 00 00 00 000000
82. D TYP ID LOG DATE LOG TIME NAME NAME ID DBID NAME PSID OBID NAME 102 144 04 11 10 18 37 40 13 TSO ADB TTP011A 291 FLOATACC1 2 3 102 144 04 11 10 18 37 54 06 50 ADB 11 291 FLOATACC1 2 3 102 144 04 11 10 18 38 09 56 50 ADB 11 291 FLOATACC1 2 3 FLOATAAC1 102 144 04 11 10 18 38 19 11 50 ADB 11 292 FLOATTEMP 2 3 FLOATTEMP 102 144 04 11 10 18 38 31 80 TSO ADB 11 292 FLOATTEMP 2 3 FLOATTEMP 102 144 04 11 10 18 48 35 58 DB2CALL SPECT303 011 292 FLOATTEMP 2 3 FLOATTEMP 102 144 04 11 10 18 49 29 27 DB2CALL 011 291 FLOATACC1 2 3 Spectrum SMF Writer Tutorial 87 Appendix B Examples of SMF Reports CICS Performance Report from SMF 110 Records This example reads as input the SMF file and selects just the type 110 subtype 1 CICS Monitoring records with data class 3 performance We normalize those 110 records in order to process each performance segment present on each record We print some identifying information from each segment Most users would also add a column for one or more of the performance measures present on the record We sorted the records by transaction printing two blank lines at the breaks These Control Statements INPUT INCLUDE COLUMNS WU LES WES ip pis SORT SM SMF110S1 NORMWHEN SMF110RTY 110 amp SMF110STY 1 amp SMF110S1_MNCL 3 NORMSMF SMF1
83. D BLOCK EXCP BLOCK TIME DATE TIME TIME SECONDS HOURS COUNT CHARGE SIZE 06 00 UL 09 06 00 s 8 06 00 UL 09 06 00 0 06 02 UL 09 06 02 5 2 06 00 UL 09 06 03 201 18 1 06 06 UL 09 06 07 06 66 5 0 82 6 447 06 07 UL 09 06 07 0 06 09 UL 09 06 09 21 06 08 UL 09 06 09 0546 UL 09 06 09 06 11 UL 09 06 11 b 06 UL 09 06 4 5 0 04 27 900 06 25 UL 09 06 26 3 5 0 06 6 144 05 58 UL 09 06 41 1 10 800 TOTAL EMS 025875 5 0 92 Figure 5 Customizing a report by using display formats column headings override widths and more Spectrum SMF Writer Tutorial 27 Lesson 5 Improving the Appearance of your Report Specifying a Column s Width You can also specify the exact number of bytes to use for a particular column in your report When no column width is specified Spectrum SMF Writer chooses a default column width You may want a larger column width to hold big numeric values for example Or you may want a smaller column width perhaps to truncate a long character field so that you can squeeze more columns into your report Just specify the number of bytes you want for a particular column in parentheses after the field name For example COLUMNS SMF14 JFCBDSN 20 The above statement tells Spectrum SMF Writer to shorten the long 44 byte DSN field to just the first 20 bytes to save space in the report The Blank If Zero Parm Many SMF reports are written to
84. E SHOWFL WHERE TABLE DB INCLUDEIF SM102RTY AND QWHCOP SELECT THE DATA F COLUMNS QWHSIID 4 I SM102DTE SM SM102TME SM QWHCOPID OP QWO144DB 4 SPACE NAME 16 D QWO144PS 4 PSID QW01440B 4 OBID TABLE NAME 16 70 TERTII ES TITLE ACCESS TO TAB 86 Spectrum SMF Writer Tutorial LOOK UP TABLE NAME OPTION DB2SUBSYS DB2T NOGRANDTOTALS LE IS THE SMF FILE WE NORMALIZE TO GET ALL SEGMENTS LIST YES RM A 102 036 21 028 004 2 00144 E IN IBM SYSTEM DB2 TABLE DS YES DB2NAME SYSIBM SYSTABLESPACE QW0144DB AND PSID QUO144PS IN IBM SYSTEM DB2 TABLE AND QWHSIID AND 5 1020 4 11 10 AND 5 102 gt 18 00 00 AND 19 00 00 AND SPACE NAME DBID DS YES DB2NAME SYSIBM SYSTABLES D QWO144DB AND TABLE OBID QWO1440B SELECT THE RECORDS WE WANT FOR THE REPORT 102 144 FLOAT 11 ID IELDS TO PRINT IN THE REPORT 102 3 SMF REC TYP FC ID F LOG DATE F LOG TIME QWHCCN CONNECT QWHCPLAN PLAN NAME ERATOR ID BID NAME D SPECIFY REPORT TITLES DB2 AUDIT REPORT FROM SMF 102 RECORDS LES BEGINNING WITH FLOAT Appendix B Examples of SMF Reports Produce this Report DB2 AUDIT REPORT FROM SMF 102 RECORDS ACCESS TO TABLES BEGINNING WITH FLOAT SMF REC IFC SMF SMF CONNECT PLAN OPERATOR DBID OBI
85. EPLYQ 6 20 28 67 16 20 30 12 00 00 00 000241 00 00 00 000000 12 20 30 34 1 CICS BRIDGE REPLY Z3 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 30 34 16 20 30 34 00 00 00 000000 00 00 00 000346 12 20 30 34 CICS3A1A CICS BRIDGE Q CICS BRIDGE QUEUE 6 20 30 26 16 20 30 35 00 00 00 000103 00 00 00 000000 12 20 30 50 00200015 MQGT OTMA QUE OTMA QUEUE 6 20 29 93 16 20 30 44 00 00 00 000000 00 00 00 000000 12 20 30 52 CICS3A1A CICS BRIDGE R SYSTEM CLUSTER TRANSMIT QUEUE 6 20 30 52 16 20 30 52 00 00 00 000000 00 00 00 000410 12 20 30 52 CICS3A1A CICS BRIDGE Q CICS BRIDGE QUEUE 6 20 30 46 16 20 30 53 00 00 00 000141 00 00 00 000000 12 20 30 61 CICS3A1A CICS BRIDGE R SYSTEM CLUSTER TRANSMIT QUEUE 6 20 30 61 16 20 30 61 00 00 00 000000 00 00 00 000373 12 20 30 61 CICS3A1A CICS BRIDGE Q CICS BRIDGE QUEUE 6 20 30 39 16 20 30 62 00 00 00 000091 00 00 00 000000 12 20 30 81 U0200068 MQGT OTMA QUEUE MQGT OTMA QUEUE 6 20 30 40 16 20 30 81 00 00 00 000000 00 00 00 000000 12 20 30 87 CICS3A1A CICS BRIDGE REPLY Z3 SYSTEM CLUSTER TRANSMIT QUEUE 6 20 30 86 16 20 30 86 00 00 00 000000 00 00 00 000362 12 20 30 87 CICS3A1A CICS BRIDGE Q E CICS BRIDGE QUEUE 6 20 30 72 16 20 30 87 00 00 00 000130 00 00 00 000000 12 20 31 19 CICS3A1A CICS BRIDGE R Yes SYSTEM CLUSTER TRANSMIT QUEUE 6 20 31 20 16 20 31 20 00 00 00 000000 00 00 00 000406 12 20 31 19 CICS3A1A CICS BRIDGE Q E CICS BRIDGE QUEUE 6 20 31 18 16 20 31 20 00 00 00 000090 00 00 00 000000 12 20 31 25 U0240058 DQMIPV6
86. EXEC TSP SISPEXEC 0 09 8 06 80 27 920 TIMPCO BT910152 08 02 07 2 01 52 DFSULLS1 DFUTLPO2 IMSSYST IMS1 0LP 9 001 02 4 07 24 572 24 576 191024 5 5 5 5 910152 08 02 07 2 01 52 DFSULLS1 STEPLIB IMS910T ZRSO SDF 73 04 27 05 0 32 760 V91013 PRIOR TESTBASE BT910648 08 02 07 2 06 48 A DFSULLS1 DFUTLPO3 55 5 51 01 9 001 02 4 07 24 572 24 576 91116 ESTBASE TESTBASE BT910648 08 02 07 2 06 48 A DFSULLS1 STEPLIB MS910T ZRSO SDF 75 04 27 05 0 32 760 V91013 PRIOR TESTBASE BT911150 08 02 07 Zee OMA DFSULLS1 DFUTLPO4 55 5 51 01 9 001 02 4 07 24 572 24 576 V91053 ESTBASE TESTBASE BT911150 08 02 07 Zeeks SOMATA DFSULLS1 STEPLIB MS910T ZRSO SDF F3 04 27 05 0 32 760 V91013 PRIOR 5 5 911352 08 02 07 EIE DFSULLS1 DFUTLPO1 IMSSYST IMS4 0LP 12 001 02 4 07 22 524 22 528 191095 ESTBASE TESTBASE BT911352 08 02 07 ATI DFSULLS1 STEPLIB MS910T ZRSO SDF 7 2 04 27 05 0 32 760 V91013 PRIOR 5 5 912758 08 02 07 2 27 58 DFSULLS1 STEPLIB MS910T ZRSO SDF 73 04 27 05 0 32 760 V91013 PRIOR TESTBASE BT912758 08 02 07 ZA a DFSULLS1 DFUTLPO2 IMSSYST IMS1 0LP 9 001 02 4 07 24 572 24 576 191024 5 5 5 5 CSQ1BING 08 01 07 9 04 10 CSQ1BING CSQXJST SYS00180 TCPIP ETC SERVIC 7 02 05 97 80 3 120 C23SP3 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 320 10 23 02 80 85900 DB29AT 08 01 07 9 09 46 DB29AT DFSMVRCO JCLPDS D10 TIMDSW4 PROC 316 10 23 02 80 3
87. F70WST PCT PCT WAIT SMF7OEDT EFFECT DISPATCH TIME SMF7OEDT PCT PCT EFF DISP HL SMF70PDT PROC DISP TIME SMF70PDT_PCT PCT PROC DISP Figure 14 This report features nested normalization and customized break headings 54 Spectrum SMF Writer Tutorial Lesson 9 Customizing the Control Breaks Produce this Report PHYSICAL CPU S N 04299E LPARS ONLINE TIME PERCENTAGE REPORT RUN DATE 03 02 10 FAMILY amp MODEL 2094 742 BY LOGICAL PROCESSOR PAGE 1 CAPACITY 387 MSU S 15 00 MINUTE INTERVAL ENDING 11 02 07 AT 12 00 LOG ACTUAL EFFECT PCT PROC PCT PROC WEIGHT RMF ONLINE PCT WAIT PCT DISPATCH EFF DISP PROC ADDR FACTOR INTERVAL TIME ONLINE TIME WAIT TIME DISP TIME DISP SYSTEM SYSTEM NAME JFO PARTITION NUM 1 PARTITION NAME JFO LPAR CLUSTER UTCPLXJ8 LPAR DEFINED CAPACITY LIMIT 0 MSU S STORAGE 15 360 MB LOGICAL PROCESSOR INFO 20 PROCESSORS oe ae se se de de de ge ge 99 de de de ge 3e ae ae ae de ae oe ae 3e oe ae de ae ae 3e S Q Q Q P P to gt de de se de 3e ge se Je ge se se de ge se 90 se se 90 59 S S gt Go P Q GR gt ONO de de de de de de de de de de de de de de de de de de 90 50 C O O1 Q O1 de ae O FW oe ae
88. HS AND HEADINGS kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk COLUMNS SMF30JBN JOBNAME JOB_PREFIX ACCT JOB CARD ACCOUNT SMF30TEX TOTAL EXCPS 11 FAKE IO RATE I O RATE FAKE 6 NOACCUM FAKE IO CHG I O CHARGE FAKE 11 DOLLAR SMF3OCPT SECS CPU TIME SECS 8 FAKE CPU RATE CPU RATE FAKE 6 NOACCUM FAKE CPU CHG CPU CHARGE FAKE 11 DOLLAR RB CPU SRB TIME SECS 6 SYS ELAPSED TIME IN SYSTEM ACCUM EX ELAPSED EXECUTION TIME ACCUM mmc KKK ee ek ee KKK e ke kk e ke koe KKK ee KK ee KKK ek ee eee eee eee SPECIFY REPORT TITLE KKK KKK ek KK KKK e ke KKK KKK KKK ee ek KEK KKK KK eee TITLE CHARGE BACK RELATED JOB INFO FROM SMF 30 5 RECS TITLE FOR SMF30DTE KKK ee ek ee KKK KK RK KK KK KKK ee KK KK KKK KKK KKK KK SORT AND BREAK ON JOB PREFIX WITH SUBTOTALS ACCT IS ANOTHER CHOICE FOR HERE pi III SORT JOB PREFIX BREAK JOB PREFIX TOTALS TOTALS JOB PREFIX Produce this Report CHARGE BACK RELATED JOB INFO FROM SMF 30 5 RECS FOR 11 30 06 JOB 1 0 1 0 CPU CPU CPU SRB ELAPSED ELAPSED JOB CARD TOTAL RATE CHARGE TIME RATE CHARGE TIME TIME IN EXECUTION JOBNAME PREFIX ACCOUNT EXCPS FAKE FAKE SECS FAKE FAKE SECS SYSTEM TIME AT122309 AT12 7 644 0 0 76 44 0 31 5 25 1 63 0 2
89. IN USER PROCLIB 80 5 2 11 02 09 12 20 21 47 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS E 80 2 11 02 09 12 ATES TCA POSE TEST 80 4 11 02 09 12 20 21 87 ZP144405 IKJEFTO1 UAS REXX 8 55 2 additional lines not shown Which Results in this Excel Spreadsheet m Insert Page Layout Formulas Data Review View Calibri rmt is P Z g imet E 3a a 9 Delete gj mte B z Uu E 5 A Condition Format cH fs 2 Clipboard Font fa Alignment fa Number Styles Cells Al gt f D E F G H SMF14 SMF14 2 SMF14DTE 1 SMF14JBN SMF14PGN SMF14TIOES JFCBDSNM JFCLRECL SMF14EXCP 3 4 11 2 2009 20 15 4 DUMPSMF IFASMFDP SYSIN USER PROCLIB 80 2 5 11 2 2009 20 21 5 5 5 1 IKJEFTOL PDSESKEL UAS TAP JOBS 80 2 6 11 2 2009 20 21 8 PDSETST1 IKJEFTOL 15 23328 TESTCA PDSE TEST 80 4 11 2 2009 20 21 9 2 144405 IKJEFTO1 SYSEXEC UAS REXX 255 2 8 11 2 2009 20 22 0 ZP144405 IKJEFTOL STEPLIB D10INFO2 LOAD 0 2 9 11 2 2009 20 31 1 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 80 2 10 11 2 2009 20 31 3 PDSETST1 IKJEFTO1 15 23329 TESTCA PDSE TEST 80 4 11 11 2 2009 20 31 5 PDSETST1 IKJEFT01 SYS05619 TESTCA PDSE TEST 80 4 12 11 2 2009 20 41 6 PDSETST1 IKJEFT01 PDSESKEL UAS TAP JOBS 80 2 13 11 2 2009
90. IOE5 5 14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP The three statements above produce a complete report with Spectrum SMF Writer See Figure 1 on page 4 The Rest of the Process Once you ve written the necessary control statements you just submit a batch job to execute Spectrum SMF Writer The program examines the control statements describing the report you want It automatically reads the appropriate SMF record definition statements from the copy library Those statements define the SMF record layout needed for your report Then Spectrum SMF Writer reads the actual SMF file and produces your report for you This process is illustrated in the figure on the next page to p Note This tutorial contains some references to chapters and pages outside of the tutorial itself Those references are ages in the Spectrum Writer User s Guide and Reference Manual available on our website Spectrum SMF Writer Tutorial 1 Introduction Control Statements INPUT SM INCLUDEIF 5 14 COLUMNS SMF14DTE SMFI4TME SMF14JBN File Definition Statements FILE SMF14 LRECL 32767 DDNAME SMFIN FIELD SMFIALEN 015 0 LEN 2 TYPE BU FIELD SMF14SEG DISP 2 LEN 2 TYPE BU FIELD SMF14FLG DISP 4 LEN 1 TYPE BU FIELD SMFIARTY DISP 5 LEN 1 TYPE BU SMF File Custom Reports 1 UND 2 Spectrum SMF Writer Tutorial Lesson 1 How to Make SMF Report in 5 Minutes This lesson teach
91. ISP 11 02 09 12 23 48 47 15 IITADMI SPFTEMP2 CNT 11 02 09 12 23 57 47 15 IITADMI SPFTEMP1 CNT 11 02 09 12 23 57 65 17 IITADM1 SPFTEMP1 CNT DELETE GRAND TOTAL 3 ITEMS Figure 8 A report showing data from SMF 15 and SMF 17 records Since we will be working with fields from two different SMF types we will need the field definitions for both of them The following statements handle that for us INPUT SMF15 GET TYPE 15 FILE AND FIELD DEFINITIONS COPY REC17 GET TYPE 17 FIELD DEFINITIONS ONLY Spectrum SMF Writer Tutorial 39 Lesson 7 Conditional COMPUTE Statements Summary The INPUT statement above does two things It reads in the file and field definitions for the type 15 records from the copy library And it names that file as the input for the report Since we cannot have multiple INPUT statements in a run we use a COPY statement to copy in the additional field definitions for the type 17 records We copied member REC 17 rather than SMF17 because we want to add all of the type 17 SMF fields to the existing SMF 15 file definition Copying SMF17 would have defined a new second file containing the SMF 17 fields That is not what we want Our INCLUDEIF statement should now include both type 15 and type 17 records in the report Since the SMF record type field is located in the same position for SMF records in the fixed SMF header it is safe for us to test the SMF15RTY field in all records INCLUDEIF
92. JOBS AMTPRM23 00807286 07 25 08 06 06 49 94 07 25 08 06 05 43 66 66 28 0 0184 BATCH JOBS AMTCON23 20807287 07 25 08 06 07 21 59 07 25 08 06 07 21 16 0 43 0 0001 BATCH JOBS BAIPORT J0B07289 07 25 08 06 09 06 37 07 25 08 06 08 45 17 21 20 0 0059 TOTAL FOR BATCH JOBS 9 5 322 09 0 0895 STARTED TASKS B9AAQ STC07283 07 25 08 06 41 26 16 07 25 08 05 57 39 62 2 626 54 0 7296 STARTED TASKS SMFSLRD 57 07285 07 25 08 06 00 14 57 07 25 08 06 00 14 46 0 11 0 0000 TOTAL FOR STARTED TASKS 2 ITEMS 2 626 65 0 7296 TSO SESSIONS 0016101 5 07288 07 25 08 06 09 15 99 07 25 08 06 07 54 82 81517 0 0225 TSO SESSIONS 5 9514 TSU07280 07 25 08 06 09 18 17 07 25 08 05 56 56 36 741 81 0 2061 TOTAL FOR TSO SESSIONS 2 ITEMS 822 98 0 2286 GRAND TOTAL 13 ITEMS Oph bale 0477 Spectrum 5 Writer Tutorial 65 Appendix B Examples of SMF Reports And this Report NUMBER OF TASKS BY TYPE SUMMARY REPORT WORK ELAPSED ELAPSED TYPE SMF30JBN SMF30JNM SMF30DTE SMF30TME SMF30STD SMF30SIT SECS HRS TOTAL FOR BATCH JOBS 9 ITEMS 322 09 0 0895 TOTAL FOR STARTED TASKS 2 ITEMS 2 626 65 0 7296 TOTAL FOR TSO SESSIONS 2 ITEMS 822 98 0 2286 GRAND TOTAL 13 ITEMS 150477 66 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports Normalizing the EXCP Sections in an SMF Type 30 Record This example shows how to split each physical type 30 SMF record into multiple
93. Just because Spectrum SMF Wiriter can produce new reports quickly doesn t mean that the report has to look quick and dirty at all This lesson lets you give your report that professional look as if it were made with a custom report program Using Display Formats When it comes time for Spectrum SMF Writer to move raw data from the SMF record into the report line it must decide exactly how to format the data The format used is called the display format Spectrum SMF Wiriter supports quite a number of different display formats depending on the data type of the field The following table contains a partial list of the more commonly used display formats A complete list can be found in Appendix B Display Formats page 617 E Description Example oer m te default format for dates MM DD YYYY 12 31 2010 DD MM YYYY 31 12 2010 Date SHORT1 DEC 31 2010 SHORT2 31 DEC 2010 SHORT3 31 DEC 10 LONG1 DECEMBER 31 2010 LONG2 31 DECEMBER 2010 HEME SS ae MT format for times Time HH MM 14 00 time rounded to minutes HH MM AMPM 2 00 PM 12 hour time with AM or PM Spectrum SMF Writer Tutorial 25 Lesson 5 Improving the Appearance of your Report Type of Display TNT Data Format Description Example DOTSEP 1 234 567 98 dots for thousands separator comma for decimal digits DISPLAY 0123M no leading zero suppression no Numeric commas sign in zone
94. KJ DBT4 09 23 08 10 41 33 77 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 39 88 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 Spectrum SMF Writer Tutorial 85 Appendix B Examples of SMF Reports DB2 Access Audit Report from S In this report the primary We select the records for the timeframe and the tables we are interested in Alternately we could have selected on Operator ID to see all tables accessed by a given user This example also illustrates the use of Spectrum SMF Writer s available DB2 Option The SMF record itself does not contain the text name of the tables being accessed It just contains halfword codes for Database ID Page Space ID and Object ID However we were able to use those codes to select rows from two DB2 system tables and expand those we were able to show the actual table names in our report codes into full names Thus MF 102 Records input file is the SMF file We select just the type 102 DB2 Audit records with IFCID 144 ATTEMPTED ACCESS READ OF AN AUDITED OBJECT We normalize the 144 data section in order to report on all occurances of that segment within each SMF record The normalization is performed by a built in I O exit These Control Statements THE MAIN INPUT FI INPUT SMF102V9 IOEXIT GENNO LOOK UP SPACE NAM READ SPACE SHOWFL WHERE 0810 READ TABL
95. L 838 ITEMS 291 114 133 702 Remarks this report was produced from just three statements the INPUT INCLUDEIF and COLUMNS statements the data used in this report comes from the SMF14 records the eight columns of data in the report correspond to the field names in the COLUMNS statement the default column headings used are the field names themselves broken apart at each underscore the report has a default title which includes the name of the input file the report has a Grand Total line showing totals for the two numeric columns Later we will see how to suppress the total for a particular column when it is meaningless as it is for the LRECL column here the number of records listed in the report is shown Figure 1 A report produced with just three control statements 4 Spectrum SMF Writer Tutorial Lesson 1 How to Make SMF Report in 5 Minutes How to Use the INCLUDEIF Statement Let us revise something that we just told you The truth is that you can make a Spectrum SMF Writer report with just two control statements the INPUT and COLUMNS statements When no INCLUDEIF statement is given Spectrum SMF Writer includes every record from the input file in your report But since the SMF file contains dozens of different record types each containing different kinds of data it is not very useful to include all records in a single report So it is safe to say that most of your reports will use an INCLUDEIF statement to limit the rec
96. LIT This option indicates that all date literals in the control statements will be in DD MM YY or DD MM YYYY format Comparing Dates One very powerful feature of Spectrum SMF Writer often takes some getting used to by programmers If they have used other report writers programmers are used to matching the format of their date literal with the format of the raw data in the record being tested For example if a record contains packed Julian dates programmers usually have to look up the desired date in Julian and then write their comparison literal in the same packed Julian date format With Spectrum SMF Writer this is not necessary The program automatically handles all required date conversions for you So whether a raw field is stored in the record as a packed Julian date a character YYYYMMDD or MMDDYY date an 8 byte STCK date or a binary day in century to name a few of the formats you always write your comparison dates in MM DD YY YY format As an example even though the SMF14DTE field is stored in the SMF record in packed P CYYDDD format you just test it like this INCLUDEIF SMF14RTY 14 AND SMF14DTE gt 6 30 2010 AND lt 7 13 2010 The only exception would be if a field has accidentally been defined in the copy library as a plain character or numeric field rather than a true date field In that case you do need to compare it with a character or numeric literal of the same format In that case you may also want to c
97. MAL TERM OR FLUSHED x NNNN USER COMPLETION CODE FEI COMPUTE COMPUTE COMPUTE CC NIB2 COMPUTE COMP CODE WHEN SMF30SCC 0 ASSIGN WHEN CC NIB2 lt gt 0 AND CC NIBI 0 WHEN CC NIB2 lt gt 0 AND CC NIBI 8 KKK RK KKK KKK KK k kk k k KK KK KKK KK KKK KK KK KKK KK RE KK RRR KEK SPECIFY REPORT TITLE KK KKK KK KKK KKK KKK KKK KKK KK KKK KEK e ke KK KK KERR KK KERR KERR KEK TITLE STEP COMPLETION CODES FROM SMF 30 RECORDS KK KKK KK KKK KKK KKK KKK KKK KR KKK KEK e ke KEK KK KKK K k ee ek SPECIFY WHICH SMF FIELDS TO SHOW IB RPT COLUMNS WE ALSO OVERIDE SOME COLUMN WIDTHS AND HEADINGS EK KER COLUMNS SMF30DTE SMF30TME HH MM SMF3ORTY 4 SMF SMF30STP 4 SMF SUB TYPE SMF30JBN JOBNAME SMF30STN STEP NUM 4 SMF30STM STEPNAME SMF30SCC HEX HEX COMP CODE COMP CODE FORMATTED COMP CODE 68 Spectrum SMF Writer Tutorial FORMAT SMF30SCC HEX GET 4 CHAR SUBSTR CC HEX 1 1 GET 1 BYTE 1ST NIBBLE SUBSTR CC HEX 2 1 GET 1 BYTE 2ND NIBBLE ASSIGN SNNN UNNN 7779 OR BLANKS ASSIGN S SUBSTR CC HEX 2 3 ASSIGN U SUBSTR CC HEX 2 3 ELSE ASSIGN FORMAT SMF30SCC P ZZZ9 SUBTYPE 4 Appendix B E
98. MF 15 fields or from SMF 17 fields Here is a summary of what we learned in this lesson e aconditional COMPUTE statement uses one of multiple different computational expressions depending on the conditions that you specify you may have any number of WHEN ASSIGN pairs e optionally you may have a final ELSE ASSIGN pair as well you can use a conditional COMPUTE statement to construct report lines using data from 2 different types of SMF records 40 Spectrum SMF Writer Tutorial To Learn More Lesson 7 Conditional COMPUTE Statements The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn how to create date fields page 514 many powerful date manipulation functions listed in Appendix D Built In Functions page 628 how to create bit boolean fields page 514 how to specify the number of decimal places a numeric or time field should contain page 511 how to retain the previous value of a COMPUTE field in certain cases page 234 the complete syntax for the COMPUTE statement in Chapter 10 Control Statement Syntax page 506 Spectrum SMF Writer Tutorial 41 Lesson 8 How to Specify the Sort Order and Control Breaks This lesson teaches you how to sort your report into the order you want It also explains how to add control breaks to your report And it shows how to use control breaks to create summary reports The control stat
99. MF record header e job name from the Identification section which occurs exactly once e number of card image records read from the I O Activity section which occurs no more than once e step completion code from the Completion Section which occurs no more than once DDNAME EXCP block count and largest block size all taken from the EXCP section which can occur any number of times The report in Figure 3 shows the contents of those fields taken from the first occurrence of each section even though that first section may be located at different offsets in different records Note if you refer to a field in a section that does not exist in a record it is treated as missing Missing fields yield blanks or zeros depending on the data type 14 Spectrum SMF Writer Tutorial Lesson 3 How to Report on Multiple Occurrences of Section These Control Statements INPUT SMF30 COPY SMF 30 RECORD DEF INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT TYPE 30 SUBTYPE 5 COLUMNS SMF30DTE SMF30TME SMF3ORTY SMF30STP SMF30JBN SMF30INP SMF30SCC HEX SMF30DDN SMF30BLK SMF30BSZ Produce this Report FRI 03 05 10 11 39 AM DATA FROM SMF30 PAGE SMF30DTE SMF30TME SMF3ORTY SMF30STP SMF30JBN SMF30INP SMF30SCC SMF30DDN SMF30BLK SMF30BSZ 07 25 09 06 00 03 48 30 07 25 09 06 00 14 57 30 07 25 09 06 01 33 76 30 07 25 09 06 02 38 59 30 07 25 09 06 06 49 94 30 07 25 09 06 07 21 59 30 07 25 09 06 09 06 37 30 07 25 0
100. MS 05 23 08 19 59 40 05 SQK102 7308 0009000 0009000E 1 3 CICSDNMS 05 23 08 19 59 40 05 SQK102 7308 04800000 04 000 1 2 0 6 3 CICSDNMS 05 23 08 19 59 40 05 SQK102 7308 00090009 00090008 1 0 8 amp 3 CICSDNMS 05 23 08 19 59 40 05 SQK102 7308 02040000 030B000E 1 2 00004 3 CICSDNMS 05 23 08 19 59 40 05 SQK102 7308 04 0000 0520000E 1 2 0 4 9 3 CICSDNMS 05 23 08 19 59 40 05 SQK102 7308 0009000 0009000E 1 8 3 CICSDNMS 05 23 08 19 59 40 05 SQK102 7308 00090006 00090008 1 0 0 3 TOTAL FOR CICSDNMS 05 23 08 19 59 40 05 8 ITEMS 8 12 0 89 24 DLISET82 05 23 08 22 13 47 86 0 4003 5003 26 50000 26 000 15 1 115 761 25 946 1 273 0 303 715 DLISET82 05 23 08 22 13 47 86 DB4DSP 5 06 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 04 0000 0520000E 4 142 235 4 ERPTRKIL 07 24 06 11 49 50 74 SQK102 7308 0009000 0009000 4 226 234 ERPTRKIL 07 24 06 11 49 50 74 50 051 640A 02190000 027C000E 0 0 0 4 0 ERPTRKIL 07 24 06 11 49 50 74 SQK051 640A 00090000 00090005 0 0 o 0 ERPTRKIL 07 24 06 11 49 50 74 SQK102 7308 04 0000 0520000 4 142 235 0 8 3 ERPTRKIL 07 24 06 11 49 50 74 SQK102 7308 0009000 0009000E 4 226 0 0 3 ERPTRKIL 07 24 06 11 49 50 74 SQK102 7308 04 0000 0520000 4 142 235 0 86 4 ERPTRKIL 07 24 06 11 49 50 74 SQK102 7308 0009000 0009000E 4 226 o
101. O14 07 24 09 12 00 44 10 FOR USTTAO35 07 24 09 11 33 30 45 FOR USTTA035 07 24 09 11 58 53 FOR USTTCO1 07 24 09 09 28 53 FOR USTTCO11 07 24 09 11 35 08 FOR USTTCO11 07 24 09 11 35 27 FOR USTTCO11 07 24 09 11 35 48 FOR USTTCO11 07 24 09 11 36 08 FOR USTTCO12 07 24 09 11 35 FOR USTTCO12 07 24 09 11 35 FOR USTTCO12 07 24 09 11 35 FOR USTTCO12 07 24 09 FOR USTTCO13 07 24 09 FOR USTTCO13 07 24 09 U U U U U U U U U U U U EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS EMS n FOR C013 07 24 09 FOR C014 07 24 09 FOR C014 07 24 09 FOR C014 07 24 09 FOR C015 07 24 09 FOR C015 07 24 09 FOR C015 07 24 09 FOR C015 07 24 09 FOR C016 07 24 09 FOR C016 07 24 09 FOR C016 07 24 09 FOR C016 07 24 09 A gt gt OO C0 0090 009 000x000 uU SPrrrrrrrrrrrrrrrrrrrrrrrrrrre NNN NNN NNN MEME MEME MEME MEME OS CA CO C C CO C CO a Q Oi QC O TO PO S 2 PP Oo no tO m c o additional lines not shown Figure 11 Using the SUMMARY option to make a summary report Spectrum SMF Writer Tutorial 47 Lesson 8 How to Specify the Sort Order and
102. P 07 24 09 11 31 06 67 07 24 09 11 31 06 76 RECP SYS00001 SYS1 TCPPARMS SYSUP 07 24 09 11 31 06 67 07 24 09 11 31 06 78 RECP SYSO0004 TCPIP STANDARD TCPXLPAM TOTAL FOR 07 24 09 11 31 06 67 ITEMS TOTAL FOR SYSUP 6 ITEMS USTTAO14 07 24 09 12 00 44 10 07 24 09 12 00 44 20 BPXPRFC SYS00001 SYS1 TCPPARMS USTTAO14 07 24 09 12 00 44 10 07 24 09 12 00 44 25 BPXPRFC SYS00004 TCPIP STANDARD TCPXLPAM USTTAO14 07 24 09 12 00 44 10 07 24 09 12 00 44 30 BPXPRFC SYS00006 TCPIP ETC SERVICES TOTAL FOR 07 24 09 12 00 44 10 3 ITEMS TOTAL FOR USTTAO14 3 ITEMS USTTAO35 07 24 09 11 33 30 45 07 24 09 11 33 30 62 BPXPRFC SYS00001 SYS1 TCPPARMS USTTAO35 07 24 09 11 33 30 45 07 24 09 11 33 30 84 BPXPRFC SYSO0004 TCPIP STANDARD TCPXLPAM 5 035 07 24 09 11 33 30 45 07 24 09 11 33 30 90 BPXPRFC SYS00006 TCPIP ETC SERVICES TOTAL FOR 07 24 09 11 33 30 45 ITEMS USTTAO35 07 24 09 11 58 53 19 07 24 09 11 58 53 31 BPXPRFC 51500001 5 51 5 5 035 07 24 09 11 58 53 19 07 24 09 11 58 53 34 BPXPRFC SYS00004 TCPIP STANDARD TCPXLPAM USTTAO35 07 24 09 11 58 53 19 07 24 09 11 58 53 37 BPXPRFC SYSO0006 TCPIP ETC SERVICES TOTAL FOR 07 24 09 11 58 53 19 ITEMS TOTAL FOR USTTAO35 6 ITEMS additional lines not shown Figure 12 A report with nested control breaks Spectrum SMF Writer Tutorial 49 Lesson 8 How to Specify the Sort Order and Control
103. PASS OF THE SMF FILE KKK KKK KKK KK KK KKK KK KK KK KK KKK KKK KKK NEWOUTPUT KKK KKK KKK KKK KKK KKK KKK KKK KK KK KK KK KK KKK KK RRR KERR KEK SUPPRESS DETAIL LINE AND JUST SHOW TOTALS KK KKK KK KK KK KK k k K KK KKK KKK KKK RK KK KKK e K K ee ek KK k K OPTION SUMMARY KK KKK KK KKK KKK kok k KKK KKK KK KKK KEK KK KKK KKK KK RRR SPECIFY WHICH SMF RECS TO INCLUDE IN THIS REPORT KK KKK KK KK k k KK k k K KK KK KK KK KKK KEK KK KEK EK KKK KK ee KK RRR INCLUDEIF SMF30RTY 30 AND SMF30STP 5 NEES NUMBER OF TASKS BY TYPE TONLE SUMMARY REPORT COLUMNS WORK TYPE SMF30JBN SMF30JNM SMF30DTE SMF30TME SMF30STD SMF30SIT ELAPSED SECS 8 ELAPSED HRS 7 SORT WORK TYPE BREAK WORK TYPE SPACE 0 64 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports Produce this Report NUMBER OF TASKS BY WORD TYPE INDICATOR SMF30WID ELAPSED ELAPSED SMF30WID SMF30JBN SMF30JNM SMF30DTE SMF30TME SMF30STD SMF30SIT SECS HRS JES2 65110010 J0B02576 07 25 08 06 01 33 76 07 25 08 06 01 31 67 2 09 0 0006 JES2 AMTTRA23 J0B07284 07 25 08 06 02 38 59 07 25 08 05 59 36 87 181 72 0 0505 JES2 23 J0B07286 07 25 08 06 06 49 94 07 25 08 06 05 43 66 66 28 0 0184 JES2 23 JOBO7287 07 25 08 06 07 21 59 07 25 08 06 07 21 16 0 43 0 000 JES2 BAIPORT J0B07289 07 25 08 06 09 06 37 07 25 08 06 08 45 17 21 20 0 0059 JES2 01 20715 J0B07291 07 25 08 06 25 4
104. PXPRECP 5 500001 SYS1 TCPPARMS 80 SYSUP 07 24 09 11 31 00 39 07 24 09 11 31 00 BPXPRECP 5 500004 TCPIP STANDARD TCPXLPAM 256 SET TOTAL FOR SfSUP 07 24 09 11 31 00 39 ITEMS UP 07 24 09 11 31 05 00 07 24 09 11 31 05 10 BPXPRECP SYS00001 TCPPARMS UP 07 24 09 11 31 05 00 07 24 09 11 31 05 12 BPXPRECP SYS00004 P STANDARD TCPXLPAM TOTAL FOR SYSUP 07 24 09 11 31 05 00 ITEMS SYS 07 24 09 11 31 06 67 07 24 09 11 31 06 76 BPXPRECP SYSOO001 TCPPARMS SYS 07 24 09 11 31 06 67 07 24 09 11 31 06 78 BPXPRECP 5 500004 P STANDARD TCPXLPAM TOTAL FOR SYSUP 07 24 09 11 31 06 67 ITEMS USTTAO14 07 24 09 12 00 44 10 07 24 09 12 00 44 BPXPRFC 5 500001 TCPPARMS USTTAO14 07 24 09 12 00 44 10 07 24 09 12 00 44 BPXPRFC 5 500004 P STANDARD TCPXLPAM USTTAO14 07 24 09 12 00 44 10 07 24 09 12 00 44 BPXPRFC 5 500006 P ETC SERVICES TOTAL FOR USTTA014 07 24 09 12 00 44 10 ITEMS A035 07 24 09 11 33 30 45 07 24 09 11 33 30 62 BPXPRFC SYS00001 at A035 07 24 09 11 33 30 45 07 24 09 11 33 30 84 BPXPRFC SYS00004 P A035 07 24 09 11 33 30 45 07 24 09 11 33 30 90 BPXPRFC SYS00006 P TOTAL FOR USTTAO35 07 24 09 11 33 30 45 CPPARMS STANDARD TCPXLPAM ETC SERVICES A035 07 24 09 11 58 53 19 07 24 09 11 58 53 SYS00001 TCPPARMS A035 07 24 09 11 58 53 19 07 24 09 11 58 53 SYS00004 P STANDARD TCPXLPAM A035 07 24 09 11 58 53 19 07 24 09 11 58 53 SYS00006 P ETC SERVICES TOTAL FOR USTTAO35 07 24 09 1
105. Report from SMF 30 63 Normalizing the EXCP Sections in an SMF 30 Record 67 Job Completion Report from SMF 30 Records 68 Job Statistics by Time of Day from SMF 30 Records 70 Simple Chargeback Report from SMF 30 Records 74 DFSMS Usage and Performance Report for Selected Datasets from 42 T VSAM File Activity Report from SMF 64 78 RMF Coupling Report from SMF 74 79 Event Report from SMF 80 81 Usage Statistics from SMF 89 82 Tape Library Statistics from SMF 94 1 Records 83 DB2 IFC Destination Statistics SMF 100 84 DB2 Accounting Statistics by Plan from SMF 101 85 DB2 Access Audit Report from SMF 102 86 CICS Performance Report from SMF 110 88 CICS Transaction Time Report from SMF 110
106. SNM field INCLUDEIF SMF14 JFCBDSNM PAY IF DSN CONTAINS PAY By being clever you can even accomplish more complicated wildcard patterns like PROD PAYROLL if meant any single character and meant any text of any length COMPUTE DSNPART1 LEFT SMF14 JFCBDSNM 1 4 1ST 4 BYTES OF DSN COMPUTE DSNPART2 SUBSTR SMF14 JFCBDSNM 6 1 1 BYTE AFTER PROD COMPUTE DSNPART3 SUBSTR SMF14 JFCBDSNM 7 38 ALL DSN AFTER PROD INCLUDEIF DSNPARTI PROD AND DSNPART2 AMD DSNPART3 PAYROLL Syntax for Continuation Lines Often the INCLUDEIF statement will be too long to fit on one control statement Spectrum SMF Writer uses columns 1 through 72 of each statement Anything in columns 73 80 is ignored You may continue your INCLUDEIF statement onto as many lines as needed Just be sure to begin each continuation line with a blank in column 1 If you need to break a literal onto multiple lines continue up to column 72 in one line and resume it in column 2 of the next line Spectrum SMF Writer Tutorial 59 Appendix B Examples of SMF Reports Appendix B Examples of SMF Reports This chapter shows some actual useful SMF reports made with Spectrum SMF Writer Each example includes the control statements we used along with a small sample of the report output The examples are presented in order of SMF record used CICS Up Time Report from SMF 5 Records In this report we want to show what percentage
107. STM SUM SERVIC TIME SYNCH 10 BIZ SORT SMF74XNM SMF74SNM SMF74DTE SMF74TME SMF744SNAM BREAK SMF74SNM SPACE PAGE Spectrum SMF Writer Tutorial 79 Appendix B Examples of SMF Reports Produce this Report 08 14 07 RMF COUPLING ACTIVITY REPORT PAGE 1 SYSPLEX SYSPL9 SYSTEM 501 SUM SQRS SUM CNT SUM SQRS SUM INTERVAL TOTAL SERVIC SERVIC ASYNCH TIMES SERVIC SERVIC CONNECTED START INTERVAL STRUCT 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 SMTO 09 30 00 10 00 000 2 304 352 76M 160 125 3 4 15 481 241 BERVM SMZO 09 30 00 10 00 000 2 304 885 18M 87 762 6 17 237 307 BERVM 5 10 09 30 00 10 00 000 2 304 1 070 91 177 594 5 230 667 667 CRAF HBPO 09 30 00 10 00 000 12 544 445 14M 51 859 93 111 532 2 456 CRAF_HBPO 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 568 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_HBP16KO 09 30 00 10 00 000 5 376 14 1 471K 2 474 16 9 661 393 CRAF_HBP16KO 09 30 00 10 00 000 5 376 CRAF HBP2 09 30 00 10 00 000 24 576 46 758 5 104 6 3 270 140 CRAF HBP2 09 30 00 10
108. SUB SYSTEM SMF115TME PERIOD ENDING TPIC Z9 99 99 QPSTPOOL BUFFER POOL NUMBER 6 QPSTNBUF OF BUFFERS IN POOL 8 QPSTCBSL LOWEST OF STEALABLE BUFFERS 9 QPSTCBS OF STEALABLE BUFFERS 9 QPSTSTL OF BUFFER STEALS 9 QPSTGETP OF GET PAGE 010 REQUESTS 11 QPSTGETN OF GET PAGE REQUESTS 11 QPSTRIO OF DASD READ OPS 6 QPSTSTW OF SET WRITE INTENT REQUESTS 9 QPSTTPW OF PAGES WRITTEN TO DASD 9 QPSTWIO OF DASD WRITE OPS 6 TITLE SMF 115 WEBSPHERE MQ PERFORMANCE REPORT TITLE BUFFER POOL MANAGER STATISTICS Produce this Report SMF 115 WEBSPHERE MQ PERFORMANCE REPORT BUFFER POOL MANAGER STATISTICS LOWEST OF OF OF OF OF OF Z 0S BUFFER OF OF OF OF GET PAGE GET PAGE DASD SET WRITE PAGES DASD SUB PERIOD POOL BUFFERS STEALABLE STEALABLE BUFFER OLD NEW READ INTENT WRITTEN WRITE SYSTEM ENDING NUMBER IN POOL BUFFERS BUFFERS STEALS REQUESTS REQUESTS OPS REQUESTS TO DASD OPS ZSA 00 07 0 50 000 49 618 49 943 0 833 658 26 025 0 736 158 386 112 ZSA 00 07 1 20 000 17 424 18 457 0 1 318 813 507 094 0 1 016 252 2 518 689 ZSA 00 07 2 50 000 49 990 49 993 0 2 962 528 0 2 962 14 14 ZSA 11 00 07 S 20 000 19 830 19 885 0 198 242 5537 9 0 56 514 144 41 ZSA 00 07 4 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 5 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 6 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 7 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 8 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 9 0 0 0 0 0 0 0 0 0 0 ZSA 00 07 10 0 0 0 0 0 0
109. SUT2 05 0000 SYSOUT 05 0000 SORTMSG 05 0000 SORTWKO1 05 0000 SORTWKO2 05 0000 SORTWKO3 05 0000 SORTWKO4 05 0000 SORTIN 05 0000 SORTOUT 05 0000 SORTWKO1 0000 SYS00001 1 10 800 0000 SYS00002 6 035 10 800 0000 YS00003 2 10 800 0000 SYS00004 3 078 10 800 0000 500005 18 10 800 0000 SYS00006 10 800 0000 SYSOUT 0 0000 SORTWKO1 0000 SORTWKO2 0000 SORTWKO3 0000 50 0000 50 0000 SYS 0000 50 0000 0000 0000 50 0000 50 0000 50 0000 50 0000 50 0000 50 0000 SY 0000 50 0000 50 0000 50 0000 50 a O S Q gt S S gt gt Q Q Q Q Q QO 0101001 t n Q O O O O O P PS py S O S additional lines not shown Figure 4 SMF 30 report with data from all occurrences of the EXCP section 18 Spectrum SMF Writer Tutorial Lesson 3 How to Report on Multiple Occurrences of Section NORMALIZE parm has two parameters the first one is a field in the record that defines the entire first occurrence of the section The second parameter in
110. T statement like this INPUT SMF14 SHOWFLDS YES The above statement tells Spectrum SMF Writer to print in the control statement listing a list of all of the fields defined for SMF14 6 Spectrum SMF Writer Tutorial Lesson 1 How to Make SMF Report in 5 Minutes What about non SMF Files You may be thinking that Spectrum SMF Wiriter would be a very handy tool to use with other files inyour shop Those files that you always seem to be making quick and dirty reports for Or files whose data that you often need to export into a PC spreadsheet You are absolutely right This software is the perfect tool for all of those frequent ad hoc requests that come up And you wouldn t even need to learn a new language However Spectrum SMF Writer is restricted by license and via code to report exclusively on SMF input files To address your needs we do offer an unrestricted version of this same program It is called Spectrum Writer Spectrum Writer can report on any file in your shop and even on DB2 tables with the available DB2 Option Call us to ask about upgrading your current Spectrum SMF Writer license to a license for our full Spectrum Writer product It does everything Spectrum SMF Writer does and more Note we do permit you to use Spectrum SMF Wiriter to experiment for non productive purposes with other files to actually see how it would work out for your shop The software you now have allows you to report on a very limit
111. TIME NOTOTALS FOOTING TIME JOB COUNT TOTAL 5 CPU SECS AVG 9 CPU SECS MAX 9 LAPSED TIME AVG 9 LAPSED TIME MAX 9 0B QUEUE TIME AVG 7 STORAGE USED AVG 7 MOUNTS AVG 7 PAGE SWAPS AVG 7 m m BREAK GRAND NOTOTALS FOOTING JOB COUNT TOTAL 5 CPU SECS AVG 9 CPU SECS MAX 9 ELAPSED TIME AVG 9 ELAPSED TIME MAX 9 JOB QUEUE TIME AVG 7 STORAGE USED AVG 7 TAPE MOUNTS AVG 7 PAGE SWAPS AVG 7 72 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports Produce this Report JES2 JOB STATISTICS FOR EACH QUARTER HOUR OF THE DAY AVG MAX AVG MAX AVG AVG JOB CPU CPU ELAPSED ELAPSED SECS STORAGE AVG NUM AVG NUM BEGIN JOB TIME TIME TIME TIME IN JOB PER JOB TAPE PAGE TIME COUNT SECS SECS SECS SECS QUEUE K S MOUNTS SWAPS 05 00 4 7 92 30 85 0 2 0 39 0 2 364 2 0 05 45 9 13 9 13 15 35 15 35 0 1 596 13 0 06 15 0 65 0 65 14 80 14 80 0 2 668 2 0 11 45 0 04 0 04 12 6 12 61 0 504 0 0 12 00 34 0 11 0 77 14 47 26 71 0 12097 0 0 12 15 4 0 09 0 60 14 44 20 94 0 967 0 0 12 45 2 0 02 0 02 0 40 0 55 1 936 0 0 17 30 6 0 34 1 71 86 7 91 846 0 0 20 15 3 0 01 0 01 0 17 0 23 0 727 0 0 20 30 0 23 0 23 0 94 0 94 0 864 0 0 21 15 0 00 0 00 0 16 0 16 0 312 0 0 21 30 8 0 02 0 02 4 06 6 66 0 635 0 0 23 00 3 0 99 1 49 4 15 6 15 1 703 0 0 23 15 2 0 03 0 03 0 73 1 22 0 968 0 0 23 30 2 0 03 0 04 0 66 1 05 1 1 018 0 0 23 45 2 0 04 0 04 ail 1 50 0 0 0 ALL 112 0 4
112. TR S SMF113 2 CSN NUM C SMF113 2 CSP COUN SMF113 2 CR 1ST CO F113 2 CSOF E COUNTER REPORT NTER SET WITH A SINGLE COUNTER COLLECT TIME TP Z9 99 99 OLLECT TIME TP Z9 99 99 ECT DATE NUM 4 ET TYPE 4 NTRS 5 ER UNTER IN SMF 18 Produce this Report SMF113 HARDWARE COUNTER REPORT ONE LINE PER COUNTER SET WITH A SINGLE COUNTER START END END CTR 1ST COLLECT COLLECT COLLECT PROC SET NUM COUNTER TIME TIME DATE NUM TYPE CNTRS COUNTER MAP IN SMF REC 9 51 56 9 51 56 02 16 11 0 1 6 FC00000000000000 4 902 361 9 51 56 9 51 56 02 16 11 0 2 6 FC00000000000000 4 902 361 9 51 56 9 51 56 02 16 11 0 3 16 FFFF000000000000 4 902 361 9 51 56 9 51 56 02 16 11 0 4 29 FFFFFFF800000000 4 902 361 9 51 56 9 51 56 02 16 11 1 1 6 FC00000000000000 46 196 9 51 56 9 51 56 02 16 11 1 2 6 FC00000000000000 46 196 9 51 56 9 51 56 02 16 11 1 3 16 FFFF000000000000 46 196 9 51 56 9 51 56 02 16 11 1 4 29 FFFFFFF800000000 46 196 9 51 56 9 51 56 02 16 11 2 1 6 FC00000000000000 347 786 9 51 56 9 51 56 02 16 11 2 2 6 00000000000000 347 786 9 51 56 9 51 56 02 16 11 2 3 16 FFFF000000000000 347 786 9 51 56 9 51 56 02 16 11 2 4 29 FFFFFFF800000000 347 786 9 51 56 9 51 56 02 16 11 3 1 6 00000000000000 16 454 200 9 51 56 9 51 56 02 16 11 3 2 6 FC00000000000000 16 454 200 9 51 56 9 51 56 02 16 11 3 3 16 FFFF000000000000 16 454 200 9 51 56 9 51 56 02 16 11 3 4 29 FFFFFFF800000000 16 454 200 9 51 56 10 01 56 02 16 11 0 1
113. UP 92 168 25 37 DSN9KJ DBT4 09 23 08 10 40 26 94 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 34 42 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 35 11 db2trbNon de SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 41 43 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 46 74 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 48 39 db2trbWebSph SERVER MAJSERVR SETUP 92 168 43 100 DSN9KJ DBT4 09 23 08 10 40 53 43 db2trbWebSph SERVER MAJSERVR SETUP 92 168 25 37 DSN9KJ DBT4 09 23 08 10 40 53 44 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 56 49 db2trbNon de SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 03 01 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 10 36 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 13 04 db2trbWebSph SERVER MAJSERVR SETUP 92 168 43 100 DSN9KJ DBT4 09 23 08 10 41 17 30 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 24 22 db2trbWebSph SERVER MAJSERVR SETUP 92 168 25 37 DSN9KJ DBT4 09 23 08 10 41 25 02 db2trbNon de SERVER MAJSERVR SETUP 92 168 43 100 DSN9KJ DBT4 09 23 08 10 41 25 09 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 25 41 db2trbNon de SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 41 31 93 db2trbWebSph SERVER MAJSERVR SETUP 92 168 43 100 DSN9
114. V40 COMPUTE SMF94ADV40 50 WHEN SMF9420F lt gt 0 ASSIGN SMF94ADV45 SMF94ADV50 COMPUTE SMF94ADV50 100 WHEN SMF9420F lt gt 0 ASSIGN SMF94ADV55 SMF94ADV60 SMF94ADV65 SMF94ADV70 SMF94ADV75 SMF94ADV80 SMF94ADV85 SMF94ADV90 SMF94ADV95 SMF94ADVOO COMPUTE THRES WHEN SMF9420F lt gt 0 ASSIGN SMF94THRES COMPUTE SRTCT WHEN SMF9420F lt gt 0 ASSIGN SMF94SRTCT COMPUTE PRICT WHEN SMF9420F lt gt 0 ASSIGN SMF94PRICT COMPUTE MTVCA WHEN SMF9420F lt gt 0 ASSIGN SMF94MTVCA COL SMF94DTE SMF DATE 9 TIME SMF94HHI 4 HOUR NOACC SMF94LM1 6 MAX DRIVES 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 1005 ACTIVE THRES 7 BIZ RECLAIM THRESH PERCENT SRTCT 7 BIZ SCRATH STACKED VOL CNT PRICT 7 BIZ PRIVATE SCRATCH VOL CNT MTVCA 7 BIZ TAPE VOLUME CACHE AGE Produce this Report MAX SMF DATE SMF TIME GRAND TOTAL 1 ITEM HOURLY TAPE STATISTICS FROM SMF 94 RECORDS FOR TOTAL TOTAL MOUNTS DISMOU MOUNT DISMOU 10 20 20 30 30 40 40 50 50 100 THRESH HOUR DRIVES PENDIN PENDIN TIME 11AM MAX TAPE VOLUME CACHE AGE AVG AVG
115. a NORMALIZE parm is an expression yielding the number of times the sections occurs The length of the section is taken from the defined length of the first parameter Here is an example of an INPUT statement that uses one NORMSMF and one NORMALIZE parm to perform a nested normalization described in a later section on SMF 70 records INPUT 5 70 NORMALIZE THE LPARS THEN EACH LPAR S LOGICAL PROCESSORS NORMWHEN SMF70RTY 70 AND 5 705 1 NORMSMF SMF70BCS LPARS STANDARD TRIPLET NORMALIZE SMF70 PRSMLPD SECTION SMF7OBDN LOG PROCS NON STANDARD Internally Spectrum SMF Writer handles NORMALIZE parms very differently from NORMSMF parms If you are interested in the details see the main Spectrum Writer manual Check the index for NORMALIZE Which Parm Should You Use to Normalize a Section We have made it easy for you to normalize the various SMF record sections that occur more than once Just look at the file definition for the SMF record you are interested in You will find the definitions in the Spectrum SMF Wiriter copy library There is a comment box before each section that is eligible to be normalized In that comment box we show the NORMWHEN and NORMSMF or NORMALIZE parm to use in order to normalize that particular section Since the different sections within a record contain totally different sets of data in most cases you will just want to normalize only a single section for any given report In the
116. alue Figure 7 in the next lesson page 37 shows a report that uses this COMPUTE statement If you prefer to see the elapsed time in regular HH MM SS time format you can convert this numeric seconds field to a time field like this COMPUTE JOB ELAPSED TIME MAKETIME JOB ELAPSED SECONDS Figure 7 page 37 also shows this computed field Creating Character Fields You can also create character fields There is only one operation used in computing character fields the concatenation operation The plus sign is used as the symbol for concatenation Of course there are also many built in functions that operate on and or return character data Here is an example of a character field that is handy for reports from many SMF record types including type 14 COMPUTE SMF14 JOBID SMF14JBN FORMAT SMF14RSD FORMAT SMF14RST H The above statement creates a single new field that has a unique value for every job in the SMF file It concatenates the jobname with the date and time that the job hit the internal reader This combination forms a unique identifier for the job And this is very useful when you want to sort and break on all of the records for a single job perhaps printing a total line for the job In fact there is an example of using this field in just that way in Figure 10 page 45 In the statement above we used the built in field in two places This is necessary because you ca
117. anywhere that a space is allowed in the expression Then continue the expression in column 2 of the next line or lines Leave column 1 of the continuation line s blank See Appendix A Conditional Expressions of the User Manual page 57 for a more complete discussion of the rules for the conditional expressions allowed on the INCLUDEIF statement How to Use the COLUMNS Statement After specifying the desired SMF record type in the INPUT and INCLUDEIF statements the next step is to tell Spectrum SMF Writer which fields from that record you want to see in Spectrum SMF Writer Tutorial 5 Lesson 1 How to Make SMF Report 5 Minutes your report Use the COLUMNS statement to do that Each field named in this statement will appear as one column of data in the report For example INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS COLUMNS SMF14DTE SMF14TME SMF14JBN SMF14PGN SMF14TIOE5 SMF14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP The COLUMNS statement above tells Spectrum SMF Writer that we want columns in our report that show the date and time the SMF record was written the job name program name DDNAME DSNAME LRECL and count of EXCP s for that dataset You may specify as many fields as you have room for in the report Putting It All Together Just the three statements discussed above INPUT INCLUDEIF and COLUMNS you provide Spectrum SMF Writer with everything it n
118. aset with SPFTEMP in its name We want to include all jobs that wrote to the dataset as well as any jobs that may have deleted it To do that we need to combine the information from SMF 15 records logged when a DD is opened for output and SMF 17 records logged when a dataset is deleted 38 Spectrum SMF Writer Tutorial Lesson 7 Conditional COMPUTE Statements These Control Statements INPUT SMF15 GET TYPE 15 FILE AND FIELD DEFINITIONS COPY 17 GET TYPE 17 FIELD DEFINITIONS TOO kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk MOVE DATA FROM DIFFERENT LOCATIONS TO A SINGLE FIELD kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk COMPUTE DSN WHEN SMF15RTY 15 ASSIGN SMF15 JFCBDSNM ELSE ASSIGN SMF17DSN COMPUTE MGMT WHEN SMF15RTY 15 ASSIGN SMF15MCN ELSE ASSIGN COMPUTE DISP WHEN SMF15RTY 15 ASSIGN SMF15 DISP ELSE ASSIGN DELETE INCLUDEIF 5 15 OR 17 SELECT BOTH 15 AND 17 AND DSN SPFTEMP MEANS SCAN FOR TEXT COLUMNS SMF15DTE LOG DATE SMF15TME LOG TIME 15 4 SMF TYPE NOACC DSN 30 DATASET NAME MGMT MANAGEMENT CLASS DISP TITLE DATE LONG1 SMF UPDATES AND DELETES PAGE PAGENUM TITLE ON DATASETS CONTAINING SPFTEMP Produce this Report FEBRUARY 23 2010 SMF UPDATES AND DELETES PAGE ON DATASETS CONTAINING SPFTEMP SMF MANAGEMENT LOG DATE LOG TIME TYPE DATASET NAME D
119. break your column heading text into multiple lines use a vertical bar 1 as the separator character For example COLUMNS SMF30BLK EXCP BLOCK COUNT In the above statement we specified our own column heading for the SMF30BLK field As you can see in the report in Figure 5 the SMF30BLK column now has EXCP BLOCK and COUNT stacked over it as a 3 line column heading 26 Spectrum SMF Writer Tutorial Lesson 5 Improving the Appearance of your Report These Control Statements INPUT SMF30 COMPUTE JOB ELAPSED SECONDS MAKENUM SMF30DTE 86400 MAKENUM SMF30TME MAKENUM SMF30STD 86400 MAKENUM SMF30SIT COMPUTE JOB ELAPSED HOURS 2 JOB ELAPSED SECONDS 3600 COMPUTE JOB ELAPSED TIME MAKETIME JOB ELAPSED SECONDS COMPUTE EXCP CHARGE 2 SMF30BLK 0001 INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT TYPE 30 SUBTYPE 5 COLUMNS SMF30STD SHORT3 JOB START DATE SMF30SIT HH MM JOB START TIME SMF30DTE SHORT3 JOB END DATE SMF30TME HH MM JOB END TIME JOB ELAPSED TIME TPIC ZZ ZZ Z9 99 ACCUM JOB ELAPSED SECONDS 10 JOB ELAPSED HOURS 7 BIZ 1 SMF3OBLK EXCP BLOCK COUNT BIZ 6 EXCP CHARGE DOLLAR 6 BIZ SMF30BSZ P ZZ ZZZ MAX BLOCK SIZE NOACCUM TITLE DATE LONG1 CUSTOMIZED SMF30 REPORT PAGE PAGENUM Produce this Report MARCH 2 2010 A CUSTOMIZED SMF30 REPORT PAGE 0B JOB JOB JOB JOB JOB JOB EXCP MAX RT START END END ELAPSED ELAPSED ELAPSE
120. built in field 23 JOBNAME built in field 23 PAGENUM built in field 22 23 use in TITLE statement 22 PARSE built in function 35 REPLACE built in function 35 TIME built in field 23 TIME24 built in field 23 TODAY built in field 22 A Abends reporting on 38 68 ACCUM parm in COLUMNS statement 28 in FIELD statement 29 Alignment of titles left center and right 23 Alphabetizing the report 42 AND in conditional expressions 57 Ascending order in SORT statement 44 Assembler record layouts 7 ASSIGN parm in COMPUTE statement 36 Audit DB2 audit report 86 AVERAGE AVG parm in BREAK statement 51 in COLUMNS statement 28 Averages how to print 51 which columns receive 28 100 Spectrum SMF Writer Tutorial Index B Batch job 1 Big making a column bigger 28 Bits bit fields 8 displaying data as bits 26 BIZ parm in COLUMNS statement 28 Blank lines printing after the total line 44 Blanks required around minus sign 31 showing zeros as blanks 28 BREAK statement 44 control break spacing 44 order of 48 page breaks 46 79 printing averages at control breaks 51 printing control group footings 51 printing control group headings 51 printing statistical lines at control breaks 51 where to put 48 Buffer buffer pool report 92 Built in fields available in TITLE and FOOTNOTE statements 22 C Centering titles 23 Character fields creating your own 34 Character operations 34 Chargeback sample report
121. can use additional parms in the BREAK statement to customize your control break For example you can specify a break spacing parm This parm tells Spectrum SMF Writer what kind of spacing to perform at the control break By default Spectrum SMF Writer prints two blank lines at each control break after the totals line Use a spacing parm to request either a different number of blank lines or to request a page break For example the following statement makes SMF14 JOBID a break field and specifies that 3 blank lines should print at the control break BREAK SFM14 JOBID SPACE 3 44 Spectrum SMF Writer Tutorial Lesson 8 How to Specify the Sort Order and Control Breaks These Control Statements INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS e COMPUTE SMF14 JOBID SMF14JBN FORMAT SMF14RSD FORMAT SMF14RST COLUMNS SMF14 JOBID JOBNAME AND READER TIMESTAMP SMF14DTE SMF LOG DATE SMF14TME SMF LOG TIME SMF14PGN PROGRAM NAME SMF14TIOE5 DDNAME SMF14 JFCBDSNM DSNAME 25 SMF14 JFCLRECL LRECL 7 BIZ NOACCUM SMF14EXCP EXCP COUNT FOR DDNAME 9 SMF14 JOBID SMF14EXCP D SMF14 JOBID EXCP COUNTS WITH JOB TOTALS Produce this Report EXCP COUNTS WITH JOB TOTALS EXCP SMF SMF COUNT 106 106 PROGRAM FOR JOBNAME AND READER TIMESTAMP DATE TIME NAME DDNAME DSNAME LRECL DDNAME SYSUP 07 24 09 11 31 00 39 07 24 09 11 31 00 B
122. ce Spectrum SMF Writer s language is non procedural the exact location of a COMPUTE statement does not affect when or even whether the computation is actually performed for a given input record 32 Spectrum SMF Writer Tutorial Lesson 6 How to Create Your Own Fields For efficiency s sake Spectrum SMF Writer performs computations only if or when the value of the field is actually needed In that sense the COMPUTE statement is similar to the FIELD statement Both statements describe how to obtain the contents of a given field The FIELD statement tells where the raw data is located in the input record and what format it is in the COMPUTE statement tells what formula to use to calculate the value of a field But Spectrum SMF Writer itself decides when and whether it actually needs to go to the effort of obtaining a field s value while producing the report For example assume that a COMPUTE field is used in the COLUMNS statement but is not referred to in the INCLUDEIF statement If the INCLUDEIF statement fails for an input record Spectrum SMF Writer will not need to calculate the COMPUTE field s value at all for that record It only needs to compute the value if the record passes the INCLUDEIF statement s conditions so that the data can be shown in the output line For this reason it is fine to store commonly used COMPUTE statements right in the copy library along with a file definition They will not add any significant overhead to r
123. closed in quotation marks is printed as is in the title Anything not within quotation marks must be the name of a field whose contents you want in the title 22 Spectrum SMF Writer Tutorial Lesson 4 How to Make Your Own Report Titles Built In Fields Available Here is a table showing the built in fields available for use in TITLE statements Description Field d the system date in a true date field which you can format any DATE p way you like By default it is formatted as a character field containing the current day of the week e g DAYNAME MONDAY the system time formatted as 8 byte 12 hour HH MM AM PM TIME character field the system time formatted as 5 byte 24 hour character TIME24 field J HHMMSS the system time in a true time field which you can format any way you like JOBNAME the name of the job executing Spectrum SMF Writer PAGENUM the current page number of the report Putting SMF File Data in the Title As mentioned earlier TITLE statements consist of any mix of literal texts and field names A field name can be one of Spectrum SMF Writer s built in fields as in the earlier example Or it can be the name of a regular field from the SMF file or even a COMPUTE field When inserting the contents of a data field into the title Spectrum SMF Writer uses the data found in the first record used on that report page
124. d symbols respectively You may also use parentheses as needed to indicate the order in which the operations should be performed Note since dashes are allowed as characters in field names when performing subtraction always put a blank space before and after the minus sign Otherwise the minus sign will be treated as part of the field name Blanks are optional around the other arithmetic operators In addition to these arithmetic operations there are also a large number of built in functions that you can use in the COMPUTE statement These built in functions allow you to perform more complex operations on SMF data A complete list of built in functions is found in Appendix D Built In Functions page 628 Spectrum SMF Writer Tutorial 31 Lesson 6 How to Create Your Own Fields These Control Statements INPUT SMF30 COMPUTE MAX EXCP BYTES SMF30BLK SMF30BSZ COMPUTE TOTAL CPU TIME SMF30UCT SMF30UCS COMPUTE CPU SECONDS MAKENUM TOTAL CPU TIME INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT TYPE 30 SUBTYPE 5 COLUMNS SMF30TME SMF30JBN SMF30BLK 8 SMF30BSZ 8 MAX EXCP BYTES SMF30UCS 13 ACCUM SMF30UCT 13 ACCUM TOTAL CPU TIME 13 ACCUM CPU SECONDS 7 TITLE EXAMPLES OF COMPUTED FIELDS FROM SMF 30 RECORDS Produce this Report EXAMPLES OF COMPUTED FIELDS FROM SMF 30 RECORDS MAX EXCP CPU SMF30TME SMF30BLK SMF30BSZ BYTES SMF30UCS SMF30UCT SECONDS 06 00 03 48 BCA9514
125. d named SMF30EOF the first field in a triplet which specifies the offset from the beginning of the record to the first occurrence of the EXCP section Specifying SMF30EOF in the NORMSMF Spectrum SMF Writer Tutorial 15 Lesson 3 How to Report on Multiple Occurrences of Section parm causes the software to step through each occurrence of the EXCP section processing each of them in turn The NORMSMF parm is almost always used in conjunction with the NORMWHEN parm as explained below and as shown in Figure 4 on page 18 The NORMWHEN parms tells Spectrum SMF Writer when to perform the normalization described in the following NORMSMF parm s If we had omitted the NORMWHEN parm in Figure 4 Spectrum SMF Writer would have tried to normalize the EXCP section of every input record not just the type 30 subtype 5 SMF records This would lead to errors since the triplet field that Spectrum SMF Writer uses for the type 30 record SMF30EOF would contain garbage for all of the non type 30 records What the NORMSME Parm Does NORMSMF parm causes Spectrum SMF Writer to process the same physical SMF record multiple times Each time it increments the value in the SMF30EOF field by the length specified in the same triplet In effect each physical record is replicated a number of times producing multiple logical input records of the logical records created from a physical record are identical to that original physical record exce
126. detail lines and turn it into an executive summary report Then the report will just print the totals for each cost center This gives an idea of the sort of chargeback possibilities that exist with Spectrum SMF Writer This low cost program can give you an amazing amount of useful information with only minimal coding effort It can quickly pay for itself in the amount of programming effort saved These Control Statements OPTION SUMMARY UN COMMENT FOR A SUMMARY REPORT KKK KK KK KKK KKK eek ee ek ee ek ee ke ko e ke koe ee KKK ek ee ek eee SPECIFY THE INPUT FILE AND LAYOUT FOR THIS RUN KKK KK ek KKK KKK KKK ek ee ek e e ke KEK KK KK KK ERK ek ee INPUT SMF30 coke ee ke eee eek ee ek ee ek e e ke RK KK KEK KK KKK ek ee ek eee SPECIFY WHICH SMF RECORDS TO INCLUDE IN REPORT SUBTYPE 5 MEANS JOB TERMINATION RECORDS REPORT KK KKK KK KK ee ke ke KKK ek ee ek e e ke koe ke KKK KKK ek ee INCLUDEIF SMF3ORTY 30 AND SMF30STP 5 KK KKK KK KKK ek ee ek e e ke KK KK KEK EK KERR ek ee dee eee EXTRACT 1ST 8 BYTES OF JOBCARD ACCOUNT FIELD coke KEK KK KEK KK eek ee ek ee ek k e ke KK e ke KEK KK KKK ek COMP 8 LEFT SMF30ACT MIN 8 SMF30ACL coke KK KK KK KK KKK ee ek ee ek eee ee ek eee KERR kk WE WILL TOTAL CHARGES BY LEADING PART OF JOBNAME KK KKK ee KK ee ek eek ee ek ee ek eee KEK KK koe e KERR KK RR KEK COMP JOB PREFIX LEFT SMF30JBN
127. ds and another group is about to begin For example you might want to print a line of totals for the group the job in this case that just ended Or you might want to print a few blank lines before the next group starts printing or even skip to a new page This processing is called control break processing A control break occurs whenever one group of records ends and another group is about to begin The field that is being grouped for example SMF14 JOBID is called the control break field A control break field must also be a sort field since it is by being sorted that records are grouped together in the first place You may designate any sort field as a control break field Just name the field in a BREAK statement SORT SMF14 JOBID SMF14EXCP D BREAK SMF14 JOBID The above statements make SMF14 JOBID a control break field as well as a sort field Now we will get job totals in the report whenever the lines for one job ends and another job is about to begin After the totals two blank lines will print Then the report lines for the next job start to print and so on Figure 10 shows a report that uses the above BREAK statement to produce a control break Notice that at the breaks by default Spectrum SMF Writer prints the value of the break field the number of item in the control group and totals for each numeric column It also indicates the level of the break with a number of leading asterisks Control Break Spacing You
128. e SUMMARY option when it is fully debugged We used the COLUMNS statement just to get the automatic column headings The data that actually prints in the report is specified in the two BREAK statements One BREAK statement for the time slot control break The other BREAK statement is for the grand total break Note that the sample report below uses a small test SMF file A production file would show slots for all active times of the day These Control Statements coke KEK KK ok KK eek ee ek ee ek eee KK e k k k ee KKK ek ee ek CREATE JUST A SUMMARY REPORT KKK KK KK KKK KKK k k K ee ek ee ek ee ke KEK e K KK KK KKK ek K K K KERR k k k OPTIONS SUMMARY KK KKK KK KKK KKK KKK KKK KKK KK KKK RK KK KK KK KKK KK ee KEK RRR KEK SPECIFY THE INPUT FILE AND LAYOUT FOR THIS RUN KK KKK KKK KKK KK k k KK KK KK KK KKK KEK KK KEK KK KKK KK ee dee eee KEK INPUT SMF30 KK KKK KK KKK KKK KKK hok KKK KKK KKK k k Ok kok EK KKK KEK RRR SPECIFY WHICH SMF RECORDS TO INCLUDE IN REPORT WE WANT SMF 30 JOB COMPLETION RECORDS FOR 1 DAY K k k k ke k k k INCLUDEIF SMF3ORTY 30 AND SMF30STP 5 AND SMF30WID JES2 AND gt SMF30PPS SAME DAY AND SMF30PPS gt 00 00 DID START V Von n coke eee eee eek ee ek ee ek e KK KEK KK KEK KK KKK ek ee ek REE KOK K K SPECIFY REPORT TITLE III
129. e NEWOUT statement in Chapter 4 Beyond the Basics e the complete syntax for the NEWOUT statement in Chapter 10 Control Statement Syntax 12 Spectrum SMF Writer Tutorial Lesson 3 How to Report on Multiple Occurrences of a Section This lesson teaches you how to report on data in sections of an SMF record that occur more than one time The control statement discussed is e the NORMSMF parm of the INPUT statement e the NORMALIZE parm of the INPUT statement e the related NORMWHEN parm of the INPUT statement As you probably know SMF records are notorious for the complex way in which they are assembled Many commonly used SMF records consist of numerous different sections each containing an entirely different set of data For example here is a list of just some of the sections found within the SMF 30 record e Subsystem Section e Identification Section e I O Activity Section e Completion Section Processor Section e EXCP Section Complicating matters further certain sections may appear in some SMF 30 records but not in others Furthermore when a section does appear in a record it may not be in the same location in all records And finally some of these sections can occur more than one time within a single SMF 30 record And the number of times that it occurs varies from record to record Did we mention that each occurrence of such a multiple occurring section can contain nested sections of its own which yes you gue
130. e SMF record Yet the data might be easily computed from one or more fields which are in the record In such cases simply create a new field with a COMPUTE statement Creating Numeric Fields A COMPUTE statement specifies the name of a new field to create and supplies a computational expression to assign a value to that field The complete rules for computational expressions are discussed in Computational Expressions page 472 Basically your expression will consist of one or more arithmetic operations performed with SMF fields and or literals For example refer back to the report in Figure 3 page 15 That report has two numeric columns the EXCP block count SMF30BLK and the maximum block size SMF30BSZ We could compute our own new field called maximum EXCP bytes by multiplying those two fields together COMPUTE MAX EXCP BYTES SMF3OBLK SMF30BSZ Now that the MAX EXCP BYTES field has been created we can use that field in any way that other fields can be used For example a computed field can be used as a column in the body of the report in the report titles as a sort field as a control break field as part of a conditional expression in the INCLUDEIF statement or even as an operand in a subsequent COMPUTE statement to create another field Figure 6 shows a report that uses the above COMPUTE statement You can perform addition subtraction multiplication and division in the COMPUTE statement Use the an
131. e report 83 SMF records choosing 3 5 defining 3 5 multiple record types in same report 38 subtypes 5 triplets 13 20 Sort order how to specify 42 SORT statement 42 ascending descending order 44 control break spacing 44 where to put 42 Spacing at control breaks 44 48 SRB times 82 Statistics how to print 51 which columns receive 28 STCK date 58 STCK times 58 Step completion code example 68 Stringing fields together 34 Subtraction blanks required around minus sign 31 subtracting time fields to get elapsed time 33 Subtype selecting 5 SUMMARY parm in OPTION statement 46 60 63 70 74 Summary reports 46 47 Suppressing detail report lines 46 SWOPTION DD 29 SWOUTO001 DD 11 Syntax of control statements 22 System date 23 day of week 23 jobname 23 time 23 System time 23 Tab character as delimiter 12 106 Spectrum SMF Writer Tutorial Tasks sample report 63 TCB times 82 TCP connection report 94 Time 24 hour system time 23 elapsed calculating from SMF fields 33 system time 23 Time fields creating your own 33 Time of day reporting by 70 Times delimiter to use 29 formatting in report 25 showing or suppressing seconds 25 SRB 82 STCK 58 TCB 82 time literals 58 TITLE statement 22 alignment left center and right 23 default 6 including date time page number in title 22 omitting 22 putting SMF data in titles 23 SMF data in 79 text too long 22 use of quotation marks apostrophes 22 use of slash for alignmen
132. e the delimiter that Spectrum SMF Wiriter uses when it formats dates and time in the report For example OPTIONS DATEDELIM TIMEDELIM The statement above would cause dates to be formatted like this 31 12 10 And time fields would look like this 12 34 56 Of course you can use the delimiter character of your choice And don t forget this option that was mentioned in an earlier lesson OPTION DDMMYYLIT This option lets you use DD MM YY format date literals when writing your control statements Note that the delimiters specified by the DATEDELIM and TIMEDELIM options apply only to formatting data to display in the report The delimiters used to write date and time literals in the control statements can not be changed Always use slashes for dates and colons for times in your literals You can put all of these options on a single OPTION statement of course An easy way to specify these options for all reports is to put them in a new member of your Spectrum SMF Writer copy library we recommend naming the member SWOPTION Then either copy that member in each run with a COPY control statement Or add a SWOPTION DD in your execution JCL that points to that member of the copy library The dataset named in this DD is copied by default at the beginning of each run Spectrum SMF Writer Tutorial 29 Lesson 5 Improving the Appearance of your Report Summary Here is a summary of what we learned in this lesson use an override d
133. ecify ACCUM to force a column to be totalled A common example of the need for this is with fields that contain time intervals as opposed to time of day values By default Spectrum SMF Writer does not print totals for any time field Just specify an ACCUM parm for any time fields that you want totals for COLUMNS SMF14LRECL NOACCUM SMF14RTY NOACCUM COLUMNS SMF30TCN TOTAL DEVICE CONNECT TIME ACCUM 28 Spectrum SMF Writer Tutorial Lesson 5 Improving the Appearance of your Report Note to avoid having to specify ACCUM and NOACCUM parms in every report you make consider adding the appropriate parm to the definitions of commonly used fields in your copy library Just locate the FIELD statement you want and add either an ACCUM or NOACCUM parm to the statement For example FIELD SMF30TCN DISP 18 LEN 4 TYPE BU SECS ACCUM ALWAYS TOTAL Formatting Features for International Customers Here are some formatting tips of special interest to our international customers You may want to change the default way in which dates and numbers are formatted rather than specifying it for every individual field in the report The FORMAT option lets you do this easily Put the following statement near the beginning of your control statements OPTIONS FORMAT DD MM YY DOTSEP This statement makes DD MM YY the default format for all dates in the report And it makes the DOTSEP format the default for all numeric fields You can also chang
134. ed number of records from non SMF files To try this out see Chapter 6 How to Define Your Input Files in the full User s Guide to learn how to easily set up a definition for any file you like You can even use your existing COBOL or Assembler record layouts Spectrum SMF Writer Tutorial 7 Lesson 1 How to Make SMF Report 5 Minutes Summary Here is a summary of what we learned in this lesson The next lesson will teach you how to turn your SMF report into an export file for PC an INPUT statement is needed to tell Spectrum SMF Writer which SMF record to use for a particular report an INCLUDEIF statement is used to tell Spectrum SMF Writer which records from the input file to include in the report a COLUMNS statement is needed to tell Spectrum SMF Wiriter what columns of data to print in your report by using just these three statements you can produce a complete report programs To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn about writing control statements in general in Chapter 9 General Syntax Rules how to make a report column that contains a literal text page 126 how to print multiple report lines for each input record page 151 how to produce reports that are wider than 132 characters see page 417 or page 431 how to specify conditions based on bit fields page 465 how to use the STOPWHEN parm
135. eeds to produce an attractive basic report Notice the report in Figure 1 page 4 This report has e a default title containing the name of the input file as well as the date time day of the week and page number e the columns of data that we requested appearing in the same order as we specified e neat underlined column headings identifying each column of data e date time and numeric fields that are properly formatted from the raw SMF data e a Grand Totals line which shows totals for each of the numeric columns e anitem count showing the number of records included in the report What Files and Fields Are Available You may be wondering what files can be named in the INPUT statement And what fields are available for the COLUMNS statement The answers can be found in the Spectrum SMF Writer copy library Each PDS member that begins with SMF is the file definition for a particular SMF record Or for a particular subtype of some of the complex SMF record types Choose from these names for your INPUT statement The members beginning with REC contain the definitions for the individual fields for a given record These are the fields you can choose from for your COLUMNS statement and other statements that you will be learning about You can browse the copy library PDS to see what is available for you to report on You can also get a list of all of the fields available for a file by just adding the SHOWFLDS YES parm to your INPU
136. ements discussed are e the SORT statement e the BREAK statement e the SUMMARY parm of the OPTIONS statement How to Use the SORT Statement When no SORT statement is specified Spectrum SMF Writer defaults to printing the report records in their original input file order For SMF files that is normally the order in which the records were logged by the SMF system The sample SMF reports in the previous lessons all appeared in this default order To print a report in a different order just add a SORT statement The SORT statement can appear anywhere after the INPUT statement Only one SORT statement is allowed per report but it may contain as many sort fields as you like Spectrum SMF Writer will sort your report on all of the sort fields For example let s request a report from the SMF14 records and sort it on two fields SORT SMF14 JOBID SMF14EXCP D Now the report will be sorted first on SMF14 JOBID That is a computed field that was discussed on page 34 It has a unique value for each job in the SMF file When the file has multiple SMF14 records for the same job then those records will be sorted in descending SMF14EXCP order The report in Figure 9 uses the above statement Note you can actually use the SMF14 JOBID in your own reports without even having to write a COMPUTE statement for it This field is so useful that we have included the COMPUTE statement for it right in the copy library The SORT statement can name any
137. ented once again to process a new logical record using the third occurrence of the section On so on The normalization process continues until the number of occurrences specified in the third field of the triplet have been processed At that point the next physical record is read from the input file Here is an easy way to visualize normalizations The net result of processing the NORMALIZE parm is just the same as if each SMF 30 record actually contained only a single EXCP section but the SMF file contained one SMF 30 record for each DDNAME used in the job Incidentally that is exactly how the similar SMF 14 records actually are logged by SMF a separate type 14 record for each DD used in a job 16 Spectrum SMF Writer Tutorial Lesson 3 How to Report on Multiple Occurrences of Section Here is an example of using the NORMSMF parm to process all occurrences of the EXCP section of the SMF 30 subtype 5 records INPUT SMF30 COPY SMF 30 RECORD DEFS NORMWHEN SMF30RTY 30 AND SMF30STP 5 WHEN TO NORMALIZE NORMSMF SMF30EOF OFFSET FIELD IN TRIPLET INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT JUST TYPE 30 SUBTYPE 5 RECORDS COLUMNS SMF30DTE SMF30DTE SMF30RTY SMF30STP SMF30JBN SHOW THESE FLDS IN RPT SMF30INP SMF30SCC HEX SMF30DDN SMF30BLK SMF30BSZ The INPUT statement now has a NORMWHEN and a NORMSMF parm The other control statements haven t changed at all from the previous report example in Figure 3
138. eport runs that do not actually use them Creating Time Fields When working with SMF files time data plays an important role You can calculate useful information from the time stamps and time intervals contained in many SMF records For example the SMF 30 record has two CPU time fields named SMF30UCT total TCB time and SMF30UCS total SRB time We can use a COMPUTE statement to create a new CPU time field containing the combined SRB and TCB time We just add the two time fields together like this COMPUTE TOTAL CPU TIME SMF30UCT SMF30UCS The report in Figure 6 uses the above statement The TOTAL CPU TIME field created in this statement is a time field So by default it is formatted in the report as HH MM SS DD If you find that you are dealing with very small time intervals like the 00 00 00 24 in Figure 6 you may prefer to view the data as a numeric number of seconds Use the MAKENUM built in function to change the value from a time field to a numeric field COMPUTE CPU SECONDS MAKENUM TOTAL CPU TIME When times are converted to numeric values the result is the total number of seconds contained in the time field The report in now shows this computed field as a numeric value 0 24 Calculating Elapsed Times Let s look at another example of computing time fields When working with SMF data it is often useful to calculate the time difference between two time fields Let s say that we want to show a job s t
139. er of the BREAK statements does not determine which break is nested within the other That is determined by the order of the fields in the SORT statement 48 Spectrum SMF Writer Tutorial Lesson 8 How to Specify the Sort Order and Control Breaks These Control Statements INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS e COMPUTE SMF14 TIMESTAMP FORMAT SMF14RSD FORMAT SMF14RST COLUMNS SMF14JBN JOBNAME SMF14 TIMESTAMP READER TIMESTAMP SMFI4DTE SMF LOG DATE SMFIATME SMF LOG TIME SMF14PGN PROGRAM NAME SMF14TIOE5 DDNAME SMF14 JFCBDSNM DSNAME 25 SMF14 JFCLRECL LRECL 7 BIZ NOACCUM SMF14EXCP EXCP COUNT FOR DDNAME 9 SMF14JBN SMF14 TIMESTAMP SMF14EXCP D SMF14JBN SPACE 3 SMF14 TIMESTAMP SPACE 1 SMF14 REPORT WITH NESTED CONTROL BREAKS Produce this Report SMF14 REPORT WITH NESTED CONTROL BREAKS EXCP SMF SMF COUNT 106 106 PROGRAM FOR JOBNAME READER TIMESTAMP DATE TIME NAME DDNAME DSNAME LRECL DDNAME SYSUP 07 24 09 11 31 00 39 07 24 09 11 31 00 47 RECP SYS00001 SYS1 TCPPARMS SYSUP 07 24 09 11 31 00 39 07 24 09 11 31 00 50 RECP SYS00004 TCPIP STANDARD TCPXLPAM TOTAL FOR 07 24 09 11 31 00 39 ITEMS SYSUP 07 24 09 11 31 05 00 07 24 09 11 31 05 10 RECP SYS00001 SYS1 TCPPARMS SYSUP 07 24 09 11 31 05 00 07 24 09 11 31 05 12 RECP SYS00004 TCPIP STANDARD TCPXLPAM TOTAL FOR 07 24 09 11 31 05 00 ITEMS SYSU
140. es you how to make a simple SMF report in just 5 minutes using only three control statements These statements are e the INPUT statement e the INCLUDEIF statement e the COLUMNS statement You can make a SMF report with just these statements INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST 14 RECORDS COLUMNS SMF14DTE SMF14TME SMF14JBN SMF14PGN 5 14 0 5 5 14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP Figure 1 shows the report created from these statements How to Use the INPUT Statement The copy library PDS that you installed with Spectrum SMF Writer contains the SMF record definitions for dozens of SMF record types The very first step in requesting an SMF report is to tell Spectrum SMF Writer which one of these SMF records has the data needed for your report Use the INPUT statement to do this For example INPUT 5 14 The above statement tells Spectrum SMF Writer that you want to produce a report using data from the type 14 SMF records Each SMF 14 record contains information about one input data set referenced during the execution of a job or task The INPUT statement above does these two things 1 it copies the statements from member SMF14 in the copy library which in turn copies another member named REC14 Those members define the SMF input file and describe all of the fields available in the SMF 14 record That lets you refer to any of those fields in the cont
141. ession ELSE ASSIGN computational expression When Spectrum SMF Writer needs to compute the value of such a field it begins by evaluating the conditional expressions within the WHEN parms The WHEN parms are processed in order one by one As soon as a WHEN parm is found that is true Spectrum SMF Writer assigns the value from the corresponding ASSIGN expression to the compute field At that point no further WHEN parms are examined If none of the WHEN expressions are true then the value from the ELSE ASSIGN parm if present is assigned to the result If no ELSE ASSIGN parm was specified then a value of blanks or zeros will be assigned to the compute field depending on the data type Now let s look at some examples of how conditional COMPUTE statements can help with report logic Using COMPUTEs to Reformat the Completion Code In an earlier report in Figure 3 page 15 we showed the system completion code SMF30SCC from the SMF 30 subtype 5 records In that report we simply displayed the completion code in hex 36 Spectrum SMF Writer Tutorial Lesson 7 Conditional COMPUTE Statements These Control Statements INPUT SMF30 COMPUTE ABEND BIT SUBSTR FORMAT SMF30STI BITS 7 1 COMPUTE CC HEX FORMAT SMF30SCC HEX COMPUTE SUBSTR CC HEX 1 1 COMPUTE CC DROP 8 SMF30SCC 32768 BIN VALUE W O LEADING X 8 COMPUTE COMP CODE WHEN SMF30SCC ASSIGN WHEN ABEND BIT 1 ASSIGN FORMAT
142. field in the input file as well as any COMPUTE field You are not limited to just the fields that are listed in the COLUMNS statement You may also put a trailing EQUAL parm after all of the sort fields That parm causes tie records to remain in their original relative order 42 Spectrum SMF Writer Tutorial Lesson 8 How to Specify the Sort Order and Control Breaks These Control Statements INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMFIARTY 14 SELECT JUST TYPE 14 RECORDS COMPUTE SMF14 JOBID SMF14JBN MAKE UNIQUE JOB ID TO SORT ON FORMAT SMF14RSD FORMAT SMF14RST COLUMNS SMF14 JOBID JOBNAME AND READER SMF14DTE SMF LOG DATE SMF14TME SMF LOG TIME SMF14PGN PROGRAM NAME SMF14TIOE5 DDNAME SMF14_JFCBDSNM DSNAME 25 SMF14 JFCLRECL LRECL 7 BIZ NOACCUM SMF14EXCP EXCP COUNT FOR DDNAME 9 SMF14 JOBID SMF14EXCP D SMF14 REPORT SORTED BY JOB AND DESCENDING EXCP COUNT Produce this Report SMF14 REPORT SORTED BY JOB AND DESCENDING EXCP COUNT SMF SMF 106 106 PROGRAM JOBNAME AND READER TIMESTAMP DA TIME NAME DSNAME PXPRECP 5 500001 SYS1 5 500004 PXPRECP 5 500001 SYS1 5 500004 PPARMS ANDARD PPARMS ANDARD SYSUP 07 24 09 11 31 00 39 07 24 31 00 47 B C SYSUP 07 24 09 11 31 00 39 07 24 31 00 50 B 5 SYSUP 07 24 09 11 31 05 00 07 24 31 05 10 B C SYSUP 07 24 09 11
143. h IFCID 3 accounting trace records We further select on the value in the DB2PLAN field to get just the trace records for the plan we are interested in We then print a report showing various data fields from the SMF 101 records for that plan We leave the report in SMF log time order These Control Statements INPUT SMF101V9 INC SMIOIRTY 101 AND QWHSIID 3 IFCID 003 AND QWHCPLAN MAJSERVR COL 5 1010 5 101 QWHCCV CORRELATION QWHCCN CONNECTION QWHCPLAN DB2PLAN QWHCOPID OPERATOR ID QWHDRQNM REQUESTOR LOCATION QWHADSGN SHARING GROUP QWHAMEMN MEMBER NAME TITLE DB2 ACCOUNTING INFO FOR DB2PLAN MAJSERVR DATE TIME Produce this Report DB2 ACCOUNTING INFO FOR DB2PLAN MAJSERVR 07 21 09 9 23 AM OPERATO REQUESTOR SHARING MEMBER SM101DTE 5 101 CORRELATION CONNECTION DB2PLAN ID LOCATION GROUP NAME 09 23 08 10 40 03 28 db2trbWebSph SERVER MAJSERVR SETUP 92 168 43 100 DSN9KJ DBT4 09 23 08 10 40 05 26 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 13 65 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 14 98 db2trbNon de SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 20 91 db2trbWebSph SERVER MAJSERVR SETUP 92 168 24 30 DSN9KJ DBT4 09 23 08 10 40 21 99 db2trbNon de SERVER MAJSERVR SETUP 92 168 43 100 DSN9KJ DBT4 09 23 08 10 40 25 47 db2trbWebSph SERVER MAJSERVR SET
144. h product We have report both the TCB and SRB times in two ways as the number of seconds as they appear in the record And again after converting the seconds into standard hour minute and second notation Spectrum SMF Writer makes this easy with its powerful built in time handling functions These Control Statements INPUT SMF89 INCLUDEIF SMF89RTY 89 AND SMF89STP 1 COMPUTE COMPUTE SRB TIME SMF89UCT MAKET IME SMF89USR COLUMNS SMFB89SYN 5 5 SMF89UST INTERVAL START SMF89UET INTERVAL END TIME SMF89UPN PRODUCT SMF89UCT TCB TIME SECONDS 12 TCB_TIME TCB TIME SMF89USR SRB TIME SECONDS 12 SRB_TIME SRB TIME SORT SMF89SPN SMF89SYN SMF89UPN SMF89UST BREAK SMF89UPN SPACE 1 TITLE SMF 89 RACF INITIALIZATION TITLE SUBTYPE 1 INTERVAL STATS FOR SMF89SPN ON SMF89USD Produce this Report SMF 89 RACF INITIALIZATION SUBTYPE 1 INTERVAL STATS FOR ZPACPLX2 ON 11 02 07 MVS INTERVAL INTERVAL TCB SRB SYSTEM START END PRODUCT TIME TCB TIME SRB NAME TIME TIME NAME SECONDS TIME SECONDS TIME SYSZ1 11 00 00 00 12 00 00 00 2 05 5 342 00 01 29 02 00 305 00 00 05 05 00 SYSZ1 12 00 00 00 13 00 00 00 2 05 3 955 00 01 05 55 00 343 00 00 05 43 00 TOTAL FOR 2 05 2 ITEMS 9 297 00 02 34 57 00 648 00 00 10 48 00 SYSZ1 11 00 00 00 12 00 00 00 MQM MVS ESA 69 00 00 01 0
145. hange the field s definition in the copy library Just locate the correct FIELD statement and add a TYPE parm that specifies one of the dozens of Date Data Types listed in Appendix A of the Reference Manual Then you will be able to test that field using date literals And the field will also be formatted correctly as a date in the report output Time Literals Time literals should be in 24 hour HH MM or HH MM SS DDD format Comparing Times Once again you do not need to be concerned with exactly how a time or interval field is stored in the SMF record As long as the field is defined as a true time field Spectrum SMF Writer automatically handles all required conversions for you So whether a field is stored in the record as packed seconds since midnight character HHMM an 8 byte STCK time or binary microseconds since midnight to name a few examples you always write your comparison times in HH MM SS format For example even though the SMF14TME field is stored in the SMF record as hundredths of a second since midnight you will test it like this INCLUDEIF SMF14RTY 14 AND SMF14DTE 9 1 2010 AND SMF14TME gt 13 00 AND lt 14 00 Again if a time field has accidentally been defined as a regular character or numeric fields then you will need to compare it with a character or numeric literal of the same format Or you can locate the correct FIELD statement in the copy library and add a TYPE parm that specifies one of the dozen
146. hapter 10 Control Statement Syntax page 506 Spectrum SMF Writer Tutorial 35 Lesson 7 Conditional COMPUTE Statements This lesson teaches you how to perform complex logic by using COMPUTE statements with conditional parms We will even show how conditional COMPUTE statements help you report on data from different types of SMF records in a single report The control statement discussed is e the WHEN ASSIGN and ELSE parms of the COMPUTE statement The previous lesson explained how to write simple COMPUTE statements But it is also possible to use conditional logic in a COMPUTE statement In conditional COMPUTE statements one of multiple different expressions will be used to assign a value to the new field The expression that is used will depend on one or more conditions that you specify Conditional COMPUTE statements can be very powerful tools in producing reports Tip remember this construction well It will come in handy for many different applications Sometimes we are asked why Spectrum SMF Writer has no IF statement and how to get around that And often the answer to the question is to use this if type logic within a COMPUTE statement Conditional COMPUTE Syntax The conditional COMPUTE statement has this syntax COMPUTE fieldname HEN conditional expression ASSIGN computational expression W WHEN conditional expression ASSIGN computational expression WHEN conditional expression ASSIGN computational expr
147. he following section A few very unusual sections must be handled by special built in exits in Spectrum SMF Writer One example is in the SMF 102 record The sections in that record all have variable length so there is no triplet that specifies a fixed segment length to use for them For the 102 records Spectrum SMF Writer has a special built in exit to normalize these You will use an IOEXIT parm on the INPUT statement to normalize these sections See the example on page 86 in Appendix B of this document The record definition in your Spectrum SMF Writer copy library will always tells you how to normalize a particular section whether it is with the standard NORMSMF parm or a NORMALIZE or IOEXIT parm The NORMALIZE parm For most sections that do not used standard triplets you will be able to normalize them using the NORMALIZE or just NORM parm Like NORMSMF it is normally used in conjunction with a preceding NORMWHEN parm Spectrum SMF Writer Tutorial 17 Lesson 3 How to Report on Multiple Occurrences of a Section These Control Statements INPUT SMF30 COPY SMF 30 RECORD DEF NORMWHEN SMF30RTY 30 AND SMF30STP 5 NORMSMF SMF30E0F INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT 30 SUBTYPE 5 COLUMNS SMF30DTE SMF30TME SMF30RTY SMF30STP SMF30JBN SMF30INP SMF30SCC HEX SMF30DDN SMF30BLK SMF30BSZ Produce this Report FRI 03 05 10 11 37 AM DATA FROM SMF30 PAGE SMF30DTE SMF30TME SMF3ORTY
148. isplay format to change the way data is formatted in a report use override column headings to change the column headings in a report specify a column width to change the width of a column in a report use the BIZ parm to blank out zero values use the ACCUM or NOACCUM parms to specify which columns to show totals for each of these overrides should be put in parentheses after the appropriate field name you can specify multiple overrides for a field all within the same parentheses use the FORMAT option to change the default display format for all fields in a report several options exist to help format reports using international conventions The next lesson will teach you how to create your own new fields to use in your report To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn how to left justify center or right justify data within its column page 146 how to blank out repeating values in a column page 144 how to change the spacing between columns in a report page 128 the complete syntax for the COLUMNS statement Chapter 10 Control Statement Syntax page 498 30 Spectrum SMF Writer Tutorial Lesson 6 How to Create Your Own Fields This lesson teaches you how to create your own fields to use in a report The control statement discussed is e the COMPUTE statement Sometimes the data you need for a report is not in th
149. lly any PC spreadsheet data base or word processing program You can use this option to turn virtually any report into a PC export file The INPUT statement identifies the SMF record that contains the data that you want to put into your PC file The INCLUDEIF statement tells which records from the input file to include in your PC export file The COLUMNS statement specifies what columns of data you want in the PC spreadsheet Here you name the individual fields from the input file that you want to populate the columns of the spreadsheet With just these four statements we ve given Spectrum SMF Writer everything it needs to turn your selected SMF data into a PC file That s all there is to creating custom PC files with Spectrum SMF Writer Four simple statements let you accomplish what would otherwise have taken an entire COBOL program to do Spectrum SMF Writer Tutorial 9 Lesson 2 How to Export SMF Data to PC Programs These Control Statements OPTION PC MAKE A PC FILE INSTEAD OF A REPORT INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS e INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS s7 COLUMNS SMF14DTE SMF14TME SMF14JBN SMF14PGN SMF14TIOE5 SMF14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP Produced this PC File wa n non won nou nSMF14 SMF14 SMFIA4DTE SMF14TME SHF14JBN SMF14PGN SMF14TIOE5 JECBDSNM JFCLRECL SMF14EXCP 11 02 09 12 20 15 43 DUMPSMF IFASMFDP SYS
150. meric fields creating your own 31 formatting in report 25 NZAVERAGE NZAVG parm in BREAK statement 51 NZMINIMUM NZMIN parm in BREAK statement 51 Object ID expanding to object name 86 OFFSET parm in FIELD statement 13 Open datasets opened 38 Operations character how to perform 34 OPTIONS statement options used in every run 29 104 Spectrum SMF Writer Tutorial OR in conditional expressions 57 Order of BREAK statememts 48 of report how to specify 42 Output datasets opened for 38 Overriding column headings 26 column width 28 display format 25 P Page breaks 46 79 PAGE PAGE1 parm in BREAK statement 46 Page number in titles 23 Page space ID expanding to name 86 Parentheses use in computational expressions 31 PC exporting data to 9 PC parm in OPTION statement 9 Percentages computing 50 53 Performance CICS performance report 88 Period as thousands separator 26 PICTURE display format 26 Plan DB2 85 Plus sign concatenation symbol 34 Pool buffer pool report 92 Pound sign meaning of 22 Priority of operations in computational expressions 31 QPST section sample report 92 Quotation marks use in TITLE statement 22 QWSB sections sample report 84 RACF event report 81 usage statistics 82 Ratios computing 50 53 Record count in total lines 6 Records defining 6 Reformatting data in report 25 Remote IP FTP transfer re
151. miter used 12 quote character used 12 SMF data to PC 9 102 Spectrum SMF Writer Tutorial Extents reporting 78 Fields bit 8 creating your own 31 listing of fields in input file 6 Files defining 3 5 6 specifying the input file 3 Footing for control groups 51 FOOTING parm in BREAK statement 51 Formatting data in report 25 European conventions 29 FTP transfer report 97 Grand Totals 56 default 6 Grouping computations 31 H HEADING parm in BREAK statement 51 Headings for control groups 51 Headings see also Column Headings 26 Hex displaying data as hex 26 36 Hierarchical reports 53 reducing I O time 11 If logic 36 IFC destination report 84 INCLUDEIF statement 5 for multiple reports 11 which fields allowed in 5 INPUT statement 3 13 stop reading early 8 International formatting conventions 29 IOEXIT parm in INPUT statement 17 IP formatting 95 Item count in total lines 6 J2EE report 98 Java CPU time report 98 java bean 98 JCL DD for output 11 SWOPTION DD 29 Jobname 23 Julian dates 58 Justification of titles left center and right 23 Left alignment of titles 23 Length variable sections with 17 Limiting records read from input file 8 Lines multiple report lines per record 8 Listing of fields in a file 6 Literals in report body 8 in titles 22 rules for writing 57 Index Local IP FTP transfer report 97 Logical input records 16 Logical operations 5
152. n only concatenate character fields The FORMAT function formats the date value in SMF14RSD into a MM DD YY character field Similarly we formatted the SMF30RST time field into a HH MM SS DD character field 34 Spectrum SMF Writer Tutorial Summary To Learn More Lesson 6 How to Create Your Own Fields We also inserted blanks between these SMF fields to make the result more readable in case we want to print it in the report Here is one more example of using built in fields to easily extract data that would take quite few steps in a procedural language We use the REPLACE and PARSE functions to extract just the first node of the DSNAME field from the SMF 14 record COMPUTE FIRST NODE PARSE REPLACE SMF14 JFCBDSNM 7 1 Here is a summary of what we learned in this lesson e the COMPUTE statement is used to create new fields e a simple COMPUTE statement assigns the result of a single computational expression to a new field The next lesson will introduce a more complex form of the COMPUTE statement The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn e about many powerful built in functions available the COMPUTE statement listed in Appendix D Built In Functions page 628 how to specify the number of decimal places a numeric or time field should contain page 511 e the complete syntax for the COMPUTE statement in C
153. ne between jobs These Control Statements INPUT 5 14 INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS COLUMNS SMF14 JOBID JOBNAME READER TIMESTAMP 26 SMF14SPN STEPNAME SMF14PGN PGMNAME SMF1ATIOES DDNAME SMF14 JFCBDSNM DATASET NAME 16 SHORTEN FOR SPACE SMFI4EXCP EXCP COUNT 6 SMF14 CRDT CREATION DATE SMF14 JFCLRECL LRECL 6 SMF14 JFCBLKSI BLKSIZE 7 SMF14 JFCBVOLS 1 VOLSER 8 SMF14MCN SMS MGMT CLASS SMF14SCN SMS STOR CLASS SORT 5 14 90810 BREAK 5 14 JOBID 5 2 NOTOTALS TITLE DATE DATA SET USAGE BY JOBNAME PAGE PAGENUM Produce this Report 08 08 07 DATA SET USAGE BY JOBNAME PAGE 1 CREATION SMS MGMT SMS STOR JOBNAME READER TIMESTAMP 5 PGMNAME DDNAME DATASET NAME COUNT DATE LRECL BLKSIZE VOLSER CLASS CLASS BALCOMB 08 02 07 07 41 39 BTPRMF52 IKJEFTO1 SYSPROC SYS1 TSO CLIST N 0 04 08 03 80 27 920 KRJSTC BALCOMB 08 02 07 07 41 39 BTPRMF52 IKJEFTO1 SYSPROC SYS1 TSO CLIST N 0 04 08 03 80 27 920 KRJSTC BALCOMB 08 02 07 07 41 39 BTPRMF52 IKJEFTO1 SYSPROC SYS1 TSO CLIST N 0 04 08 03 80 27 920 KRJSTC BALCOMB 08 02 07 07 41 39 BTPRMF52 IKJEFTO1 SYSEXEC TSP SISPEXEC 0 09 8 06 80 27 920 TIMPCO BALCOMB 08 02 07 07 41 39 BTPRMF52 IKJEFTO1 SYSEXEC TSP SISPEXEC 0 09 8 06 80 27 920 TIMPCO BALCOMB 08 02 07 07 41 39 BTPRMF52 IKJEFTO1 SYS
154. nibble of last digit PIC ZZ9 9 User specified picture similar to COBOL s PIC DOLLAR 123 45 with floating dollar sign 1234ABCD shows raw data hex format ny BITS 00010011 shows each bit in the raw data When no display format has been specified by the user as in most of the earlier examples in this tutorial Spectrum SMF Writer uses a default display format To specify your own format just put the name of a display format in parentheses immediately after the field name in your control statement Do not leave a space between the field name and the open parenthesis Display formats are allowed in COLUMNS TITLE and other statements that produce report output For example TITLE DAILY SMF ABSTRACT FOR DATE LONG1 COLUMNS SMF30DTE SHORT3 EXCP CHARGE DOLLAR The display formats within parentheses after the field names above specify how the fields will be formatted in the report Figure 5 shows a report that uses display formats Specifying Column Headings Another way to improve your report is by providing your own column headings You remember that Spectrum SMF Writer uses the field name itself as the default column heading And most field names in the SMF files are not exactly self explanatory To specify your own column heading just place the desired heading text in parentheses after the field name in the COLUMNS statement To
155. nt and so on Note When creating additional outputs in a run your JCL will need a new DD for each additional output In this example you need a new SWOUTO002 DD to write the PC export file to The new DD s are numbered sequentially after that SWOUTOOS8 etc Spectrum SMF Writer Tutorial 11 Lesson 2 How to Export SMF Data to PC Programs Summary Here is a summary of what we learned in this lesson e just add OPTION PC to turn a report into a PC export file an INCLUDEIF statement is used to tell Spectrum SMF Writer which records from the input file to include in the report use a NEWOUT statement to begin describing a different report or PC file from the same input file The next lesson will teach you how to process SMF records that sections which occur more than once in the same record To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn e how to make tab delimited rather than comma delimited export files see the COLSPACE parm in the OPTION statement e how to specify the format to use for dates the export file see the FORMAT parm in the OPTION statement e how to specify the quote character to be used in the export file see the QCHAR parm in the OPTION statement e how to write single line legend style column headings at the beginning of your export file with the HGCOLHDG option e read more about using th
156. o since the SMF744S ASQ 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 These Control Statements OPTION SCALEPICS ALLOW VARIABLY SCALED PICTURES INPUT SMF74 NORMWHEN SMF74RTY 74 AND SMF74STY 4 NORMSMF SMF744S0 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 29 999 INTERVAL LENGTH SMF744SSIZ 8 STRUCT SIZE BIZ SMF744SARC VAL TOTAL ASYNCH OPERS 8 BIZ SMF744SASQ 0 5065 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 SMF744S
157. o customize your control breaks The control statement discussed is e the AVERAGE MAXIMUM and MINIMUM statistical parms of the BREAK statement e the HEADING and FOOTING parms of the BREAK statement How to Print Statistics at a Control Break You may want to print other statistics in addition to totals at a control break The total line as we have seen prints automatically at control breaks By supplying the appropriate parm in the BREAK statement you can also print up to five additional statistical lines at a control break These parms are listed in the following table Parm Description AVERAGE AVG Average value mean NZAVERAGE NZAVG Average of only the non zero values MAXIMUM MAX Maximum value MINIMUM MIN Minimum value NZMINIMUM NZMIN Non zero minimum value You can specify as many of these parms as you like in the BREAK statement The parms may be specified in any order The statistic lines in the report however always print in a standard fixed order For example BREAK SMF14 JOBID AVERAGE MAXIMUM The BREAK statement above requests that an average line and a maximum line print in addition to the totals line whenever the contents of the SMF14 JOBID field changes The report in Figure 13 uses the above statement Customized Break Heading and Footing Lines In addition to the totals line and other statistics lines discussed above you can also print your own custom lines at the
158. ords used in a given report The INCLUDEIF statement tells Spectrum SMF Writer to include a record in the report only if one or more conditions are met In Figure 1 page 4 we included records in the report if the record type field was equal to 14 So that report includes every type 14 record from the input file Most of your reports will consist of data from only one type of SMF record And often you will want to limit the records that appear in your report even further You do this by specifying more than one condition or test in the INCLUDEIF statement Consider these statements INPUT SMF30 COPY SMF30 RECORD DEFINITIONS INCLUDEIF SMF3ORTY 30 AND SMF30STY 5 SELECT SMF 30 SUBTYPE 5 RECS The above statements select just the type 30 with a subtype of 5 for the report Subtype 5 records are written at job termination time so those a good source of job accounting information We will use the above statements in some later examples The INCLUDEIF statement may appear anywhere after the INPUT statement Only one INCLUDEIF statement is allowed per report but it may contain as many conditions as you like By the way the INCLUDEIF statement may refer to any of the fields defined for the input file as well as any COMPUTE field You are not limited to just those fields that are listed in the COLUMNS statement for example Note If your INCLUDEIF expression is too big to fit on a single line end the first
159. otal elapsed run time There is no field in the SMF 30 record that contains the elapsed time However we can compute it by calculating the difference between two time of day fields that are present in SMF 30 subtype 5 records SMF30SIT is the time of day that the initiator selected the job And SMF30TME is the time that SMF logged the termination of the job Spectrum SMF Writer Tutorial 33 Lesson 6 How to Create Your Own Fields So it might seem tempting to just compute the elapsed time like this COMPUTE JOB ELAPSED TIME SMF30TME SMF30SIT However this simple method has an obvious drawback It won t work if the job runs past midnight and ends on the next day The time difference will be negative The correct way to compute this elapsed time is to also take into account the dates when the job began and ended The job initiation date is in SMF30STD And the SMF log date is in SMF30DTE Now armed with these four fields Spectrum SMF Writer s powerful built in functions make the calculation easy COMPUTE JOB ELAPSED SECONDS MAKENUM SMF30DTE 86400 MAKENUM SMF30TME MAKENUM SMF30STD 86400 MAKENUM SMF30SIT The statement above creates a field that contains the number of elapsed seconds that a job ran It does this by converting both the start date time and the end date time into their total number of seconds since the beginning of the nineteenth century and then subtracting the starting value from the ending v
160. our Own Report Titles 22 How to Use the TITLE 0 22 Adding the Date and Page Number to your 22 How to Alien the Title hua WOR e ete el eas 23 Lesson 5 Improving the Appearance of your 25 Using Display Forimats a yay Mee ob RAD abe Eos Rede lese dee 25 Specifying Column 1 471 2 26 Specifying a Columns 1 28 The Blank If Zero Parla sy sv Mek ERRARE OR deme e Aet 28 Which Columns Are 4 28 Formatting Features for International 29 Lesson 6 How to Create Your Own Fields 31 Creatine Numeric Picldsi 3 o sas Rv oet Rc ec RN E Re md ur ER LE duse 31 Creatine Time Pields ostii du LA husk Ep ANON 33 Creating Character Fields ise ulcere Re RR xe bee EYE 34 Lesson 7 Conditional COMPUTE Statements 36 Using COMPUTEs to Reformat the Completion
161. port 97 Reports multiple 11 Response time example 77 Right alignment of titles 23 RMF records sample report 19 53 S Seconds including or omitting in times 25 Sections in SMF records nested 13 19 variable length 17 within SMF records 13 Selecting by subtype 5 fields for report 5 records for the report 3 5 Server SFTP transfer report 95 Servlet WebContainer servlet report 99 Index SHOWFLDS parm in INPUT statement 6 Sign in last byte of data 26 Size of column changing 28 Skipping to new page in report 46 Slash division symbol 31 used to align titles 23 Smaller making a column smaller 28 SMF 100 record sample report 84 SMF 101 record sample report 85 SMF 102 record sample report 17 86 SMF 110 record sample report 88 89 SMF 115 record sample report 92 SMF 116 record sample report 93 SMF 119 record sample report 94 97 SMF 120 record sample report 17 98 99 SMF 14 record sample report 4 10 47 49 52 62 SMF 15 record sample report 38 39 SMF 17 record sample report 38 39 SMF 30 record completion code 36 37 computing elapsed time 33 EXCP section 15 18 sample report 15 18 36 37 63 67 68 70 74 SMF 42 record sample report 77 SMF 5 record sample report 60 SMF 64 record sample report 78 SMF 70 record sample report 17 19 53 54 55 SMF 80 record sample report 81 SMF 89 record sample report 82 Spectrum SMF Writer Tutorial 105 Index SMF 94 record sampl
162. print at control breaks can contain a statistical value of a field such as total average maximum etc To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn e how to suppress the total line at a control break page 185 e how to compute percentages and ratios that apply to an entire control group page 202 e how customize the Grand Totals at the end of the report page 207 e the complete syntax for the BREAK statement in Chapter 10 Control Statement Syntax page 481 56 Spectrum SMF Writer Tutorial Appendix Conditional Expressions Appendix A Conditional Expressions The complete rules for conditional expressions are discussed in Conditional Expressions page 459 in the full Reference Manual It is generally the same as for such languages as BASIC COBOL etc Below is a summary of the main syntax points Comparators and Logical Connectors The following conditional operators are supported lt gt gt and or lt gt Spectrum SMF Writer also has the special operators contains and does not contain that scan a field for the specified text Your expression can contain any number of conditions separated with the words AND and OR optionally preceded by NOT nested as needed within parentheses You can also use the symbols amp and Note The colon comparison operator is a special
163. psed time in HH MM SS format With Spectrum SMF Writer s flexibility you have lots of options In the first report we simply sort and break on the SMF30WID field from the SMF 30 subtype 5 records SMF30WID contains a 4 byte Work Type Identifier By breaking on this field the report shows us the count of tasks for each category of work Started Tasks TSO Sessions etc It also shows the total elapsed time for each category Note that the sample report below used a very small test file of SMF records The second report is very similar to the first one But in this case instead of using the SMF30WID field to categorize tasks we created our own WORK TYPE field We assigned values to it based on the contents of the Jobname SMF30JBN and the SMF30WID fields Note that Spectrum SMF Writer has a very powerful comparison operator that other languages do not have the colon The colon comparator means contains For example we assign CICS REGIONS to WORK TYPE if the jobname contains the characters CICS somewhere within it The third report is just like the second report but with an OPTION SUMMARY statement added That makes it a summary report showing only the total lines All of the detail lines are suppressed That is an option you would probably want if you ran this job on whole month s worth of SMF data These Control Statements KKK KKK KK KK KKK KK KKK KKK KKK KK ko ee KKK ek ee ek ee eee eee SPECIFY THE INPUT FILE
164. pt for one thing each one contains a different value in the SMF30EOF field Spectrum SMF Writer increments that offset field s value in each logical record so that it points to the next occurrence of the EXCP section Since all of the fields within the EXCP section are defined relative to the offset contained in the SMF30EOF field a different set of EXCP fields is addressed in each logical record Let s examine the processing step by step The unchanged physical record is first processed once as is That is the inclusion tests if any are performed on the unchanged physical record If selected the data from this record is used to make a line in the report Next a new logical record is created by just incrementing the value of the triplet s offset field in the original physical record As a result the offset field now contains the offset from the beginning of the record to the second occurrence of the section Since all of the fields within the EXCP section are defined relative to the offset contained in the SMF30EOF field a different set of EXCP fields is processed in this logical record the EXCP fields from the second occurance of ths section This new logical record is then processed as if it were a new record from the physical input file Inclusion tests are performed If selected the data from the record now addressing the second occurrence of the section is used to make a report line in the report Then the offset field is increm
165. r each Java bean method accounting section found The report shows CPU time information for those Java bean methods Note that a single SMF 120 record can contain information about multiple beans and each bean can have multiple methods These Control Statements INPUT SMF12005 INCLUDEIF SMF120RTY 120 AND SMF120RST 5 TITLE Z OS WEBSPHERE APPLICATION SMF 120 DATA TITLE SUBTYPE 5 J2EE CONTAINER ACTIVITY COL SMF120RST 3 SUB TYP SMF120JA4 5 TRANS SERVER HOST SMF120JA5 6 TRANS SERVER NAME SMF120JA8 EBC 8 CONTAINER NAME SMF120CL2 CELL SMF120ND2 NODE SMF120JB1_EBC 10 BEAN NAME SMF120JM1_EBC 25 BEAN METHOD SMF120JM2 5 TIMES INVOK SMF120JM3 AVG RSP TIME TPIC 9 999 SMF120JMA MAX RSP TIME TPIC 9 999 SMF120JMQ AVG CPU TIME TPIC 9 999999 SMF120JMR MIN CPU TIME TPIC 9 999999 SMF120JMS MAX CPU TIME TPIC 9 999999 Produce this Report 7 05 WEBSPHERE APPLICATION SMF 120 DATA SUBTYPE 5 J2EE CONTAINER ACTIVITY TRANS TRANS AVG MAX AVG MIN MAX SUB SERVE SERVER CONTAINE BEAN BEAN TIMES RSP RSP CPU CPU CPU TYP HOST NAME NAME CELE NODE NAME METHOD INVOK TIME TIME TIME TIME TIME 5 AWT4 7451 Default 74 AXZ44 Tonam Inf invoke java lang String j 1 0 014 0 014 0 013665 0 013665 0 013665 5 AWT4 AXZ4S1 Default AXZ4 AXZ44 Tonam Inf invoke java lang String j 1 0 020 0 020 0 006287 0 006287 0 006287 5 AWT4 AXZ4S1 Default 74 AXZ44 Tonam Inf login java lang String ja 1
166. riter Tutorial 89 Appendix B Examples of SMF Reports Produce this Report SMF 110 SUBTYPE 1 CICS MONITORING DATA TRANSACTION TIMING INFORMATION SORTED BY CICS TRANSACTION AND CICS REGION SMF SMF 106 106 CICS SMF110S1 SMF110S1 ELAPSED DISPATCH CPU SUSPEND DATE TIME TRAN JOBNAME START STOP TIME TIME TIME TIME 12 30 09 00 34 27 CICSVIBK 23 19 26 698238 23 34 26 901300 15 00 203 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 22 54 CISE CICSVATM 23 22 54 054290 23 52 54 197499 30 00 143 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 00 50 53 CISE CICSVCTG 00 05 52 764595 00 35 52 645543 29 59 881 00 00 00 000000 00 00 00 000000 00 29 59 8809 12 29 09 23 53 29 CISM CICLUTIN 23 08 28 457983 23 23 28 657409 15 00 199 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 29 09 23 45 38 CISM CICSVWLK 22 45 37 704110 23 15 37 584835 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 01 20 53 CISR CICSVCTG 00 35 52 645252 00 50 52 851959 15 00 207 00 00 00 000000 00 00 00 000000 00 15 00 2067 12 30 09 00 21 06 CKTI CICSEAI 23 06 06 372819 23 36 06 254236 29 59 881 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 29 09 23 52 54 COIE CICSVATM 22 52 54 177421 23 22 54 054167 29 59 877 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 30 09 01 30 38 COIE CICSVWLK 00 45 37 488736 01 00 37 691469 15 00 202 00 00 00 000000 00 00 00 000000 00 00 00 0000 12 29 09 23 52 52 COIO CICSVTIN 23 20 32 758513 23 50 32 901407 3
167. rol statements that follow 2 it also sets this newly defined SMF 14 file as the primary and in this case only input file for this report Basic Syntax Rules Spectrum SMF Writer control statements begin in column 1 with the name of the statement for example INPUT followed immediately by a colon What follows next will depend on the particular control statement For an INPUT statement you simply put the name of the SMF file to use for the report Spectrum SMF Writer Tutorial 3 Lesson 1 How to Make SMF Report 5 Minutes These Control Statements INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMFIARTY 14 SELECT JUST TYPE 14 RECORDS A COLUMNS SMF14DTE SMF14TME SMF14JBN SMF14PGN SMF14TIOE5 SMF14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP Produce this Report FRI 02 05 10 10 18 DATA FROM SMF14 PAGE SMF14 SMF14 SMF14DTE SMF14TME SMF14JBN SMF14PGN 5 14 0 5 JFCBDSNM JFCLRECL SMF14EXCP 11 02 09 20 15 DUMPSMF IFASMFDP USER PROCLIB 11 02 09 20 21 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 11 02 09 20 21 PDSETST1 IKJEFTO1 15 23328 TESTCA PDSE TEST 11 02 09 20 21 ZP144405 IKJEFTO1 SYSEXEC UAS REXX 11 02 09 20 21 7 144405 IKJEFTO1 STEPLIB DI10INFO2 LOAD 11 02 09 20 31 PDSETST1 IKJEFTO1 PDSESKEL UAS TAP JOBS 11 02 09 20 31 PDSETST1 IKJEFTO1 15 23329 TESTCA PDSE TEST 11 02 09 2 20 31 PDSETST1 IKJEFTO1 5 505619 TESTCA PDSE TEST 11 02 09 20 41 PDSETST1 IKJEFTO1 PDSESKEL U
168. rt on Multiple Occurrences of a Section The main idea to pick up here is that if the need arises you can report on all occurrences of nested recurring sections And the part that you do need to understand is very easy to NORMALIZE nested sections you simply add an additional NORMSMF or NORMALIZE parm to the INPUT statement INPUT SMF70 NORMWHEN SMF7ORTY 70 AND 5 705 1 NORMSMF SMF70BCS LPARS STANDARD TRIPLET NORMALIZE SMF70 PRSMLPD SECTION SMF70BDN 106 PROCS NON STANDARD Note we did not need to add an additional NORMWHEN parm The existing one applies to all NORMSMF and NORMALIZE parms that follow it With this INPUT statement Spectrum SMF Wiriter will process each physical SMF 70 subtype 1 record as a multiple number of logical records You might think of this as processing each element of a two dimensional array While the first occurrence of the outer section is processed each occurrence of the inner section is normalized to form its own logical record After that the second occurrence of the outer section is processed and all of the inner sections for it are normalized and so on Don t worry if you this seems a little complex to you It is complex And happily most SMF reports don t need such sophisticated logic But it s nice to know that Spectrum SMF Writer can handle it when the need does arise And all just by adding a line or two to your INPUT statement You can see a report example that uses
169. rts RACF Event Report from SMF 80 Records This example reads as input the SMF file and selects just the type 80 RACF Processing records We print a report showing each processing event with a description of what the event was and the outcome Note that the actual SMF record just contains codes for the event and its status The Spectrum SMF Writer definitions include code to expand those numeric values into descriptive texts You can see this code in member 80 of your Spectrum SMF copy library These events are grouped by unique JOB and printed in JOB timestamp order These Control Statements INPUT 5 80 INC SMF80RTY 80 COL SMFBODTE 5 80 SMF80JBN JOBNAME SMFBODES DESC FLAGS SMFBOEVT HEX EVENT CODE SMFBOEVQ HEX EVENT CODE QUAL SMF80 EVENT NAME 25 SMF80 EVENT QUAL DESC 16 SMFBOUSR USER SMFBOGRP GROUP SMFBOTRM TERMINAL SORT 5 80 JOBID BREAK SMF80 JOBID NOTOTALS SPACE 1 TITLE DATE TIME RACF EVENT LOG BY JOB PAGE PAGE Produce this Report 07 24 09 11 57 PM RACF EVENT LOG BY JOB PAGE 1 SMF80 EVENT SMF80 EVENT DESC EVENT CODE EVENT QUAL SMF80DTE 5 80 FLAGS CODE QUAL NAME DESC USER GROUP TERMINAL 07 24 06 11 37 33 62 NRPOA 2800 02 00 RESOURCE ACCESS Successful acces NRPOA SYS1 07 24 06 11 36 57 47 NRPOA 2800 02 00 RESOURCE ACCESS Successful acces NRPOA SYS1 07 24 06 11 40 28 69 STRT2 A800
170. s of Time Data Types listed in Appendix A of the Reference 58 Spectrum SMF Writer Tutorial Appendix Conditional Expressions Manual You may also need to add a DEC n parm to the FIELD statement if the time field contains decimal parts of a second Comparing a List of Values If you want to compare a field to a list of values you can use this shorthand format INCLUDEIF SMF14JBN ACCT1000 OR ACCT1100 OR ACCT1200 Or to exclude a list of values use this format INCLUDEIF SMF14JBN lt gt ACCT1000 AND ACCT1100 AND ACCT1200 Wildcard Comparisons Spectrum SMF Wiriter does not have an actual wildcard character in its syntax for performing comparisons However by applying a few tricks you can usually achieve the same result Here are some examples of doing wildcard like selections To select all dataset names starting with the characters PROD1 ABC like PROD1 ABC if was a wildcard character meaning any text of any length you could use this code COMPUTE SHORT DSN LEFT SMF14 JFCBDSNM 1 9 1ST 9 BYTES OF DSN INCLUDEIF SHORT DSN PRODI ABC TEST 1ST 9 BYTES OF DSN Or say you want to select any DSN containing the characters PAY anywhere within it equivalent to PAY Spectrum SMF Wiriter has a special comparison operator called contains It is the colon character The following INCLUDEIF statement would select any record that had the characters PAY anywhere within the 44 byte SMF14 JFCBD
171. search out exceptional situations To help make unusual values stand out in a report it is often help to show blanks for all 0 values Especially when the 0 value is 11 bytes long like 00 00 00 00 time interval which can really clutter a report To do that specify the BIZ parm in parentheses after the field name For example COLUMNS SMF30BLK EXCP BLOCK COUNT BIZ 6 The report in Figure 5 page 27 uses the BIZ parm shown above The report lines with a zero EXCP count now have blanks in that column allowing the non zero values to stand out Note in the example statement above we also specified override column headings and an override width This illustrates the fact that you can specify more than one override for a single field Their order within the parentheses is not important You can separate the overrides with spaces and or commas Which Columns Are Totalled You can also specify exactly which columns receive totals in your report By default all numeric fields are totalled However this is obviously not desirable for certain numeric fields such as LRECL record type etc To suppress totals for a particular numeric column specify the NOACCUM parm for that field That tells Spectrum SMF Writer not to accumulate it for printing in statistic lines of which the total line is the most common Some other statistic lines available are MAX MIN AVG and STDDEV The NOACCUM parm also applies to all of these You can also sp
172. ssed it can also occur a variable number of times It s no wonder that SMF records present a real headache to most report writers And especially to programmers coding their own COBOL or assembler programs to parse SMF records But this is precisely where Spectrum SMF Writer excels It has special functionality designed to handle even the most complicated SMF records And it makes this almost transparent to the end user you Most of the work involved in handling these situations has already been done for you right in the file definitions Feel free to browse the definitions in the copy library to see how we use OFFSET parms and conditional COMPUTE statements to determine whether a section exists in a given record and if so where it is located The Famous Triplets IBM uses what it calls triplets to unravel the layout of complicated SMF records A triplet is three fields which are usually at a fixed location within the SMF record But not always When dealing with nested sections those triplets are usually embedded within the Spectrum SMF Writer Tutorial 13 Lesson 3 How to Report on Multiple Occurrences of a Section parent section which must first be located using its own triplet The three fields in a triplet specify e the offset to the beginning of the first occurrence of the section e the length of each occurrence of the section e the number of times that the section appears in the SMF record This number may be
173. statements For each TITLE statement Spectrum SMF Writer prints one title line at the top of each page of the report The title lines print in the same order in which the TITLE statements occur TITLE statements may appear anywhere after the INPUT statement After the word TITLE and the colon enclosed your desired title text in either single or double quotation marks For example TITLE SPECTRUM SMF WRITER REPORT CPU TIMES Note If your title is too big to fit on a single line type right up to column 72 in the first line and then continue in column 2 of the next line Leave column 1 of the continuation line blank Adding the Date and Page Number to your Titles You can put more than one item on your TITLE statement And you can also put the contents of fields in your titles For example you will probably want to include the date and page number in your titles Do this by using the special built in fields named DATE and 4PAGENUM Don t let the pound sign scare you of Spectrum SMF Writer s built in field names begin with this character This is to distinguish them from fields in your own files that may have similar names The contents of the special built in fields DATE and PAGENUM are of course the system date and the current page number TITLE DATE SPECTRUM SMF WRITER REPORT CPU TIMES PAGE PAGENUM When using DATE and PAGENUM in your TITLE statement do not enclose them in quotation marks Anything en
174. t 23 Total line printing blank lines after 44 printing only the total lines in a report 46 Totals which columns are totalled 28 Transaction times CICS 89 Triplets 13 20 non standard 17 variable length 17 TSO sessions 63 Uptime report 60 User defined fields 31 V Variable length sections in SMF records 17 VSAM file activity report 78 WebContainer servlet report 99 Websphere J2EE report 98 Websphere MQ queue report 93 Week day of 23 WHEN parm in COMPUTE statement 36 Width of column changing 28 of report 8 Wildcard characters 59 Work Type Identifier 63 Z Zeros not suppressing leading zeros 26 printing blanks instead 28 Zone nibble sign 26 Spectrum SMF Writer Tutorial Index 107
175. t factor when working with such large files To produce a second or third etc output just add a NEWOUT statement to you request NEWOUT This statement should go after you have finished describing the first report that you want Everything after the NEWOUT statement applies only to the new report or export file INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS COLUMNS SMFI4DTE SMFI4TME SMF14JBN SMF14PGN SMF14TIOE5 SMF14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP NEWOUT OPTIONS PC THIS OUTPUT IS A PC FILE NOT A REPORT INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS COLUMNS SMF14DTE 5 14 SMF14JBN SMF14PGN SMF14TIOE5 5 14 JFCBDSNM SMF14 JFCLRECL SMF14EXCP The above control statements would produce the report in Figure 1 page 4 and the export file in Figure 2 page 10 in the same run Spectrum SMF Writer will only make a single pass through the SMF input file Notice that we do not specify another INPUT statement after the NEWOUT statement The same input file is always used for all of the outputs in a run But you are free to change everything else if you like In this example we used the same INCLUDEIF statement for both outputs We selected all type 14 records But the INCLUDEIF statements can be completely different if you like For example it could select a different type of SMF record The COLUMNS statement can also be differe
176. t the detailed session lines and see just one total line for each CICS region for the month A perfect executive level report Note that this report makes extensive use of Spectrum SMF Writer s many powerful date and time computational functions We use them to determine the begin and end dates of the previous calendar month to compute elapsed time from one date time to another date time and convert that to into hours and to calculate the exact number of hours in the previous month This report can run each month without requiring any manual changes to the control statements These Control Statements OPTION SUMMARY INPUT 5 05 COPIES FILE DEF STMTS AUTOMATICALLY INCLUDEIF SMF5RTY 5 AND SMF5JBN CICSP COMPUTE REPORT MONTH 9 1 2010 OVERRIDE MONTH BEGIN COMPUTE REPORT MONTH E 9 30 2010 OVERRIDE MONTH END COMPUTE REPORT MONTH BEGMONTH INCDATE 1 MONTHS BEG LAST MNTH COMPUTE REPORT MONTH E ENDMONTH INCDATE 1 MONTHS END LAST MNTH 60 Spectrum SMF Writer Tutorial Appendix B Examples of SMF Reports These Control Statements cont COMPUTE CICS START COMPUTE CICS END BEGMONTH SMF5RSD REC S START YYMMO1 BEGMONTH SMF5DTE REC S END 01 COMPUTE ELAPSED HOURS WHEN CICS START CICS END WITHIN MONTH ASSIGN 4MAKENUM SMF5DTE 86400 MAKENUM SMF5TME 3600 amp MAKENUM SMF5RSD 86400 MAKENUM SMF5RST 3600 WHEN CI
177. tement This report just shows the total EXCP count for each job Note if we intended to use this report as something more than a one shot job we would make some changes to improve its appearance We could remove some or all of the character columns since those fields are empty in the total lines But for this example we wanted to clearly demonstrate that any report that has a control break can easily be turned into a summary report just by adding one option to it 46 Spectrum SMF Writer Tutorial Lesson 8 How to Specify the Sort Order and Control Breaks These Control Statements OPTION SUMMARY INPUT SMF14 COPY SMF 14 RECORD DEFINITIONS INCLUDEIF SMF14RTY 14 SELECT JUST TYPE 14 RECORDS COMPUTE SMF14 JOBID SMF14JBN FORMAT SMF14RSD FORMAT SMF14RST COLUMNS SMF14 JOBID JOBNAME AND READER SMF14DTE SMF LOG DATE SMF14TME SMF LOG TIME SMF14PGN PROGRAM NAME SMF14TIOE5 DDNAME SMF14 JFCBDSNM DSNAME 25 SMF14 JFCLRECL LRECL 7 BIZ NOACCUM SMF14EXCP EXCP COUNT FOR DDNAME 9 SMF14 JOBID SMF14EXCP D SMF14 JOBID SMF14 EXCP REPORT SUMMARY REPORT BY JOB Produce this Report SMF14 EXCP REPORT SUMMARY REPORT BY JOB EXCP SMF SMF COUNT LOG 106 PROGRAM FOR JOBNAME AND READER TIMESTAMP DATE TIME NAME DDNAME DSNAME LRECL DDNAME FOR SYSUP 07 24 09 11 31 00 39 FOR SYSUP 07 24 09 11 31 05 00 FOR SYSUP 07 24 09 11 31 06 67 FOR USTTA
178. u as hour minutes and seconds right down to a millionth of a second We also compute the elapsed time by subtracting the stop time from the start time It s actually a bit more complicated than that We also took into account the start and stop dates in case the transaction spans midnight We also print the value found in the SMF records for CPU time dispatch time and suspend time These values are not filled in for all records Finally we sort the report by transaction name CICS name and date time We break and space 1 line between different transactions In this example we specified the break and break spacing directly in the SORT statement We did notuse a BREAK statement at all These Control Statements INPUT 5 11051 NORMWHEN SMF11ORTY 110 amp SMF110STY 1 amp 5 11051 MNCL 3 AND SMF110S1 MNRVN X 0660 CICS TS 4 1 NORMSMF SMF110S1 MNDRA INCLUDEIF SMF110RTY 110 AND SMF110STY 1 AND 5 11051 MNCL 3 COLUMNS SMF110DTE SMF LOG DATE SMF110TME SMF LOG TIME TP 99 99 99 SMF110S1_MNJBN CICS JOBNAME SMF110S1 TRAN TRAN 5 11051 START 5 11051 STOP SMF110S1 RESPONSE TIME 8 ELAPSED TIME SMF110S1 USRDISPT DISPATCH TIME SMF110S1 USRCPUT CPU TIME 5 11051 SUSPTIME SUSPEND TIME TITLE SMF 110 SUBTYPE 1 CICS MONITORING DATA TITLE TRANSACTION TIMING INFORMATION TITLE SORTED BY CICS TRANSACTION SORT SMF110S1 TRAN 1 NOTOTALS SMF110S1 MNJBN Spectrum SMF W
179. what we learned in this lesson e use the TITLE statement to specify your own titles for a report e if more than one TITLE statement is used the title lines print in the same order in which the TITLE statements appear use Spectrum SMF Writer s built in fields to include the date time day of the week and page number in your titles e puta field name in the TITLE statement to show that field s current value in the title of each page e use slashes to separate your title into left center and right aligned parts The next lesson will teach you how to customize the formatting of your report To Learn More The chapters and page numbers below refer to pages in the Spectrum Writer User s Guide and Reference Manual You can also learn e how to print footnotes at the bottom of each page of the report page 175 e the complete syntax for the TITLE statement in Chapter 10 Control Statement Syntax page 602 24 Spectrum SMF Writer Tutorial Lesson 5 Improving the Appearance of your Report This lesson teaches you how to specify your own formatting options for a report The formatting options discussed are Now display formats which determine how dates times and numbers are formatted column headings column widths the BIZ blank if zero parm the ACCUM NOACCUM parms for totalling or not totalling a column that your report contains the data that you need it is time to think about its appearance
180. xamples of SMF Reports Produce this Report STEP COMPLETION CODES FROM SMF 30 RECORDS SUBTYPE 4 SMF SMF HEX FORMATTED REC SUB STEP COMP COMP SMF30DTE SMF30TME TYPE TYPE JOBNAME NUM STEPNAME CODE CODE 02 03 08 1 42 30 4 SMFDUMPS 1 DUMP1 0000 02 03 08 1 46 30 4 SXFSTC 1 STEPI 0004 4 02 03 08 1 54 30 4 SXFSTC 1 STEPI 0004 4 02 03 08 1 56 30 1 SPFPROCE 0000 02 06 08 10 59 30 4 BPXAS 0 IEFPROC 0000 02 06 08 1 01 30 FTPSERVE 1 STEPI 0000 02 06 08 1 01 30 FTPSERVE 1 OMVSEX 0000 02 06 08 1 10 30 4 XAC99 1 STEPI 0004 4 02 06 08 1 11 30 1 STEP1 0000 02 06 08 1 13 30 4 XAC99 1 STEPI 0004 4 02 06 08 1 15 30 4 XAC99 1 STEPI 0004 4 02 06 08 1 19 30 4 XAC99 1 STEPI 0004 4 02 06 08 1 22 30 FTPSERVE 1 STEPI 0000 02 06 08 1 22 30 4 FTPSERVE 1 OMVSEX 0000 02 06 08 1 28 30 1 STEPI 0000 02 06 08 1 30 30 FTPSERVE 1 STEPI 0000 02 06 08 1 30 30 FTPSERVE 1 OMVSEX 0000 02 06 08 1 33 30 4 BPXAS 1 IEFPROC 0000 02 06 08 1 37 30 4 WMF30 1 STEPI 0004 4 02 06 08 1 41 30 4 WMF30 SEP 0004 4 02 06 08 1 46 30 4 99 1 STEPI 0004 4 02 06 08 1 47 30 1 STEPI 0000 02 06 08 1 49 30 4 XAC99 1 STEPI 0000 02 06 08 1 52 30 4 99 1 STEPI 0008 8 02 06 08 1 53 30 4 XAC99 1 STEPI 0000 02 06 08 1 59 30 4 FTPSERVE 1 STEPI 0000 02 06 08 1 59 30 FTPSERVE 1 OMVSEX 0000 02 06 08 12 01 30 4 TTAPOIA 1 STEPI 0000 02 06 08 2 14 30 4 FTPSERVE TOSTERI 0000 02 06 08
181. you can print a statistical value total average maximum etc of a field rather than just the value of that field from the last record in the control group You can do that by specifying one of the statistical parms in parentheses after the field name BREAK SMF14 JOBID FOOTING MAXIMUM EXCP COUNT WAS SMF14EXCP MAX The report in Figure 13 page 52 shows examples of some of these additional features Notice that by moving the long SMF14 JOBID field out of the COLUMNS statement and into a break heading line we opened up much more room for data in the actual report lines That is one good way to use break headings For a much more detailed discussion of customizing control breaks with these features see Chapter 4 Beyond the Basics Using Break Headings for Hierarchical Report Layouts Here is another example of using custom headings to produce a complex report In fact the result is so sophisticated that most people would not guess that it came from just a few lines of 4GL report writer code This sample report uses just the type 70 subtype 1 SMF records RMF Processor Activity These records have a complex layout Each record contains a variable number of LPAR sections one for each logical partition in the system Furthermore there are a variable number of logical processor sections for each of those LPAR sections However all of these logical processor sections are grouped together near the end of the SMF record not ph
182. ysically within each owning LPAR section Nevertheless Spectrum SMF Writer easily handles these records so you quickly create powerful reports from your RMF data We use nested NORMALIZE parms on the INPUT statement to process each logical processor that exists for each logical partition The NORMALIZE parm was discussed earlier in Lesson 3 How to Report on Multiple Occurrences of a Section page 13 report is sorted by LPAR name and then by logical processor address The report is formatted to reflect the hierarchical layout of the SMF 70 records We used the page titles to show information about the physical CPU since it is applies to all of the LPARs Then for each of the LPARs we print a header section containing ID information as well as capacity and MSU values Following that are the report lines for each of the logical processors for that LPAR On each processor line we show the percentage of the RMF reporting interval for which that processor was 1 online 2 waiting 3 effectively dispatched and 4 processor dispatched Note that the percentage fields used are not actually in the RMF record itself They are computed fields However they are included in the copy library along with the actual RMF record definitions That means that you can use the percent fields just like any other RMF field Spectrum SMF Writer Tutorial 53 Lesson 9 Customizing the Control Breaks These Control Statements OPTION STCKADJ
183. zero indicating that the section is not present at all in that record Reporting on Data from the First Occurrence of a Section Spectrum SMF Writer includes the definitions of the three triplet fields in its file definition in the copy library The file definitions also define the first occurrence of each field within the section governed by the triplet That means that no special action is required on your part to report on the data contained in the first and often only occurrence of any section Just name the fields on your COLUMNS statement or other statement just like any other field And there are actually many sections that do occur only one time For example the Subsystem and Identification sections in type 30 records always occur exactly once in every SMF 30 record Also the I O Activity Completion and Processor sections of SMF 30 records each occurs either once or not at all Consider these statements INPUT SMF30 COPY SMF 30 RECORD DEF INCLUDEIF SMF30RTY 30 AND SMF30STP 5 SELECT TYPE 30 SUBTYPE 5 COLUMNS SMF30DTE SMF30TME SMF30RTY SMF30STP SMF30JBN SMF30INP SMF30SCC HEX SMF30DDN SMF30BLK SMF30BSZ The above statements produce the report shown in Figure 3 That report uses just the SMF 30 records written at job termination time the subtype 5 records The report has columns for these items taken from various parts of the SMF 30 record e log date and time record type and subtype all from the standard S

How to Make an SMF Report.fm

Contents

Download Pdf Manuals

Related Search

Related Contents