Historical analysis tool

Your Db2® data server installation includes a pair of Perl scripts as a sample that generate information about which tables, indexes, and columns have or have not been accessed by performing historical analysis.

These scripts provide historical analysis functionality by using information captured by the workload management activities event monitor. The workload management historical analysis tool was written in Perl; you can use these scripts as is or you can modify them to produce additional historical analysis reports to suit your needs.

The workload management historical analysis tool consists of two scripts, which can be found in the samples/perl path of your installation directory:

• wlmhist.pl - generates historical data
• wlmhistrep.pl - produces reports from the historical data.

A DB2WlmHist.pm file, which contains common Perl routines used by the two scripts, is included also.

Refer to the README_WLMHIST file found in the same file directory for more information on how to set up and run the scripts.