External sorting
Some CICS PA reports and extracts sort records to produce their output. CICS PA uses the SORT utility (DFSORT or equivalent product) to perform External Sorting. See Table 1 for a list of reports that use SORT.
External Work data sets are used to save records that are to be sorted. If the EXTERNAL operand is not specified, CICS PA assigns an External Work File from a pool specified in the JCL. External Work Files in the pool are identified with unique ddnames prefixed by CPAXW. Each report that requires an External Work File and does not specify the EXTERNAL operand is assigned one from the pool. You must ensure that there are enough External Work Files in the pool to handle all the reports that need one.
Report or Extract | Description | Default Report Output ddname | Default Extract Output ddname | External Sort Required? |
---|---|---|---|---|
LIST | Performance List Report | LISTnnnn | N/A | N |
LISTX | Performance List Extended Report | LSTXnnnn | N/A | Y |
SUMMARY | Performance Summary Report | SUMMnnnn | N/A | Optional |
TOTAL | Performance Totals Report | TOTLnnnn | N/A | N |
WAITANALYSIS | Wait Analysis Report | WAITnnnn | N/A | N |
PROFILING | Transaction Profiling Report | PROFnnnn | N/A | Optional |
CROSS | Cross-System Work Report | CROSnnnn | N/A | Y |
TRANGROUP | Transaction Group Report | TRGPnnnn | N/A | Y |
BTS | BTS Report | CBTSnnnn | N/A | Y |
WORKLOAD | Workload Activity Report | WKLDnnnn | N/A | Depends |
TRACKINGLIST | Transaction Tracking List Report | TTLSnnnn | N/A | Y |
TRACKINGSUMMARY | Transaction Tracking Summary Report | TTSUnnnn | N/A | Y |
LISTEXCEPTION | Exception List Report | XLSTnnnn | N/A | N |
SUMEXCEPTION | Exception Summary Report | XSUMnnnn | N/A | N |
RESUSAGE | Transaction Resource Usage Reports (File Usage Summary, Temporary Storage Usage Summary, DPL Usage Summary, Transaction Resource Usage List) | FILEnnnn, TEMPnnnn, DPLSnnn, RESUnnnn | N/A | N |
STATISTICSLIST | Statistics List Report | SLSTnnnn | STEXnnnn | N |
STATISTICSSUMMARY | Statistics Summary Report | SSUMnnnn | N/A | Optional |
STATSALERT | Statistics Alert Reports | STALnnnn | N/A | Y |
CTGSTATISTICS | CICS® TG Statistics reports (Activity Summary, Usage and Capacity report, Configuration Summary, Client Workload report, CICS Workload report, Web Services Workload report) | STTGnnnn | N/A | N |
DB2® | DB2 Report | DB2Rnnnn | N/A | Y |
MQ | WebSphere® MQ Report | MQ00nnnn | N/A | N |
LOGGER | System Logger Report | LOGRnnnn | N/A | Depends |
OMEGAMON® | OMEGAMON Reports | OMEGnnnn | N/A | N |
CROSS | Cross-System Work Extract | XSYSnnnn | CPAOXSYS | Y |
EXTRACTPERFORMANCE | Performance Data Extract | EXPTnnnn | CPAOEXPT | Depends |
RECSEL | Record Selection Extract | RSELnnnn | CPAORSEL | N |
LOGGER | System Logger Extract | LOEXnnnn | CPA0EXPT | Y |
EXTRACTSTATISTICS | Statistics Extract | STEXnnnn | TSxxxxnn, TGxxxxnn | N |
The following DD statements are required for External Sorting:
- CPAXWnnn DD
- External Work Files. These DD statements define the External Work
Files used by the reports that sort their records. CICSPA commands
refer to these DD statements via the EXTERNAL operand (see EXTERNAL).
The CICS PA dialog automatically generates these DD statements at job submission time, based on the External Work Data Sets specification in the Reporting Allocation Settings profile options.
External Work ddnames need not be prefixed by CPAXW. CICS PA will accept any ddname via the EXTERNAL operand.
- CPASWKnn DD
- Sort Work Data Sets.
These DD statements define the Sort Work Files used by DFSORT (or equivalent product) on behalf of the reports that sort their
records. nn is the Sort Work File sequence number.
The CICS PA dialog automatically generates four DD statements at job submission time, based on the Sort Work Data Sets specification in the Reporting Allocation Settings profile options.
- SORTLIB DD
- This is the library in which DFSORT (or equivalent product) is installed, and can be omitted if SORT is installed in the link-list.
- SYSOUT DD
- Sort Message Data Set. This DD statement defines the file used for SORT messages. It is required if DFSORT is used.