Chapter 4. Planning historical data collection in large scale environments 107
Sharing the load
A large volume of simultaneous uploaded requests may negatively affect the
insertion rate if only one Warehouse Proxy agent is used. 5.5, “Tivoli Data
Warehouse performance” on page 151 advises how to set some Warehouse
Proxy tuning variables such as the number of export threads, the size of the
queue containing the historical exports, the batch option, or the database
itself when the Warehouse Proxy agent has to handle large data volumes.
Note that, if one Warehouse Proxy agent cannot handle all the historical
exports despite the tuning, the workload can be shared by installing multiple
Warehouse Proxy agents.
Failover
Tivoli Monitoring 6.1 FP5 provides the ability to automatically send historical
uploads to a failover Warehouse Proxy agent when the communication to the
primary Warehouse Proxy agent is unavailable. However, this facility does
not provide load balancing or an automatic switch-back to the original
Warehouse Proxy agent.
Determining which Warehouse Proxy agent will act for which agent is based on:
For an agent: which TEMS does it report to
For a Warehouse Proxy agent: the list of TEMS it is related to for
warehousing purposes
The second relationship is set by the KHD_WAREHOUSE_TEMS_LIST
environment variable in the Warehouse Proxy agent environment file.
KHD_WAREHOUSE_TEMS_LIST is a space-separated, semi-colon-separated,
or comma-separated list of TEMS names.
The primary Warehouse Proxy agent for all agents reporting to a given TEMS is
the Warehouse Proxy agent which includes the name of this TEMS in its
KHD_WAREHOUSE_TEMS_LIST.
A Warehouse Proxy agent without any KHD_WAREHOUSE_TEMS_LIST
variable set, or with a variable containing the string '*ANY' serves automatically
all the agents that do not have a primary Warehouse Proxy agent. In this case, it
is known as the default Warehouse Proxy agent for all agents.
A default Warehouse Proxy agent should be started last of all the Warehouse
Proxy agents, so that agents use their primary Warehouse Proxy agent if it is
available.
The relationships indicating which Warehouse Proxy agent is acting for which
agent are stored in the hub monitoring server. This is why all Warehouse Proxy