Adding an ODBC datasource for DB2 (UDB)
Posted: Tue Mar 09, 2010 11:55 am
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.
The .odbc.ini file is in /opt/IBM/InformationServer/Server/DSEngine.