IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Summarization and Pruning Agent
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Set the max worker threads and max rows per transaction appropriately for your environment
In the large scale environment, you might want to change the parameters in the Summarization and Pruning Agent configuration file (sy.ini for UNIX/Linux or ksyenv for Windows).
- KSY_MAX_WORKER_THREADS
- This parameter specifies the number of worker threads for processing attribute group tables. The default value is 2. For a large database server with multiple processors, increasing this value might improve concurrency and throughput. A good starting value is two times the number of processors on the database server.
- KSY_MAX_ROWS_PER_TRANSACTION
- This parameter specifies the maximum number of rows per database transaction, and can be thought of as a batching factor. When the number of worker threads is greater than 1, the batching factor for a given worker thread is equal to the maximum rows per transaction divided by the number or worker threads. When you set the number of worker threads, you should also consider increasing the value, to maintain a batching factor of 200 or more.
Parent topic:
Summarization and Pruning Agent