Record Selection extract
The Record Selection Extract is a facility that allows you to create a small extract file containing only the records of interest to you. The extract file can then be used as input to CICS PA, allowing more efficient reporting.
- CICS®, DB2®, MQ, and Logger System Selection
- Selected record types, being any of:
- Performance
- Exception
- Resource
- Statistics (includes CICS TG statistics from SMF type 111 records)
- OMEGAMON®
- DB2
- WebSphere® MQ
- System Logger
- Identity
- Performance Selection Criteria
- Exception Selection Criteria
- Logger Selection Criteria
- Run-time SMF reporting interval
A Recap report containing processing statistics is always printed at the end of extract processing.
File Filter Edit Systems Options Help
------------------------------------------------------------------------------
SAMPLE - Record Selection Extracts Row 1 from 2
Command ===> ________________________________________________ Scroll ===> ____
---- System Selection ----- ————— Selection Criteria —————
/ Exc APPLID + Image + Group + Recap Performance Exception Logger
_ CICSP001 ________ ________ RSEL0001 NO NO NO
Output Data Set . . 'CICSP001.DB2P.RECSEL'________________________
-----------------------------------------------------------------------------
_ DEVT____ MVS1____ ________ RSEL0002 YES NO NO
Output Data Set . . 'DEVTMVS1.RECSEL'_____________________________
-----------------------------------------------------------------------------
******************************** End of list ********************************
This panel displays the list of Record Selection Extracts in this Report Set. You can select (edit), delete, or include/exclude any extract, insert new ones, or rearrange them (move/copy).
The options and line actions are the same as on the Cross-System Work Extracts panel. See Cross-System Work extract.
File Systems Options Help
------------------------------------------------------------------------------
SAMPLE - Record Selection Extract
Command ===> _________________________________________________________________
System Selection:
CICS APPLID . . CICSP001 + Image . . ________ + Group . . ________ +
DB2 SSID . . . ____ + Image . . ________ + Group . . ________ +
MQ SSID . . . ____ + Image . . ________ + Group . . ________ +
Logger . . . . ________ + Image . . ________ + Group . . ________ +
Required CICS Record Types: Extract Recap:
/ Performance _ Exception DDname . . . RSEL0001
_ Resource _ Statistics
_ OMEGAMON _ DB2
_ WebSphere MQ _ System Logger
_ Identity
Output Data Set:
Data Set Name . . 'CICSP001.DB2P.RECSEL'________________________
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 . . . ________________
F1=Help F3=Exit F4=Prompt F7=Backward F8=Forward F10=Actions
F12=Cancel
Use this panel to specify extract options and record selection criteria for the Record Selection extract. The mandatory options are the name and disposition of the Extract Data Set and the DDname for the Recap report. You can let the other options default, although it is recommended that you specify Selection Criteria to reduce the volume of data.
- System Selection
-
- CICS APPLID
- Identifies the CICS APPLIDs whose data you want to select for
processing.
You can specify any combination of APPLID, Image, or Group, but these must be defined in your System Definitions. If you do not specify System Selection here or in the Global Options, then you are prompted at run time to specify the System Selection. This will apply globally to all reports and extracts without their own System Selection. This is recommended as it allows you to run your Report Sets against any of your defined Systems. Press the Prompt key (F4) to select from a list of defined Systems, Images, or Groups. To modify your System Definitions, select Systems in the action bar.
Specify one of the following:- A CICS APPLID. An APPLID that matches a defined System's name pattern is also allowed. For example, CICSP1 can be specified if CICSP* is a defined system.
- An APPLID and an MVS™ Image. This identifies the MVS Image where your CICS system runs.
- An MVS Image. All CICS systems executing on this MVS Image is selected.
- An APPLID and Image combination plus a Group. This is useful for uniquely identifying a CICS system when there are multiple CICS systems with the same name defined.
- A Group alone. CICS PA will select all CICS APPLIDs defined to the Group. For example, for transaction grouping, or for systems that connect via IRC/MRO, ISC/APPC, or IPIC.
CICS PA uses the System Selection in JCL generation to build the APPLID(applid1,applid2,applid3,...) and INput(SMFIN001,SMFIN002,SMFIN003,...) operands, and corresponding //SMFINnnn DD statements.
System Selection can also be specified either:- In Global Options. The report-level specification takes precedence over the global.
- At run time. The run-time System Selection overrides the Global Options and optionally the report-level specification.
- DB2 SSID
- The DB2 Subsystems and SMF data files you want processed. The Record
Selection extract processes DB2 101 accounting records only if
they are part of a CICS thread, and will only process these
if you specify the DB2 SSID(s). Any combination of SSID,
Image, or Group can be specified but must be defined in System Definitions. You can type them in
directly or select from a list of available SSIDs by using Prompt (F4). To link directly to
System Definitions, select Systems in the action bar. Specify either:
- A DB2 SSID.
- An SSID for a particular Image. This identifies the MVS Image where your DB2 Subsystem runs.
- An Image. CICS PA will report on all DB2 SSIDs running on this Image using the SMF files defined for the Image.
- An SSID and Image combination plus a Group. This is useful for uniquely identifying DB2 Subsystems when there is more than one of the same name defined in System Definitions.
- A Group alone. CICS PA will report on all SSID and Image combinations in the Group to produce a single consolidated report.
CICS PA uses the DB2 System Selection in JCL generation to build the SSID(ssid1,ssid2,ssid3,...) and INput(SMFIN001,SMFIN002,SMFIN003,...) operands, and corresponding //SMFINnnn DD statements.
DB2 System Selection can also be specified as a global option. The report-level specification takes precedence over the global. When you submit your Report Set, you can also specify DB2 System Selection at that time and it takes precedence over the global for that run only.
- MQ SSID
- The WebSphere MQ Subsystems and SMF data files you
want processed. The Record Selection extract processes MQ 116 accounting records only if they are
part of a CICS thread, and will only process these if you
specify the MQ SSID(s). Any combination of SSID, Image, or Group can be specified but must be
defined in System Definitions. You can type them in directly or select from a list of available
SSIDs by using Prompt (F4). To link directly to System Definitions, select Systems in
the action bar. Specify either:
- An MQ SSID.
- An SSID for a particular Image. This identifies the MVS Image where your MQ Subsystem runs.
- An Image. CICS PA will report on all MQ SSIDs running on this Image using the SMF files defined for the Image.
- An SSID and Image combination plus a Group. This is useful for uniquely identifying MQ Subsystems when there is more than one of the same name defined in System Definitions.
- A Group alone. CICS PA will report on all SSID and Image combinations in the Group to produce a single consolidated report.
CICS PA uses the MQ System Selection in JCL generation to build the SSID(ssid1,ssid2,ssid3,...) and INput(SMFIN001,SMFIN002,SMFIN003,...) operands, and corresponding //SMFINnnn DD statements.
MQ System Selection can also be specified as a global option. The report-level specification takes precedence over the global. When you submit your Report Set, you can also specify MQ System Selection at that time and it takes precedence over the global for that run only.
- Logger
- The MVS System Loggers and associated SMF data files
that you want to report against. Any combination of Logger, Image,
or Group can be specified but must be defined in System Definitions.
You can type them in directly or use Prompt (F4) to select
from a list. To link directly to System Definitions, select Systems in
the action bar. Specify either:
- A Logger.
- A Logger for a particular Image. This identifies a particular System Logger when there is more than one with the same ID.
- An Image. CICS PA will report on all systems running on this Image using the SMF files defined for the Image.
- A Logger and Image combination plus a Group. This is useful for uniquely identify a system when there is more than one of the same name defined in System Definitions.
- A Group alone. CICS PA will report on all system and Image combinations in the Group to produce a single consolidated report.
CICS PA uses the Logger System Selection in JCL generation to build the INput(SMFIN001,SMFIN002,SMFIN003,...) operand and corresponding //SMFINnnn DD statements. It also generates the LOGGER operand to request Logger records for the extract.
Logger System Selection can also be specified as a global option. The report-level specification takes precedence over the global. When you run your Report Set, you can also specify Logger System Selection at run time to override the global and optionally the report-level specification.
- Required CICS Record Types
- Enter / to select the combination of record types that
you want included in the extract.
Note that APPLIDs, DB2 SSIDs, MQ SSIDs, and Logger data are included in the extract according to your specified System Selection.
- Extract Recap DDname
- The DDname for the Recap report which prints at the end of extract
processing to provide processing statistics. The DDname is mandatory.
CICS PA assigns a default DDname RSELnnnn where nnnn is a sequential number 0001-9999 to ensure each Recap report has a unique DDname.
This option generates the OUTPUT(ddname) operand.
- Output Data Set
- The name of the data set where the extract records are written.
When specifying the data set name, standard TSO conventions apply.
If CICS PA is to create the data set at run time, the default allocation attributes specified on the Reporting Allocation Settings panel are used in generating the JCL. If the data set is already cataloged, then CICS PA will use DISP=OLD or DISP=MOD according to your request to overwrite or append to the existing data set.
CICS PA generates the DDNAME(ddname) operand and assigns a default DDname CPAORSnn where nn is a sequential number 01-99 to ensure uniqueness.
- Disposition
- The DISP value that you want the generated JCL to use for the
output data set if it is already cataloged:
- OLD
- Overwrites the data set contents with the new extract data.
- MOD
- Appends the new extract data.
You must specify one of these dispositions regardless of whether the output data set is cataloged. If the output data set is not cataloged when CICS PA generates the JCL, then CICS PA generates the JCL using DISP=(NEW,CATLG) to catalog it.
- Record Compression
- Select whether you want the SMF records in the extract file to
be in compressed or uncompressed format. This option applies whether
the records in the input SMF file are compressed or not.
If you select Yes, CICS PA writes CICS monitoring (SMF type 110, subtype 1) and OMEGAMON XE for CICS (SMF type 112) records in compressed format, regardless of the CICS release level of the input records. Other records are not compressed. Although CICS only introduced support for writing compressed SMF records in CICS Transaction Server Version 3.2, you can use CICS PA to create an extract file of compressed SMF records for any CICS release supported by CICS PA. You can use extract files containing compressed SMF records as input to CICS PA, just like any other SMF file, even though the CICS product level that originally created those SMF records cannot write them in compressed format.
Selecting this option generates the COMPRESS operand.
- Selection Criteria
- To filter data for Performance, Resource Class,
Statistics, DB2, MQ, Identity and Omegamon record selection, specify Performance Selection
Criteria.
To filter data for Exception Class record selection, specify Exception Selection Criteria.
To filter data for System Logger record selection, specify any combination of Logger Selection Criteria, Logstream Name, and Structure Name.
Selection Criteria are not applicable to Statistics records.
Line Actions:- ⁄
- Display the menu of line actions.
- S
- Display the subpanel where Selection Criteria can be specified for this report. For details, see Specifying Selection Criteria.
- A
- Activate the Selection Criteria so they are generated for this report when the Report Set is submitted. Selection Criteria can only be activated if one or more Select Statements are specified and not all are excluded. An asterisk (*) indicates they are active.
- D
- Deactivate the Selection Criteria. Any you have specified here will not be used.