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.
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.
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.
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.
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.
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.