Report for total execution time for a cicstran in a specific program

Products

• SYSVIEW Performance Management

Issue/Introduction

We were trying to extract a report from SYSV to get the CICS Transaction and their associated program logs and Execution time (Lifetime).

We got output log saying there were no records found.

Attached the Batch Job and their Logs for your reference.

Kindly help us in sorting out this in priority and suggest us with some other Batch JCL that would be helpful to generate report.

 

Resolution

First verify that SMF records 255 are being captured,  which can be done via the LGLOGS command.   In LGLOGS select the log and enter command SEL TRAN C cccc, where cccc is the CICS Transaction name.    Customer may opt to collect the records under a different SMF record type, but 255 is the default that SYSVIEW uses.   Also review to ensure there are no security errors preventing the data from being read.   Once this is complete, the following are a couple of jobs that could be used to produce this, depending on the exact need:

 

1. )

  TITLE1 CICS TOTAL TRANSACTIONS AND RESPONSE TIME REPORT   
  OPTION(SUMMARY=YES)                                       
  SELECT JOBNAME(NNNNNNNN)                                  
  SELECT TRANID(cccc)                                       
  DEFINE ID KEY JOBNAME ' ' TRANID                          
  TAB DATE TIME KEY,                                        
  TRAN USE AND,                                             
  TRAN LIFETIME AND,                                        
  TRAN CPU                                                  
  END                                                       
  RUN                                                       
END                                                         
RUN                                                         

2)

 OPTION(RECSTAT=YES)                                   
 FLASHBACK LIST  TRANID(cccc) DATETIME TRANNUM AND,    
 TRAN USE   HDR1(TRAN) HDR2(USE) AND,                  
 TERM RESP  HDR1(TERM) HDR2(RESP) AND,                 
 TRAN LIFE  HDR1(TRAN) HDR2(AVE-RT) AND,               
 TRAN MAXLIFE  HDR1(TRAN) HDR2(MAX-RT) AND,          
 TRAN USE PCT  HDR1(TRAN) HDR2(%USE)  AND,             
 TRAN CPU      HDR1(TRAN) HDR2(%CPU)  AND,             
 TRAN CPU TOTAL HDR1(TRAN) HDR2(TIME)                  
 END                                                   
 RUN  

 

    

 

Additional Information

(Please note that producing reports is a paid service provided by the Services team.  If you are interested in this service, please reach out to your account representative.