We are trying to add an ODBC datasource to connect to a DB2 database on an AS400. When the admin adds the entry to the .odbc.ini file and re-starts Datastage the entry does not appear in the drop-down list of DSNs to import table defs from. IBM's web site says that we must run a 'bind' process for the new entry with the command 'bind20dsn' where the dsn is the new ODBC source. When the admin tries to run the bind the OS can't find the program and a 'find' command fails to locate the file. Is something installed incorrectly?
The .odbc.ini file is in /opt/IBM/InformationServer/Server/DSEngine.
Adding an ODBC datasource for DB2 (UDB)
Moderators: chulett, rschirm, roy
Adding an ODBC datasource for DB2 (UDB)
Keith Tweedly
-
myukassign
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
Re: Adding an ODBC datasource for DB2 (UDB)
Check is it present in the following directory.
1. Change to the following $DSHOME/../branded_odbc/lib directory.
2. Enter the command bind20dsn. dsn is your dsn name
3. You may need to upate the package name in the .odbc.ini filem in the package name section of your db2 configuration
4.Lastly you need to add this dsn name in the uvodbc.config file located in your project directory and in some cases also on the same file located in the $DSHOME/bin directory.
5. Now try to import it should work
---------------------------------------------------------
1. Change to the following $DSHOME/../branded_odbc/lib directory.
2. Enter the command bind20dsn. dsn is your dsn name
3. You may need to upate the package name in the .odbc.ini filem in the package name section of your db2 configuration
4.Lastly you need to add this dsn name in the uvodbc.config file located in your project directory and in some cases also on the same file located in the $DSHOME/bin directory.
5. Now try to import it should work
---------------------------------------------------------