Sysview for DB2 history file resizing considerations
book
Article ID: 131649
calendar_today
Updated On:
Products
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
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:
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.