Tuesday, May 1, 2012

Missing data from the WAREHOUSELOG table

The WAREHOUSELOG table is part of the Tivoli Data Warehouse (TDW) infrastructure.  It's function is to provide an ongoing log of activity into the TDW.  If data is being sent into the TDW, this log is supposed to maintain a history of what data, how much, and if there were any errors as part of the process.  It can be a useful source of information when trying to debug issues with data not making it into the TDW.

Well, with ITM 6.23 there is apparently a change in how this table may be created or used. As of ITM 6.23, there is a new variable KHD_WHLOG_ENABLE which enables/disables the creation of the warehouse log tables to save resources.  The variable default is set to No  (KHD_WHLOG_ENABLE = N ). 

So now the default as of ITM 6.23 is to not log warehouse activity.  This is a change from how the tool used to work (by the way, I'm not a big fan of changes to defaults that alter how a tool has worked for years).  So if you use TDW, and may on occasion need to look at the WAREHOUSELOG, you may want to double check this setting.

Here's a link to a technote on how this is set:

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.