Some ODBC applications display a logon dialog box when you are connecting to a data source. In these cases, the data source name has already been specified.
In this dialog box, provide the following information:
1. In the Ip Address field, type the IP (Internet Protocol) address of the machine where the catalog tables are stored. Specify the address using the machine's numeric address (for example, 123.456.78.90) or specify its host name. If you enter a host name, the driver must find this name (with the correct address assignment) in the HOSTS file on the workstation or in a DNS server. The default is localhost.
The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. See Using IP Addresses for details concerning these formats.
2. In the Tcp Port field, type the port number that is assigned to the DB2 server on the machine where the catalog tables are stored. Specify either this port's numeric address or its service name (50000 is the default port address). If you specify a service name, the driver must find this name (with the correct port assignment) in the SERVICES file on the workstation.
3. If you are running DB2 for z/OS or DB2 for i, perform Steps 3a and 3b. Otherwise, skip to Step 4.
a. In the Location field, type the DB2 location name. Use the name defined during the local DB2 installation.
b. By default, the User ID is used for the value of Collection. The User ID must always be used on DB2 for z/OS.
On DB2 for i, you can type the name of the schema that is to be the default qualifier for unqualified object names. If you want to access a table outside of this schema, you need to specify the appropriate two-part name, for example, SELECT * FROM Schema.Tablename. On DB2 for i only, Collection is also the current library.
Skip to Step 5.
4. If you are running DB2 for Linux/UNIX/Windows, type the name of the database to which you want to connect in the Database field.
5. If required, type your logon ID in the User Name field.
6. If required, type your password in the Password field.
7. Click OK to complete the logon and to update the values in the Registry.
