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.

The Record Selection Extract filters large SMF Files, writing only SMF records that match the following criteria:

A Recap report containing processing statistics is always printed at the end of extract processing.

To request the extract, enter line action S against the Record Selection Extract on the Report Set panel. If extracts of this type have been previously specified, the list of Record Selection Extracts is displayed. Otherwise, the Record Selection Extract panel is displayed for you to define your first one.
Figure 1. Record Selection Extracts
   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.

To display the Record Selection Extract panel, enter line action S against the Record Selection Extract in the Report Set panel, then if the list of previously specified extracts is displayed, enter line action S against a particular one in the list.
Figure 2. Record Selection 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.

The options are:
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.

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/idrsers.htm