Sysview for DB2 history file resizing considerations

book

Article ID: 131649

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Due to the extreme thread history volume, the Sysview for DB2 history files are only providing a few minutes of data before they wrap. 
Is there information on how to calculate larger allocations for the history files to accommodate at least twenty-four hours worth of history?

Environment

IDB2 r19.  DB2 v11, v12

Resolution

The following link provides the calculation considerations:
https://docops.ca.com/ca-sysview-db2/19/en/configuring/data-collector-dc/online-history/online-history-data-sets/empirical-estimation-of-history-data-set-sizes
 

Additional Information

In this specific case where the files wrapped within minutes, recommendation was made to initially increase the history files
to contain a couple of hours, and then run the calculation as described in the above link. 
From there, a more finite adjustment could be made.