Hi everybody,

Is there a way to collect db statistics like performance history over a period of time, for example, we want to see how db2 has been performing over a the past few months. I have tried db2 snapshot monitoring but it only gives you info at that specific time, I want stats for the past few months.

Thanks to all

Not sure which version of db2 you are on ...

Check if the Health Centre history helps ...

Otherwise, you can record the snapshot information to a table and use SQL to analyze at a later date ...

Cheers
Sathyaram