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.
CLI connections require the runtime client from DB2 Universal Database Version 6.1 or later. CLI connections to the following databases are supported:
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 |
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.
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.