Creating an extended catalog

You can create extended QMF catalogs to organize user access to objects within the overall default QMF catalog.

About this task

Instead of all objects being in the main default catalog, they can be isolated in smaller extended catalogs. There are many reasons to use extended catalogs. You can use them to control a user's view of objects. You can use them to isolate objects from one data source that is sharing a QMF catalog on another data source. An extended catalog can contain only the selected objects from a specific data source. You can also set up extended catalogs that have different CCSID settings from the main Default catalog.

Note: Performance, a user's views of objects, and the overall maintenance of your query environment can be adversely impacted when a data source uses an extended catalog (or a Default catalog) that resides on a different data source.

To create an extended catalog:


  1. Open the Add Catalog window.
  2. Specify a unique name for the extended catalog in the Name field.
  3. Select a CCSID code page for the extended catalog from the CCSID list.
  4. Optional: Select the Create system profile entry check box to create an entry in the System Profile table that is stored on the catalog server. A catalog server is a database server on which a QMF catalog resides. If you select this check box, QMF will create a user profile entry so that users can access the database with their own user IDs; otherwise the user IDs must be assigned to a group.
  5. Click OK. The new extended catalog is created.