DB2 graphic  QMF Version 8

Connect using DB2 for Windows CLI

Select this option to specify that QMF for Windows will connect to the DB2 database server that you are configuring in the SDF using DB2 for Windows CLI connectivity. To access a database server using DB2 for Windows CLI, the 32-bit version of QMF for Windows must establish a CLI connection from the local host to the remote host via the DB2 Universal Database client. All of the connectivity information is defined in the DB2 UDB client.

Note:
This configuration is outside the control of QMF for Windows. Work with your in-house networking staff to implement and support your network configuration.

CLI connections require the runtime client from DB2 Universal Database Version 6.1 or later. CLI connections to the following databases are supported:

Table 13. Supported CLI Connections
Database Version Prerequisite
DB2 Universal Database Server for OS/390 and z/OS 7.1 DB2 Connect personal edition (installed locally) or enterprise edition (installed on a gateway)
DB2 Universal Database Server for OS/390 6.1 DB2 Connect personal edition (installed locally) or enterprise edition (installed on a gateway)
DB2 for OS/390 5.1 DB2 Connect personal edition (installed locally) or enterprise edition (installed on a gateway)
DB2 for MVS 2.3; 3.1; 3.4; 4.1 DB2 Connect personal edition (installed locally) or enterprise edition (installed on a gateway)
SQL/DS for VM/VSE 3.4 DB2 Connect personal edition (installed locally) or enterprise edition (installed on a gateway)
DB2 for AS/400 4.3; 4.4 DB2 Connect personal edition (installed locally) or enterprise edition (installed on a gateway)
DB2 for iSeries 5.1
DB2 Universal Database 5.1; 5.2; 6.1; 7.1; 7.2
DB2 Common Server 2.1
DB2 Information Integrator for AIX and Windows NT 2.1
Information Integrator for AIX 1.2
DB2 Parallel Edition for AIX 1.2

Note:
Although QMF for Windows supports CLI connectivity to DB2 for MVS, using a DRDA connection to the DB2 for MVS database is recommended.

Database alias

Use this field to specify the name of the database server that is defined in your DB2 Universal Database client software.

A CLI connection uses a simplified configuration. If a database is defined in the DB2 Universal Database client, QMF for Windows only needs its alias. The network configuration is performed as part of the DB2 Universal Database client configuration rather than as a part of QMF for Windows configuration.

Advanced

Optional: Use the Advanced button to specify driver-specific connection string keywords and their values that are to be used when connecting to a database server using CLI connectivity. The syntax and allowable values for the keywords are determined by the driver; refer to the driver documentation for more information.

The Advanced DSN Settings window opens where you specify the connection string keywords that will be included in the connection string for the CLI network connection.


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