When reviewing top SQL statements information for DB2 databases under the "Databases | History | Activity" dashboard, information cannot be seen for over a 2 weeks period.
Current statements are available, but statement older than 2 weeks are missing.
The default retention policy for DB2 top SQL data is 2 weeks.
The retention policies for the DB2 top SQL statements topology objects can be increased, but it can cause churn in the topology; performance impact will increase the longer the objects are set to be retained. Growth in the Foglight repository is also expected.
There are multiple topology types and properties related to the DB2 top SQL statements information; the ones that would need their retention modified are:
To modify the retention policies: