REPORTING using offloaded logstreams

Document ID : KB000124108
Last Modified Date : 13/02/2019
Show Technical Document Details
Question:
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?
Answer:
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
/*