IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Warehouse Proxy Agent
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
If using DB2 for z/OS for Tivoli Data Warehouse database, increase the idle thread timeout parameter
When using DB2 for z/OS 9.1 for the Tivoli Data Warehouse database, the Warehouse Proxy Agent can encounter repeated disconnections from the database. The default idle thread timeout value (DSN6FAC IDTHTOIN in DSNZPxxx) is 120 seconds.
The Warehouse Proxy Agent uses a pool of database connections to process export requests from monitoring agents. The warehousing interval used by agents can be set to values ranging from 15 minutes up to 24 hours. The database connections are idle between export requests, and if the idle thread timeout value is less than the warehousing interval, the database connections might timeout. This results in numerous error messages written to the Warehouse Proxy Agent log. The Warehouse Proxy Agent Statistics workspace also shows many disconnections in the Failure / Disconnections view.
To avoid repeated disconnections, consider increasing the DB2 idle thread timeout value to a value higher than the warehousing interval. Specifying a value of 0 disables time-out processing. If time-out processing is disabled, idle server threads remain in the system and continue to hold their resources, if any.
Parent topic:
Warehouse Proxy Agent