XLOG logstream sample report

Products

• SYSVIEW Performance Management
• NXBRIDGE - SYSVIEW/ENDEVOR

Issue/Introduction

Where to find any sample report regarding  the XLOG log stream

For example for any exception reporting the following info:

CICS jobmane
Transaction name
Program name
Threshold name 
Warning/Problem
Date/Time

Environment

Release : 16.0

Component : SYSVIEW

Resolution

Report Writer doesn't have anything out of the box as an example of XLOG reporting, however, the following could be  a report that might help. The XLOG doesn't contain program names but the CICS Transaction Detail record does contain Threshold information, so you will need to run the parms against your CTRANLOG.

The FLASHBACK provides an easy way to write a line for every entry where the TAB type report will summarize.  

OPTION(RECSTAT=YES,RPTSTAT=YES,SUMMARY=NO) 

COPY GSVSMF27 

DEFINE XVAR CICS PERFORM TRAN WKVARI, 
PRODUCT=EXPC, 
RECORD=27, 
TRIPLET=306, 
OFFSET=0, 
LENGTH=8, 
TYPE=CHAR, 
HDR1=Variable 

DEFINE XVAR CICS PERFORM TRAN WKVALUE, 
PRODUCT=EXPC, 
RECORD=27, 
TRIPLET=306, 
OFFSET=X40, 
LENGTH=8, 
TYPE=6DEC, 
HDR1=Thresh, 
HDR2=Value 

DEFINE XVAR CICS PERFORM TRAN WKWARN, 
PRODUCT=EXPC, 
RECORD=27, 
TRIPLET=306, 
OFFSET=X48, 
LENGTH=8, 
TYPE=6DEC, 
HDR1=Thresh, 
HDR2=Warn 

DEFINE XVAR CICS PERFORM TRAN WKLIMIT, 
PRODUCT=EXPC, 
RECORD=27, 
TRIPLET=306, 
OFFSET=X50, 
LENGTH=8, 
TYPE=6DEC, 
HDR1=Thresh, 
HDR2=Limit 

SELECT THS_VARIABLE (¬RMITIM*,¬'40'*) 

DEFINE ID KEY TRANNUM ' ' JOBNAME ' ' PROGID 

TAB DATETIME KEY, 
C_TRAN (¬'40'*) AND, 
CICS TRAN WKVALUE AND, 
CICS TRAN WKWARN AND, 
CICS TRAN WKLIMIT AND, 
CICS PERFORM TRAN THS_TOD 

TAB2 THS_KEY, 
THS_VARIABLE AND, 
THS_TYPE 

EACH MINUTE 

END 
RUN