CTIRA_HOSTNAME has no effect on log file names
Setting CTIRA_HOSTNAME with the virtual host name shows the agent on the
workspace as one entity no matter the node on which it is running. However, the
setting has no effect on the log file names. These names still use the local
nodename instead of the virtual host name.
The Summarization and Pruning Agent and the Warehouse Proxy
Agent do not work with DB2 9.1 Fix Pack 2
Do not try to use these agents with this version of DB2.
An error of 'can bind a LONG value only for insert' appears
The following message appears in the Warehouse Proxy Agent:
ORA-01461: can bind a LONG value only for insert into a LONG column
Upgrade to Oracle 10.1.0.5 or later.
Errors in either the Warehouse Proxy Agent or Summarization and
Pruning Agent logs
You receive the following error in either the Warehouse Proxy Agent or
Summarization and Pruning Agent logs:
DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, SQLERRMC: null
The solution is to increate the DB2 logging for the warehouse database. See the
IBM Tivoli Monitoring for Databases: DB2 Agent User's Guide for more
information.
Receive a message saying that the statement parameter can only be a
single select or a single stored procedure
You receive the following message when connecting to a Microsoft SQL Server
2000 database on a Windows 2000 system from a Warehouse Proxy Agent on a
Linux system using Microsoft SQL Server 2005 JDBC driver 1.2 April 2007. SSQL
error: Exception message: sp_cursoropen/sp_cursorprepare: The statement
parameter can only be a single select or a single stored procedure.
This was fixed by not adding by default the selectMethod=cursor string in a
Microsoft SQL Server URL, but you also must remove the string
selectMethod=cursor that comes by default when choosing the Microsoft SQL
Server database in the Warehouse Proxy Agent configuration panel on UNIX
systems.
Custom defined workspace views do not handle symbol substitution
as expected
v
v
Symbol references in the header and footer regions of custom defined workspace
views do not resolve as expected in the Tivoli Enterprise Portal. Symbol references
Chapter 10. Monitoring agent troubleshooting 197
To Next Page
Loading...
Need help?
General
