Datastage ODBC Connection Problems - Part 3

Datastage ODBC Problem : Checking symbolic links :DK®


If your ODBC connection does not work, check your symbolic links. Cannot connect to database using ODBC connection.This problem occurs when using ODBC connections in a UNIX environment.DK®

Identify the Issue :DK®

If you have moved shared libraries to a new directory or have installed a new ODBC driver manager, you might have broken symbolic links that the engine uses to access the shared libraries for the source database.

Solution Of the problem:DK®

To reset the symbolic links to a new directory, run this command at the UNIX prompt:
# $DSHOME/bin/dspackinst relink.uvlibs pathname
$DSHOME is the home directory of the server engine. pathname is the full path name of the directory that contains the shared libraries.
To reset links for a new ODBC driver manager:DK®
  1. Install the ODBC driver manager according to the vendor's instructions.
  2. Determine where the ODBC shared library libodbc.xx resides. For example, the library for the Intersolv driver is in $ODBCHOME/ dlls,
    and the library for the Visigenics driver is in
    $ODBCHOME/ libs.
  3. Close all InfoSphere DataStage clients.
  4. Run the relink.uvlibs command as described above.
  5. Restart the InfoSphere DataStage clients.


    Other Related Topics :DK®
    Click here for Datastage ODBC Connection Problems - Part1DK®
    Click here for Datastage ODBC Connection Problems - Part2
    DK®

No comments:

Post a Comment