Creating a DSN for the tutorial table on an AIX, HP-UX, or Linux computer

You define the DSN on the computer where the IBM® InfoSphere® Information Server engine is installed. Users of the parallel job tutorial use this DSN in the Designer client to connect to the tutorial table.

Before you begin

To set up a DSN on an AIX, HP-UX, or Linux computer, you edit three files:
  • dsenv
  • odbc.ini
  • uvodbc.config
The entries that you make in each file depend on your operating system and the type of database that you are connecting to.
  1. Configuring the dsenv file
    For some ODBC connections, plug-ins, and connectors, and for interactions with external applications such as IBM WebSphere® MQ, you must add environment variables to enable interactive use of ODBC drivers to make a connection to an ODBC data source.
  2. Configuring the odbc.ini file
    The odbc.ini file provides information about connecting to databases and database applications that you use. You must configure this file so that InfoSphere DataStage® can access ODBC data sources.
  3. Configuring the uvodbc.config file
    You specify the ODBC data source name (DSN) for each database in the uvodbc.config file.
  4. Creating and binding a Db2 package to a DSN
    To use a Db2® package, you must bind it to each Db2 data source name (DSN).
  5. Configuring other ODBC drivers
    You can use ODBC drivers from other vendors to connect to data sources. However, you can use only one ODBC Manager, so you cannot use drivers from other vendors if you use the InfoSphere DataStage drivers.
  6. Testing ODBC connectivity
    After you configure ODBC connectivity that you defined for InfoSphere DataStage, test the configuration to verify your connection to the data source.
Parent topic: Creating a DSN for the parallel job tutorial table