DB2 graphic  QMF Version 8

Maintaining QMF objects using QMF control tables

Periodically, you need to condense and reorganize the QMF control tables that store QMF queries, forms, and procedures. Regular maintenance of the QMF control tables might involve tasks such as transferring objects to new owners or enlarging the table space for the tables when it is no longer large enough to hold existing QMF objects.

For a complete list of QMF Control Tables provided by IBM, please refer to Appendix B. QMF Objects Residing in DB2.

All QMF queries, forms, and procedures are stored among three QMF control tables:

Keep QMF and the database running efficiently by periodically listing, displaying, or deleting QMF objects from these tables and reorganizing them when necessary. You might also need to use the information in these tables to transfer an object from one owner to another.

You need to assign STATS and REORG privileges to a user who is monitoring or reorganizing the control tables.


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