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 Enterprise Services window.
To relieve database deadlock, perform the following steps:
Procedure
- Stop the Warehouse Proxy Agent and Summarization and Pruning Agent, and drop and recreate the existing warehouse database.
- 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
- Restart the Warehouse Proxy Agent and Summarization and Pruning Agent.
- Configure historical collection at the Tivoli Enterprise Portal.