DB2 graphic  QMF Version 8

Using Object Tracking to reduce resource consumption

Object Tracking can help you improve query run times and reduce resource consumption at the database server. Using object tracking you can identify the queries that are executed most frequently on the database server. By converting those frequently run dynamic SQL queries (all queries created in QMF for Windows are dynamic SQL) to static SQL, you can improve their efficiency.

You can do the conversion using QMF for Windows. Open the query and select the Bind Static Package command from the File menu. Your user ID must have the authority to bind static packages on the database server. The QMF for Windows administrator's user ID should have that authority. You can grant permission to bind static packages on the database server to other users, using the Binding option page when specifying resource limits.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004