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 specific requests that time out, while others succeed.

Before you begin

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 locks 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.

About this task

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

To relieve database deadlock, perform the following steps:

Procedure

  1. Stop the Warehouse Proxy Agent and Summarization and Pruning Agent, and drop and re-create the existing warehouse database.
  2. Review the appendix “Relational database design and performance tuning for DB2 database servers” appendix in the IBM Tivoli Monitoring: Administrator's Guide to learn about DB2 tuning considerations. Then issue the following command from the DB2 command window:

    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 Agent and Summarization and Pruning Agent.
  4. Configure historical collection at the Tivoli Enterprise Portal.