DB2 Version 9.7 for Linux, UNIX, and Windows

FP1: Script facilitates migration from Query Patroller to workload manager

Starting with Version 9.7 Fix Pack 1, a sample script (qpwlmmig.pl) has been provided to facilitate the migration from the deprecated DB2® Query Patroller (QP) environment to the DB2 workload manager (WLM) environment. This script generates a file which contains the DDL statements to create the WLM objects that most closely reflect your current QP setup.

For the most part, you can continue to use the same system control approach that QP currently uses until you determine how best to use the WLM capabilities.