Setting your environment to support access to databases

When you have configured your ODBC data source names (DSNs), you must also configure the environment so that you can issue console commands, and the integration node that you start can access the required database libraries. For example, if you have a IBM® DB2® database, you must add the IBM Db2 client libraries to your library search path.

About this task

Windows platform

  1. On Windows platforms, the environment is typically set up for you when you install the database product, and no further action is required. However, some database managers provide a database profile that you must run to enable the connection from the integration node; for further information, see Running database setup scripts.

  2. If you intend to use Global Coordination (XA) with your database then the next task is Configuring ODBC connections for globally coordinated transactions.
Linux platformUNIX platform

  1. On Linux® and UNIX systems, run a profile for each database you want to access. For example, on IBM Db2 you must run db2profile; other database vendors have similar profiles. For further information, see Running database setup scripts.

  2. If you have been following the instructions in Working with databases and you intend to use Global Coordination (XA) with your database, then the next task is Configuring ODBC connections for globally coordinated transactions.