DB2 graphic  QMF Version 8

Support for DB2 predictive governor

DB2 UDB for z/OS includes a predictive governing feature that is part of the Resource Limit Facility (RLF) functionality. This predictive governing feature can provide an estimate of the processing cost of SQL statements before they run.

Each database server must be set up by your DB2 administrator in order to support this predictive governing feature. If predictive governing is set up for the database server, QMF for Windows will respond to its limits. If an operation crosses a threshold set up in the predictive governor, DB2 will send an error message to QMF for Windows, and QMF for Windows will forward the message to the user.

If your installation uses predictive governing, QMF for Windows will check for the +495 and -495 SQLCODEs that predictive governing can generate after a PREPARE statement executes.


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