Before you can run reports with Tivoli® Common Reports, make sure that the
following requirements are met in your environment.
- The WebSphere® Message
Broker Monitoring agent is
installed and running.
- The Warehouse Proxy Agent is started.
- The Summarization and Pruning Agent is started.
- Historical data collection is enabled for the related attribute
group.
- Summarized tables and views are created and populated in the Tivoli Data Warehouse.
Tips: - To check whether the required summarized tables and views have
been created, run the following queries against Tivoli Data Warehouse. If the tables and views
have been correctly created, you can see the result sets that contain
HV, DV, WV, QV, and YV in each base table, for example, Broker_Statistics,
Broker_Statistics_HV, Broker_Statistics_DV, Broker_Statistics_WV,
Broker_Statistics_MV, Broker_Statistics_QV, and Broker_Statistics_YV.
- DB2
select distinct "TABNAME" from SYSCAT.TABLES where
"TABSCHEMA" = 'ITMUSER'
- Oracle
select distinct "TABLE_NAME" from USER_TABLES
- SQL Server
select TABLE_NAME "VIEWNAME" from INFORMATION_SCHEMA.TABLES
- Cognos® reports
can be run against yearly, quarterly, monthly, weekly, daily, and
hourly summarization intervals. You can decide which summarization
interval is important to you to run reports against, and enable summarization
for the related attribute group.
- WebSphere Message
Broker V7.0 or later:
- Accounting Message Flow Statistics
- Accounting Node Statistics
- Accounting Terminal Statistics
- Accounting Thread Statistics
- Broker Status
- Broker Status Events
- Components
- Execution Group Status
- File Resource Statistics
- JDBC Connection Pools Resource Statistics
- JVM Resource Statistics
- Message Flow Status
- Monitor Node Base Statistics
- Monitor Node Broker Statistics
- Monitor Node Events
- Monitor Node Execution Group Statistics
- Monitor Node Message Flow Statistics
- Monitor Node Sub-Flow Statistics
- ODBC Resource Statistics
- Parsers Resource Statistics
- Product Events
- SOAPInput Resource Statistics
- WebSphere Message
Broker V6 (all releases):
- ACL Entries
- Broker Events
- Broker Information
- Broker Statistics
- CandleMonitor Node Statistics
- Components
- Execution Group Information
- Execution Group Statistics
- Message Flow Accounting
- Message Flow Events
- Message Flow Information
- Message Flow Statistics
- Message Processing Node Information
- Multicast Group Statistics
- Multicast Summary Statistics
- Multicast Topic Statistics
- Neighbors
- Node Accounting
- Product Events
- Publish-Subscribe Statistics
- Retained Publications
- Sub-Flow Statistics
- Subscriptions
- Terminal Accounting
- Thread Accounting