REPORTING using offloaded logstreams
Article ID: 124108
Updated On:
Products
SYSVIEW Performance Management
NXBRIDGE - SYSVIEW/ENDEVOR
Issue/Introduction
Can you execute reports from an offloaded logstream?
We offload our CIS SYSVIEW logstream on a daily basis to tape (IEBGENER) and then clean out our logstream for the next day.
Can reports be executed against the offloaded logstream?
If not -
Can the logstream be restored so reprots can be executed against logstream?
Environment
Release:
Component: SYSVW
Component: SYSVW
Resolution
The offloaded log stream cannot be reloaded and read by SYSVIEW, but you can run Report Writer against the offloaded data.
First things first, I see a small problem in the example JCL in this email thread. I see NOEXPAND in the GSVXLGEX logger exit parameters.
It should be EXPAND.
This controls the native compression SYSVIEW uses on the records.
Please make sure the IEBGENNER offload JCL you are using has EXPAND coded. I am not sure if that was already discussed since then, but I wanted to make sure of it before moving on.
Assuming we have EXPANDed records in the offload, then you can run Report Writer directly against that data set.
The report might look something like this:
//jobcard //REPORT EXEC PGM=XPFRMAIN,REGION=0M
//STEPLIB DD DISP=SHR,DSN=sysviewhlq.CNM4RLOD
//ERPTPRM DD DISP=SHR,DSN=sysviewhlq.CNM4RSAM
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//TAPSMF DD DISP=SHR,DSN=offloaded.data.set.name
//SYSIN DD *
OPTION(MAXTO=YES) TITLE1 SYSVIEW/CICS TRANSACTION DETAIL REPORT
SELECT JOBNAME(*)
FLASHBACK CICS
FROM 01/02/19 00:00:00
TO 01/02/19 23:59:59
END
RUN
/*
First things first, I see a small problem in the example JCL in this email thread. I see NOEXPAND in the GSVXLGEX logger exit parameters.
It should be EXPAND.
This controls the native compression SYSVIEW uses on the records.
Please make sure the IEBGENNER offload JCL you are using has EXPAND coded. I am not sure if that was already discussed since then, but I wanted to make sure of it before moving on.
Assuming we have EXPANDed records in the offload, then you can run Report Writer directly against that data set.
The report might look something like this:
//jobcard //REPORT EXEC PGM=XPFRMAIN,REGION=0M
//STEPLIB DD DISP=SHR,DSN=sysviewhlq.CNM4RLOD
//ERPTPRM DD DISP=SHR,DSN=sysviewhlq.CNM4RSAM
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//TAPSMF DD DISP=SHR,DSN=offloaded.data.set.name
//SYSIN DD *
OPTION(MAXTO=YES) TITLE1 SYSVIEW/CICS TRANSACTION DETAIL REPORT
SELECT JOBNAME(*)
FLASHBACK CICS
FROM 01/02/19 00:00:00
TO 01/02/19 23:59:59
END
RUN
/*
Feedback
Yes
No
Powered by
