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:
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.