IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions: common procedures
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
WAREHOUSELOG and WAREHOUSEAGGREGLOG tables
The WAREHOUSELOG table lets you know how many exports succeed and how many failed because of an ODBC error or a timeout value issue.
The WAREHOUSELOG table has the following columns. All times are the local time on the machine where the Warehouse Proxy instance is running.
- ORIGINNODE
- The name of the computer that made the request. This name is the node name for the agent. For example, Primary::box1:NT.
- OBJECT
- The attribute group that submitted the request. For example, NT_System.
- STARTQUEUE
- The time when the request was inserted in the work queue. For example, 10508201154000000.
- ENDQUEUE
- The time when the request exited the work queue. For example, 10508201155000000.
- STARTEXPORT
- The amount of time that elapsed before the first row of the sample request was retrieved. For example, 105082011562000000.
- EXPORTTIME
- The amount of time after the export request transaction was committed. For example, 10508201157000000.
- ROWSINSERTED
- The number of row inserted in the database for the request. For example, 1000.
- ROWSRECEIVED
- The number of rows retrieved from the RPC source. For example, 1000.
- ROWSSKIPPED
- This column is not used.
- STARTTIME
- The start time of the collection for that sample. For example, 10508150920000000.
- ENDTIME
- The end time of the collection for that sample. For example, 1050815092000000.
- ERRORMSG
- An error message when no rows are inserted in the database. The error message can indicate an ODBC error or a TIMEOUT error. For example:
Sample data rejected for timeout reason at stage COMMIT EXPORT
- WPSYSNAME
- The name of the Warehouse Proxy Agent that inserted the rows into the database.
The WAREHOUSEAGGREGLOG table logs the progress of the Summarization and Pruning Agent as it is processing data. Each time the Summarization and Pruning Agent executes, it adds an entry for each attribute group (OBJECT column), and origin node (ORIGINNODE column) that was processed. The WAREHOUSEAGGREGLOG table contains the following columns:
- ORIGINNODE
- The name of the computer that is being summarized. This name is the node name for the agent. For example, Primary::box1:NT. -
- OBJECT
- The attribute group that was processed.
- LOGTMZDIFF
- The time zone difference for the Summarization and Pruning Agent.
- MINWRITETIME
- The minimum WRITETIME value that was read from the sample data for the specified ORIGINNODE and OBJECT.
- MAXWRITETIME
- The maximum WRITETIME value that was read from the sample data for the specified ORIGINNODE and OBJECT
- STARTTIME
- The time that the Summarization and Pruning Agent processing began for the specified ORIGINNODE and OBJECT.
- ENDTIME
- The time that the Summarization and Pruning Agent processing ended for the specified ORIGINNODE and OBJECT.
- ROWSREAD
- The number of sample data rows read for the specified ORIGINNODE and OBJECT in the time interval MINWRITETIME and MAXWRITETIME.
Parent topic:
Tivoli Data Warehouse solutions: common procedures