How to connect to db2 server in Sybase Power Designer?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ITBeamte@gmail.com - 20 Dec 2007 07:32 GMT

short history:
Power designer 12.5.0.2169 (newest one from Sybase site) version with
full functionality
I creare a new physical model. go to the menu "Database\Configure
connections\Connection profile" and create connection , for example
[ConnectionProfile]
ConnectionType=DirectConnect
Database=test111
Dbms=IBM DB2
LogId=db2inst1
LogPassword=123qwe
ServerName=lindb2.mce:50001
TrimSpaces=0
UTF8=1

when I press "Test connection" I receive message "Connection test
failed" with comment "DBMS dir direct connect interface is not
supported in your current installation".
I installed db2 run- time client (tried also to install full client
version), but nothing helps.

Reply to this Message

Lennart - 20 Dec 2007 09:17 GMT

> short history:
> Power designer 12.5.0.2169 (newest one from Sybase site) version with
[quoted text clipped - 16 lines]
> I installed db2 run- time client (tried also to install full client
> version), but nothing helps.

Have you cataloged a node and a database on that node? Otherwise, open
the db2 command window
(there might be other ways but this is how I usually do it) from the
start menu

db2 catalog tcpip node <nodename> remote <hostname> server <port in
your case 50001?> remote_instance <in your case db2inst1>

db2 catalog db test111 at <nodename>

Now you should be able to create an ODBC source for this database, and
use that from Powerdesigner.

FYI, for reverse engineering in Powerdesigner I had to rewrite a whole
bunch of queries in powerdesigner to make them work properly. The good
thing is that it is relatively easy to modify these things in PD, the
bad thing that you have to do it.

As a friendly advise, avoid posting your password.

HTH
/Lennart

Reply to this Message

ITBeamte@gmail.com - 20 Dec 2007 13:45 GMT

thanks, your method works! though I prepared ODBC drivers using
"control center" (or I assume that they were created after db2 clients
tools were installed) .then I created ODBC machine data source.
Another method I think it is to use JDBC drivers using "connection
profile", but they required Java virtual machine installed((

thanks also for friendly advise)

Dmitry

Reply to this Message