DB2 Version 9.7 for Linux, UNIX, and Windows

DB2 Governor and Query Patroller have been deprecated

Due to the introduction of DB2® workload manager as the strategic workload management solution in DB2 Version 9.5, Query Patroller and DB2 Governor have been deprecated and might be removed in a future release.

Details

Together, Query Patroller and DB2 Governor provide workload management controls to successfully run complex workloads on your DB2 data server. However, DB2 workload manager provides a greatly enhanced set of workload management features that replaces both Query Patroller and DB2 Governor.

All Query Patroller components have been deprecated, including:

The Query Patroller server (including Query Patroller stored procedures, control tables, and log files)
Query Patroller Center
Query Patroller thresholds
Query Patroller historical analysis functionality
Query Patroller registry variables: DB2_QP_BYPASS_APPLICATIONS, DB2_QP_BYPASS_USERS, DB2_QP_BYPASS_COST
The qp_query_id monitor element
The dyn_query_mgmt database configuration parameter
Query Patroller command-line support, including the following commands:
- ADD OPERATOR_PROFILE
- ADD QUERY_CLASS
- ADD SUBMISSION_PREFERENCES
- ADD SUBMITTER_PROFILE
- CANCEL QUERY
- GENERATE HISTORICAL_DATAFILE RESULT
- GET OPERATOR_PROFILE
- GET QP_SYSTEM
- GET QUERY
- GET QUERY_CLASS
- GET SUBMISSION_PREFERENCES
- GET SUBMITTER_PROFILE
- LIST OPERATOR_PROFILES
- LIST QUERIES
- LIST QUERY_CLASSES
- LIST SUBMISSION_PREFERENCES
- LIST SUBMITTER_PROFILES
- qpcenter
- qpsetup
- qpstart
- qpstop
- REMOVE OPERATOR_PROFILE
- REMOVE QUERY_CLASS
- REMOVE QUERY_INFO
- REMOVE QUERY_INFO_HISTORY
- REMOVE RESULT
- REMOVE RESULT_TABLE_ALIASES
- REMOVE SUBMISSION_PREFERENCES
- REMOVE SUBMITTER_PROFILE
- RUN HELD_QUERY
- RUN IN BACKGROUND QUERY
- SHOW RESULT
- UPDATE OPERATOR_PROFILE
- UPDATE QUERY_CLASS
- UPDATE SUBMISSION_PREFERENCES
- UPDATE SUBMITTER_PROFILE
- UPDATE QP_SYSTEM

In addition, all DB2 Governor commands have been deprecated, including:

db2gov
db2govlg

User response

You can manage workloads more effectively by using DB2 workload manager, which provides many more features.

Starting in Version 9.7 Fix Pack 1 and later fix packs, you can use a sample program (qpwlmmig.pl) that generates a script that will help migrate a Query Patroller environment to a WLM environment.