On Dec 20, 8:32 am, ITBea...@gmail.com wrote:
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.
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 <nodenameremote <hostnameserver <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