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
Wednesday, March 12, 2008
Exporting history data in CSV format