Statistics extract

A Statistics Extract is created as a delimited text file for the purpose of importing the statistics into PC spreadsheet or database tools for further detailed analysis and reporting.

Extract command

The Statistics extract can be requested from a Report Set in the CICS PA dialog. Select the Statistics extract in the Extracts category.

In batch, the command to request the Statistics extract depends on whether the Extract Focus is a Statistics Report, or a form.

When the Extract Focus is Statistics Report, the EXTRACTSTATISTICS command is used to request the Statistics extract:

CICSPA EXTRACTSTATISTICS(
                       [OUTPUT(ddname),]
                       [DELIMIT('field-delimiter'),]
                       [LABELS|NOLABELS,]
                       [TYPE(EOD,INT,USS,REQ,RRT),]
                        STTSxxxx(ddname)|STTGxxxx(ddname),...)

The STTSxxxx and STTGxxxx operands specify the CICS® Transaction Server (TS) or CICS Transaction Gateway (TG) statistics that you want to extract, where xxxx is the statistics ID. For example, specify STTS010A(TS010A01) to extract Transaction Manager statistics (ID: 010A) to the data set specified in the DD statement TS010A01.

The format of the extract records depends on the statistics ID of the extracted data: each statistics ID defines its own set of fields.

When the Extract Focus is a Statistics List form, the STATISTICSLIST operand is used to request the extract.

CICSPA STATISTICSLIST(           
           [OUTPUT(ddname),] 
           [DDNAME(ddname),]
           [DELIMIT('field-delimiter'),]
           [LABELS|NOLABELS,]        
           [LINECNT(nnn),]
           [STALTDEF(statistics-alert-definition)),]
           [SEVERITY(CRITICAL|WARNING|INFO|ELIGIBLE|ALL),]
           [INCLUDESEV,]
           [TYPE(EOD,INT,USS,REQ,RRT),]
           FIELDS(field1[,field2]...),           
           [TITLE1('...up to 64 characters...'),]
           [TITLE2('...up to 64 characters...')])

When the Extract Focus is a Statistics Summary form, the STATISTICSSUMMARY operand is used to request the extract.

CICSPA STATISTICSSUMMARY([OUTPUT(ddname),]
           [DDNAME(ddname),]
           [DELIMIT('field-delimiter'),]
           [LABELS|NOLABELS,]
           [EXTERNAL(ddname),]   
           [LINECNT(nnn),]        
           [INTERVAL(hh:mm:ss|day of week|MONTH),]
           [STALTDEF(statistics-alert-definition)),]
           [TYPE(EOD,INT,USS,RRT),]
           FIELDS(field1[(options)]),
           ⋮
           [TITLE1('...up to 64 characters...'),]
           [TITLE2('...up to 64 characters...')])