XLOG logstream sample report

book

Article ID: 198419

calendar_today

Updated On:

Products

CA SYSVIEW Performance Management NXBRIDGE - SYSYVIEW/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