...

• statdb.connectionurl must point to a database, e.g. statdb.connectionurl=jdbc:cloudscape:/db/ppstatistics
• statdb.drivername must contain the name of the JDBC driver to use, e.g. com.ihost.cs.jdbc.CloudscapeDriver or COM.ibm.db2.jdbc.app.DB2Driver.
• If load on the database is high, and applications have an extreme number of measurement points, then it might make sense to either disable the highest resolution statistics by setting statdb.disableminutestats=true – this will significantly reduce the amount of database updates being done at the cost of losing some of the details – the statistics will still be present in the hour and day tables, but you will no longer be able to see resolution beyond one hour.
• Instead of disabling the per-minute statistics, you can also elect to increase the interval – e.g. from 1 minute to 5 minutes by setting statdb.minuteinterval=5 – this will change the resolution to 5-minutes instead of the default 1 minute.
• statdb.cleanupinterval specifies the number of minutes between each cleanup of the database. A cleanup will delete entries in the minutes table older than 24 hours, and entries in the hours table older than 60 days.

Important

...

Performance Considerations

In a large system with many servers and agents attached there can be a lot of records going to the database – e.g. a system with 2000 different measurement points and measurements being done on all of them at least once per minute (which is very unlikely, but theoretically possible) will end up with 2000*3 = 6000 updates per minute = 360.000 per hour, and 60*2000 + 2000 = 122.000 rows in the database.

...