Why are my Tivoli Common Reports failing after the turn of the year?
Jhelbig 0100002GTU Visits (7521)
Every year after the turn of the year, some clients are surprised that after the 01.01. their Tivoli Common Reports are not longer working. The reason and solution is easy and caused by the TIME_RANGE_END date in the IBM_
When you run an ITM Warehouse Database on DB2 run the following commands:
you will get a result like;
1 record(s) selected.
db2 call IBM_
When you have an Oracle or Microsoft SQL Database for your IBM Tivoli Monitoring Warehouse, so please have a look at:
Creating and populating the time dimensions tables
PS: the mentioned db2inst1 is the instance owner of your Warehouse instance and itmuser the name of the Warehouse schema. This can be a different name on your system.
Subscribe and follow us for all the latest information directly on your social feeds: