DSXchange

Looking for someone who can show me through personal experience how they configured DataStage 9.1 to connect to a Cloud DashDB instance? I'm following their documentation but having issues or some things aren't specifically clear. For example, I've got the DashDB Linux driver installed, but there are no instructions for odbc.ini setup. Would appreciate learning what others have done, thank you!

If it's a cloud based DashDB the documentation suggests connecting via a JDBC Connector, just use the DataStage on Cloud instructions as it should work in your environment: https://www.ibm.com/support/knowledgece ... ashDB.html

If it's a local DashDB try the DB2 Connector or ODBC Connector and set it up as a DB2 database as DashDB is supposed to support all recent DB2 drivers.

Nice! The JDBC option works for us and we're on SUSE Linux 11 w/ IIS 9.1
I'll leave some notes here in case it helps anyone else searching on this.

1. Installed the IBM DasbDB driver connection software found within the "Downloads" section from the IBM DashDB Cloud Bluemix page
(ie. ibm_data_server_driver_package_linuxx64_v11.1.tar)

2. Create file "$DSHOME/DSEngine/isjdbc.config" with these lines. CLASSPATH will be wherever you installed drivers. CLASS_NAMES I'm assuming is the same for everybody. 3. In a DataStage job, the JDBC connector URL should look like this using your own <hostname>, <port>, <databasename> found on the "Connect" tab of your IBM DasbDB Cloud Bluemix page.