Now that it appears data on z/OS Common Storage utilization is flowing to the TDW, be aware that there is information readily available to track on an ongoing basis the amount of data flowing to the TDW, and to show indications of potential issues with TDW history collection.
In the Tivoli Portal there are workspaces that show the status of the Warehouse Proxy, and also track history row processing counts and history collection error counts. The example below shows the Warehouse Proxy statistics workspace.
Now that we see there is a potential issue with data making its way into the TDW database, how do you get more information on what the problem may be? First, you can look at the log for the Warehouse Proxy process. Also, you can look at the Warehouselog table in the TDW database (this is assuming you have it enabled - be aware of an earlier blog post I made on this not being on by default in ITM 6.23).
I the following example I show information selected from the Warehouselog table in the TDW. The Warehouselog table shows row statistics and error message information (if applicable) for each attempted insert to the TDW.
As you can see there is quite a bit of information available to track the status and activity of TDW, and it is worth checking this information on an ongoing basis to ensure history collection is proceeding normally.