Maintenance and tuning

To maximize TADDM performance, you might want to perform additional configuration steps and ongoing maintenance tasks.

Bulk load parameters tuning
You can customize the behavior of the Bulk Loader by specifying particular parameters at run time or configuring the bulkload.properties file.
Database maintenance
To maintain optimal performance of your system, you must plan for and complete regularly scheduled maintenance and tuning of the TADDM database.
Discovery performance tuning
You can update the com.collation.discover.dwcount, com.collation.discover.observer.topopumpcount, and com.ibm.cdb.discover.observer.topopump.threshold properties in the collation.properties file to influence the discovery rate and the rate at which the discovery results are stored in the TADDM database, or to limit the number of threads that are responsible for storing data.
Java Virtual Machine: IBM parameters tuning
You can set Java™ Virtual Machine (JVM) parameters that reduce fragmentation of the Java heap and can help improve performance.
Java Virtual Machine properties tuning
In the collation.properties file, the default values for the Java Virtual Machine (JVM) properties that apply to the TADDM Discovery Management Console are based on the number of server equivalents (SEs) in your environment.
Network tuning
After a system is implemented, the network should be monitored to ensure that its bandwidth is not being consumed more than 50%.
DNS tuning
TADDM is sensitive to the performance of the deployed DNS infrastructure. Even if DNS performance is adequate for other applications, some configuration might be required to optimize performance for TADDM.
Synchronization server tuning
The performance of the synchronization server is highly dependent on database processing and therefore, on database maintenance and tuning. If you experience performance problems with synchronization processing, refer to the information on database tuning, and especially note the buffer pool settings for DB2® databases, the buffer cache settings for Oracle databases, and the information about database maintenance.
Windows system tuning
To assign more memory for TADDM services, tune the Windows systems.

Parent topic: Administering