IBM DB2 UDB or DB2 OS/390

  Perform the following steps to configure the Wire Protocol driver for IBM DB2 UDB or OS/390:

  1. In the IP Address text box, type the address (either the computer name or the numeric IP address) of the computer where the database tables are stored.

  2. In the Tcp Port text box, type the port number on which the IBM DB2 database server listens.

    • If you are using IBM DB2 UDB, the default port number is 50000.

    • If you are using IBM DB2 OS/390, the default port number is 446.

  3. If you are using IBM DB2 UDB, in the Database Name text box, type the name of the database for which you want to create this data source name.

  4. If you are using IBM DB2 OS/390, perform the following actions:

    1. In the Location text box, type the IBM DB2 location name as defined during the IBM DB2 OS/390 installation.

    2. In the Collection text box, type the name that identifies a logical group of database objects (the default is DATADIRECT00).

      Note:

      For IBM DB2 OS/390, you configure a data source name for the Data Source database only. You cannot configure a data source name for the OLAP Metadata Catalog database. OLAP Metadata Catalog functionality is not supported in IBM DB2 OS/390.

      To use Integration Services with IBM DB2 OS/390, you must add an entry to the ais.cfg file after you configure the data source name for the source database. See Adding a Configuration File Entry for IBM DB2 OS/390 in Windows for more information.

  5. Click the Bind tab.

  6. Accept the default in the Bind tab and click the Create Package button.

    For more information about the bind process, see DataDirect Technologies Connect ODBC Reference. The DataDirect documentation is located in products/common/ ODBC/Merant/6.0/books. You can also access the Product Documentation on the DataDirect Web site at http://www.datadirect-technologies.com.

  7. In the Login dialog box, type the user name and password associated with the database for which this ODBC data source name is being created, and click OK.

    A message is displayed informing you that the package was created successfully.

  8. Return to Step 6 in Configuring DataDirect Wire Protocol Drivers in Windows to complete the configuration process.