Originally posted by: kumar.prashanth

How Do I configure a remote database in the Database Interface Designer? I was able to configure a local db2 instance and create type trees and the query file and create a transformation map using the generated type tree. But I am facing issue while configuring a remote DB2 instance. I am getting the below error when I use the JDBC type 4 URI as the datasource (jdbc:db2://192.168.189.131:50000/SAMPLE).

What am I doing wrong? Any pointers on this is greatly appreciated.

Thanks

Prashanth

<9756-6524-10/29/14 16:51:03>: SQLConnect failed.
<9756-6524-10/29/14 16:51:03>: Database connect status: rc = -1005, count = 0.
<9756-6524-10/29/14 16:51:37>: Datasource :
<9756-6524-10/29/14 16:51:37>: UserID     : db2inst1
<9756-6524-10/29/14 16:51:37>: Password   : *****
<9756-6524-10/29/14 16:51:37>: Context: Output Card, Transaction scope:
<9756-6524-10/29/14 16:51:37>: On Failure: Commit, On Success:
<9756-6524-10/29/14 16:51:37>: No existing connection was found.
<9756-6524-10/29/14 16:51:37>: Error in SQLConnect

Message: [IBM][CLI Driver] SQL1013N  The database alias name or database name " " could not be found.  SQLSTATE=42705 SQL State: 08001
<9756-6524-10/29/14 16:51:37>: SQLConnect failed.
<9756-6524-10/29/14 16:51:37>: Database connect status: rc = -1005, count = 0.

Originally posted by: paul.brett

If you use the native DB2 adapter, the only connection names supported are those listed in the DB2 connections profile.

You can export your connections profile with:

db2cfexp profile_export.txt maintain

Edit the file created (profile_export.txt) to add new entries, and re-import with:

db2cfimp profile_export.txt

There used to be a GUI included with DB2 for editing this file, but it no longer appears to be supported.

Thank-you.

Paul

Follow me on Twitter

Originally posted by: SaiIBM

Sample db2export.txt attached 

sample command : 

Thx

-Srini

Attachment(s)

db2export.txt   2 KB 1 version