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.

Table 1. CICS PA reports, default ddnames, and external sort requirements
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, URIMAP Usage Summary, WEBSERVICE Usage Summary, Transaction Resource Usage List) FILEnnnn, TEMPnnnn, DPLSnnn, URIMnnnn, WEBSnnnn, 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
ZCON z/OS® Connect EE Report/Extract/Forwarding ZCEExxxx/ZCEXxxxx/ZCFDxxxx N/A Y

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.