Hi,
I am using the live logstream dataset. I have enclosed the JCL below, it seems to produce the correct output including the date range. Is the the right approach to create a report of IMS transactions containing the transaction ID, the date/time and the user ID?
Also would it be possible to create a similar report of abended IMS transactions or the same report with a completion or abend code?//REPORT EXEC PGM=XPFRMAIN,REGION=4M
//ERPTPRM DD DISP=SHR,DSN=SYSNZR.SYSVIEW.SAMPJCL
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//TAPSMF DD DISP=SHR,DSN=SYSVIEW.IMSLOGR.IMTR.NASC,
// SUBSYS=(LOGR,GSVXLGEX,
// 'FROM=OLDEST,TO=YOUNGEST,LOCAL',
// 'STATS,EXPAND,BACKWARD,NORDW'),
// DCB=(DSORG=PS,RECFM=VB,LRECL=32756,BLKSIZE=32760)
//SYSIN DD *
OPTION(RPTSTAT=YES,RECSTAT=YES,MAXTO=NO)
TAB DATE USERID TRANID IMS PERF TRAN LIFE,
AND IMS PERF TRAN INQUEUE,
AND IMS PERF TRAN OUTQUEUE,
AND IMS PERF TRAN PROC
FROM -1 DAYS
TO -1 DAYS
END
RUN
Original Message:
Sent: 04-22-2021 09:35 AM
From: Hennie Hermans
Subject: How to extract CA SYSVIEW IMS Transaction Data with USERID using the Report Writer
Hi Patrick,
For the IMS reporting case with CA Sysview report writer.. What input file are you using.. The offloaded logstream datasets (SMF datasets), or are you using the live logstream datasets?
If you remove the FROM and TO statements, do you then receive the proper data in the report..
If not, please open a case at our Broadcom support website and we can take a closer look..
Best regards
Hennie Hermans
------------------------------
Principal Support Engineer
CA Technologies, A Broadcom Company
Original Message:
Sent: 04-20-2021 03:36 PM
From: Patrick Cribbs
Subject: How to extract CA SYSVIEW IMS Transaction Data with USERID using the Report Writer
Hi,
I trying to extract the USER ID with the IMS transaction data using the Report Writer. I tried the following but it seems to ignore the date range. I would like to extract the transaction ID, the date/time and the user ID. I did not see a way of creating a customized report using FLASHBACK IMS. Is this possible? Also would it be possible to list the condition code?
OPTION(RPTSTAT=YES,RECSTAT=YES,MAXTO=NO)
TAB USERID TRANID IMS PERF TRAN LIFE,
AND IMS PERF TRAN INQUEUE,
AND IMS PERF TRAN OUTQUEUE,
AND IMS PERF TRAN PROC
FROM -1 DAYS
TO -1 DAYS
END
RUN