Enabling QMF catalog functionality

You can configure a relational data source in the repository so that it can use a QMF catalog. By enabling access to the QMF catalog users can access any objects that are saved in the QMF catalog and, if they choose, they can save any new objects to the QMF catalog.

About this task

The QMF catalog is a set of database tables that contain saved objects (queries, procedures and forms); user resource limits and profiles; reports; and other miscellaneous settings and information. QMF catalogs reside on database servers that host a Db2® database.
Note: QMF catalogs are now superseded by repositories. The catalogs have been retained for those who want to share QMF objects with QMF for TSO/CICS or earlier versions of the QMF distributed products. QMF repositories offer more flexibility and enable users to take advantage of all the powerful QMF features.

By configuring a data source to access a QMF catalog, users can retrieve any QMF objects that have been saved in an existing QMF catalog. Users can also save any QMF objects that they might create to a QMF catalog. This allows users to share and use objects regardless of the application version or platform that was used to create the QMF object.

In addition, if users configure a data source to access a QMF catalog, they can control resource usage with the resource limits that have been set for the data source and the user and saved in the QMF catalog.

To configure a data source so that it can access a QMF catalog:

Procedure

  1. Open the QMF Catalog Wizard.
  2. Specify what type of catalog objects you will create using the Create or update catalog objects page of the QMF Catalog Wizard.
  3. Click Next.
  4. If it was decided that a set of QMF catalog tables has never been created on the data source, the Choose object listing option page opens. Select an option and click Next. The Creating objects page of the wizard opens. The SQL to create the catalog tables is displayed. You can make changes to the SQL. If it was decided that a set of QMF catalog tables has already been created for this data source and there are no required updates, than this step is bypassed.
  5. Click Next.
  6. The Protect QMF catalog tables page of the wizard opens. From the Protect QMF catalog tables page you will specify whether the QMF catalog tables will be protected from unauthorized users. You will also specify user permission to use those stored procedures or SQL packages.
  7. Click Next.
  8. The Select QMF Catalog page of the wizard opens. From the Select QMF Catalog page you will select the QMF catalog that the data source will use.
  9. Click Finish. The QMF Catalog Wizard closes. Control returns to the Enable data source plug-ins page of the Create Relational Data Source wizard.