DB2 graphic  QMF Version 8

Creating catalog tables

A QMF for Windows catalog is a set of database tables that contain resource limits, saved objects (queries, procedures, forms), users, reports, and other settings. This step of the Packages Wizard specifies whether the database server you are configuring hosts a QMF catalog and if so, whether a set of catalog tables needs to be created or updated.

Catalog tables have already been created

Select this option to specify that the QMF catalog tables have already been created on the database server and you are using the Packages Wizard to just rebind the QMF for Windows packages.

Create or upgrade catalog tables to support short names

Select this option to create QMF catalog tables on the database server that will support short names or update any existing QMF catalog tables that support short names.

You would select this option if you are configuring a new database server that has never had the QMF catalog tables installed and you will only use short names for objects, or you are upgrading from a previous version of QMF for Windows and the existing QMF catalog tables will continue to support only short names for objects.

Create catalog tables to support long names

Select this radio button to create QMF catalog tables on the database server that will support long names, to update any existing QMF catalog tables that support long names, or to convert existing QMF catalog tables that support short names to QMF catalog tables that support long names.

You would select this option if you are configuring a new database server that has never had the QMF catalog tables installed and you want to use long names for objects, you are upgrading from a previous version of QMF for Windows and the existing QMF catalog tables will continue to support only long names for objects, or you are converting existing QMF catalog tables that support short names to QMF catalog tables that support long names.

Note:
QMF catalog tables long name support is only available for database servers that also support long names. Check with your database server administrator to ensure that the database server you are configuring supports the use of long names.

Note:
Once you convert QMF catalog tables to support long names, only Version 8.1 or later of QMF for Windows, or QMF for WebSphere applications can be used to access those tables. Previous versions of QMF for Windows, or QMF for WebSphere cannot use long name QMF catalog tables.

Do not create catalog tables

Select this option to specify that you are not creating the QMF catalog tables on the selected database server. You would select this option if the database server is not hosting a QMF catalog but will be using a QMF catalog that resides on a different database server or if the selected database server is not gong to use a QMF catalog at all.

Note:
The QMF catalog tables can be shared by multiple database servers. To use a QMF catalog that already exists on a different database server, check the Do not create catalog tables check box for the database server that you are configuring. Then, using the Catalog page of the Parameters window, you can select the database server that hosts the QMF for Windows catalog that will be used by the database server you are configuring.

There are several reasons to have database servers share a QMF catalog. One reason is that ODBC database servers cannot host the QMF catalog. The QMF catalog for an ODBC database server must reside on a DB2 UDB database server that is connected using TCP/IP, SNA or CLI. Another reason to share a catalog is to streamline QMF for Windows catalog maintenance or to control an end-user's view of the database objects stored in the catalog.

Note:
If this option is selected, only the RAARDBI1 and RAARDBIL packages will be bound.


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