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.