Creating a Record Selection extract
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.
To request a Record Selection extract:
- From the Report Set edit tree, select the Record Selection extract.
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 - ___ Extracts Yes ___ Cross-System Work No ___ Performance No S__ Record Selection Yes ___ HDB Load No ___ System Logger No ___ Statistics No ** End of Reports **
- Specify record selection options. Select all record types and
specify the name of the output data set.
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
Log Stream
Name . . __________________________ Structure Name . . . ________________
Note:- In this example, we selected all record types to allow you to
use the extract file for all CICS PA functions
that you may want to try. However, you may choose not to include certain
record types to reduce the file size and improve performance.
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.
- CICS PA will generate JCL to allocate the extract data set if it is not already defined. If the data set is already defined, it will be processed according to the Disposition option selected.
- In this example, we selected all record types to allow you to
use the extract file for all CICS PA functions
that you may want to try. However, you may choose not to include certain
record types to reduce the file size and improve performance.
- Exit to save the extract options. Exit again to return to the Report Set edit panel.
- Enter RUN on the command line of the Report Set panel.
- On the run-time prompt panel, specify appropriate options, select to edit JCL before submit, then press Enter.
- CICS PA generates
the JCL and displays it in an ISPF edit session.
. . . ===> SUB_____________________________________________ Scroll ===> CSR_ . . . //* Command Input //SYSIN DD * * Report Set =REPORTS1 CICSPA IN(SMFIN001), APPLID(*),
LINECNT(60), FORMAT(':','/'), PRECISION(4),
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) /*
- Make any necessary changes, then enter the SUBmit command to submit the job.
When the job completes, review the report output and the extract data set.