ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Sysview for DB2 history file resizing considerations
Article ID: 131649
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem 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.