GrantRevoke records not being offloaded.

book

Article ID: 207609

calendar_today

Updated On:

Products

CA Sysview Performance Management Option for DB2 for z/OS

Issue/Introduction

Using the IDB2UNLD task to offload the history file. 

The offloaded history files are used to run ILQs and there are hundreds of reports against various ifcids.

Trying to run the GRANTREV program from CDBATREQ and it indicates no records are selected. 

Run this online and it gets multiple hits.

What is need to do to get this report to run in batch.

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

HIST-STATS-RECS parm should be updated. 

Add 141 to the parm restart in the Datacollector.