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:
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.