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, List) | FILEnnnn, TEMPnnnn, DPLSnnn, RESUnnnn | N/A | N |
STATSALERT | Statistics Alert Reports | STALnnnn | N/A | Y |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
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 |
GRAPH(TRANRATE) | Transaction Rate Graph Report | GRTEnnnn | N/A | N |
GRAPH(RESPONSE) | Response Time Graph Report | GRSPnnnn | 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:
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.
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.