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:

• The Q.OBJECT__DIRECTORY table, which is described in Reading the Q.OBJECT__DIRECTORY table
• The Q.OBJECT__DATA table, which is described in Reading the Q.OBJECT__DATA table
• The Q.OBJECT__REMARKS table, which is described in Reading the Q.OBJECT_REMARKS table

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.

Workstation database server users: DB2 Common Server has an additional control table, Q.OBJECT_DATA2. QMF users must have INSERT privilege to this table. When all database activity is complete, this table should contain no records. If any records remain, they might be removed.

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