Managing Unresponsive Cache Tables
The startup of the TDV Server can be significantly slow if there is a problem when accessing your cache tables. This is caused because the TDV Server process reads all the cache status tables as part of the startup routine.
TDV has a configuration parameter that can be used to eliminate this situation. When it is set to a non-zero value the server attempts to connect to each cache database within the specified timeout (in milliseconds) before performing any further cache status or cache data maintenance.
To manage unresponsive cache tables for TDV Server restart
1. Open the Studio Administration menu Configuration option.
2. Modify the milliseconds value of the Scan Cache Database Connection Timeout on Server Startup configuration parameter.
If set to a non-zero value the server attempts to connect to each cache database within the specified timeout (in milliseconds) before performing any further cache status or cache data maintenance.
Set to a value high enough to work well for your environment and network characteristics. Setting it too low renders caches unusable by TDV.
3. Save your changes.
The setting will take effect on the next server restart.