Some ODBC applications display a logon dialog box when you are connecting to a data source.

Figure 1. Logon to Db2 dialog box

The Logon to Db2 dialog box

In this dialog box, provide the following information:

  1. In the IP Address field, type either the host name or the IP address of the machine where catalog tables are stored.
  2. In the TCP Port field, type the port number that is assigned to the Db2 DRDA listener process on the server host machine. The default is 50000.
  3. Provide information in one of the following sets of fields based on the server to which you want to connect:
    • For Db2 for z/OS and iSeries:
      • In the Location field, type the name of the Db2 location that you want to access.
      • In the Collection field, type the name of the current collection or library.
    • For Db2 for Linux, UNIX, and Windows; Db2 Hosted; and Db2 Warehouse on Cloud:
      • In the Database field, type the name of the database to which you want to connect.
  4. In the User Name field, type your Db2 user name.
  5. In the Password field, type your password.
  6. Click OK to complete the logon.