Sysview for DB2 history file resizing considerations
Article ID: 131649
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
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?
IDB2 r19. DB2 v11, v12
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
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.