Row Counts in database tables

At startup, IBM® Sterling Control Center Monitor initiates a query to ascertain the row counts in the various database tables used to hold event data. These queries can be onerous to performance as they may cause contention on those tables while IBM Sterling Control Center Monitor is trying to add data to them.

These row counts are displayed by the IBM Sterling Control Center Monitor Web console. Click Menu button () > System Settings > Database > Production DB Information > Statistics.

To eliminate the database contention caused by the queries used to ascertain row counts for the various database tables used to hold event data you may specify the engine property DO_NOT_CALCULATE_ROW_COUNTS with a value of TRUE - the default value is FALSE. When DO_NOT_CALCULATE_ROW_COUNTS is set to TRUE, IBM Control Center will no longer initiate queries to get row counts for its tables at startup or when the daily purge operation is run. The repercussion of this however is that the row count values shown on the Statistics tab for the IBM Control Center database tables will not be correct. When DO_NOT_CALCULATE_ROW_COUNTS is set to TRUE IBM Sterling Control Center Monitor will no longer initiate queries to get row counts for its tables at startup or when the daily purge operation is run.