Monitoring agent receives remote procedure call errors during warehousing, with some requests timing out and failing

While the monitoring agent is performing a warehousing operation, the agent might receive multiple remote procedure call (RPC) errors, upload failures, and requests that time out while other succeed.

You might see messages similar to this one in the warehousing log:

[IBM][CLI Driver][DB2/NT] SQL0911N
The current transaction has been rolled back because of a deadlock or timeout.
Reason code "2".
SQLSTATE=40001

These RPC calls may indicate that the warehouse proxy agent gets locked up temporarily and cannot respond to new requests. Eventually, the proxy clears and continues processing. These kinds of problems are symptoms of insufficient database tuning.

If you plan to install your Tivoli Data Warehouse on DB2®, update the DB2 configuration to reduce the likelihood of database deadlocks when the amounts of monitor data that are transferred to the warehouse is high. Use the following examples as a guide to making the configuration changes. It is best to make these changes before installing both the Warehouse Proxy and Summarization and Pruning agents and creating the warehouse database. To ensure that tablespaces are created correctly, use the database creation support provided during the installation (or re installation) of the Tivoli® Data Warehouse agent from the Manage Tivoli Enterprise Services window.

To relieve database deadlock, follow these steps:
  1. Stop the Warehouse Proxy and Summarization and Pruning Agents, and drop and recreate the existing warehouse database.
  2. Review the Relational database design and performance tuning for DB2 database servers topic in the Performance Tuning / Tivoli Data Warehouse section of the IBM Tivoli Monitoring: Installation Guide to learn about DB2 tuning considerations. Then, from the DB2 command window, issue the following command:
    db2 update db cfg for WAREHOUS using parameter value
    Use the following data configuration parameters:
    DFT_DEGREE
    LOGBUFSZ
    LOCKLIST
    SORTHEAP
    NUM_IOCLEANERS
    NUM_IOSERVERS
    LOGFILSIZ
    LOGPRIMARY
  3. Restart the Warehouse Proxy and Summarization and Pruning Agents.
  4. Configure historical collection at the Tivoli Enterprise Portal.