The Record Selection extract allows you to create a small extract file containing only the types of SMF records of interest to you. The extract file can then be used as input to CICS PA, allowing for more efficient reporting. The Record Selection extract filters large SMF files, writing only SMF records that match specified criteria.
File Systems Confirm Options Help ------------------------------------------------------------------------------ Report Set - REPORTS1 Row 1 of 26 Command ===> ________________________________________________ Scroll ===> PAGE Description . . . Demonstration Report Set________ Enter "/" to select action. ___ ** Reports ** Active + ___ Options Yes + ___ Selection Criteria No - ___ Performance Reports Yes ___ List No ___ List Extended No ___ Summary Yes ___ Totals No ___ Wait Analysis No ___ Transaction Profiling No ___ Cross-System Work No ___ Transaction Group No ___ BTS No ___ Workload Activity No ___ Transaction Tracking List No ___ Transaction Tracking Summary No + ___ Exception Reports No + ___ Transaction Resource Usage Reports No + ___ Statistics Reports No + ___ Subsystem Reports No + ___ System Reports No + ___ Performance Graphs No - ___ Extracts Yes ___ Cross-System Work No ___ Performance No S__ Record Selection Yes ___ HDB Load No ___ System Logger No ___ Statistics No ** End of Reports **
File Systems Options Help ------------------------------------------------------------------------------ REPORTS1 - Record Selection Extract Command ===> _________________________________________________________________ System Selection: CICS APPLID . . ________ + Image . . ________ + Group . . ________ + DB2 SSID . . . ____ + Image . . ________ + Group . . ________ + MQ SSID . . . . ____ + Image . . ________ + Group . . ________ + Logger . . . . ________ + Image . . ________ + Group . . ________ + Required Record Types: Extract Recap: / Performance / Exception DDname . . . RSEL0001 / Resource / Statistics / OMEGAMON / DB2 / WebSphere MQ / System Logger / Identity Output Data Set: Data Set Name . . 'GSG.RECSEL.EXTRACT'__________________________ Disposition . . . 1 1. OLD Record Compression . . 1 1. No 2. MOD 2. Yes Selection Criteria: _ Performance _ Exception Logger Selection Criteria: _ Logger Logstream Name . . . __________________________ Structure Name . . . ________________
As a minimum, select Performance and Statistics record types if you intend to use the Record Selection extract file instead of the original SMF file to complete the reporting exercises in this tutorial.
. . . ===> SUB_____________________________________________ Scroll ===> CSR_ . . . //* Command Input //SYSIN DD * * Report Set =REPORTS1 CICSPA IN(SMFIN001), APPLID(*), SUMMARY(OUTPUT(SUMM0001), EXTERNAL(CPAXW001), TOTALS(8), INTERVAL(01:00:00), FIELDS(START(TIMES,ASCEND), TRAN(ASCEND), TASKCNT, RESPONSE(AVE), RESPONSE(MAX), DISPATCH(TIME(AVE)), CPU(TIME(AVE)), SUSPEND(TIME(AVE)), SUSPEND(TIME(MAX)), DISPWAIT(TIME(AVE)), FCWAIT(TIME(AVE)), FCAMCT(AVE), IRWAIT(TIME(AVE)), SC24UHWM(AVE), SC31UHWM(AVE))), RECSEL(OUTPUT(RSEL0001), DDNAME(CPAORS01), PERFORMANCE, EXCEPTION, RESOURCE, STATISTICS, OMEGAMON, LOGGER, DB2, MQ, IDENTITY, NOCOMPRESS) /*
When the job completes, review the report output and the extract data set.