search cancel

Sysview for DB2 history file resizing considerations


Article ID: 131649


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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:

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.