It is very easy to export the history data in TDW using database tools such as DB2 Command Line Editor. However, sometimes you might want to export the history data BEFORE it is collected by Warehouse. This article explains how to take a sneak-peak at the history data on the managed system/TEMS before it goes to data warehouse.
The history data on the managed system is located under
The krarloff program
You will see two files, a header file and data file, for each attribute group eligible for history collection in the history data directory. The data file is stored in a binary format and you can't extract the data using conventional tools. ITM provides a tool called krarloff for this purpose.
A word of caution though. This program renames the data file with .old extension causing the data to be skipped by the Warehouse proxy. You have to rename the file back removing the .old extension for the data collection to happen.
The following command exports the collected data into a csv file and renames the file back without .old extension for data collection.
C:\ibm\itm\tmaitm6\logs> krarloff -d , -o WTPROCESS.CSV -s WTPROCESS
C:\ibm\itm\tmaitm6\logs> move WTPROCESS.old WTPROCESS