Tailoring QMF for Workstation Database Servers

In this chapter all of the following DB2 products are referred to collectively as the DB2 DRDA AS. When it is necessary, a more specific reference is made to one of the following products:

• DB2 Universal Database^(TM) Version 5 (UDB for AIX, DB2 for NT, ...)
• DB2 Common Server Version 2.1 (DB2 for AIX, DB2 for NT, ...)
• DB2 Parallel Edition Version 1.2
• DataJoiner^(R) Version 1.2

QMF support for a DB2 DRDA AS is optional. You only need to perform the steps described in this chapter if you intend to connect QMF to any of the previously described DB2 DRDA Application Servers.

Before you install QMF into a DB2 DRDA AS from OS/390, you need to make the following preparations for DB2 Common Server, DB2 Parallel Edition, or DataJoiner:

• Create an installation ID on the platform of the DB2 DRDA AS and make it a member of the SYSADM GROUP.
• Create the database on the platform of the DB2 DRDA AS using the following command:

  "db2 create database" <database-name>

  Note: Normally you will want the created database to have authentication SERVER, which is the default. However, due to password handling restrictions with Microsoft SNA Server (on Windows NT), it is necessary to change the database to have authentication CLIENT. Refer to the appropriate DB2 Command Reference manual for the specific system commands to use for setting database authentication.

• On the platform of the DB2 DRDA AS, locally connect to the installation ID and verify that its authority level is SYSCRTL or SYSADM, using the commands:

  "db2 connect to" <database-name>
                  "user" <sysadm-id> "using" <password>
   
        "db2 get authorizations"

• (Optional) Grant additional administrative authorities to groups, users, or PUBLIC, as needed. If you install QMF into DB2 for VM or VSE server from OS/390, you must create public and private dbspaces. QMF needs some of the public dbspaces for tables, queries, procedures, forms, and data.

The following steps apply to QMF migration and to first-time QMF installations.

Check the step's completion code in the system messages. Completion messages can be found in the SYSTSPRT or the SYSTERM output, as indicated. SYSPRINT provides additional diagnostic information for IBM support.