I have a couple of DB2 databases configured in a machine and the original ODBC profile file cannot be found. How can I know where is the server for a database? Control panel-> Administrative Tools-> Data Sources (ODBC) doesn't provide the host.
Actually you can use DB2->Set-up Tools->Configuration Assistant. When it starts, click menu Configure -> Export Profile -> All ...
Search the node of your DB in the profile file, then you will find the host name or ip address.
[NODE>MYDB]
ServerType=DB2LINUX
Nodetype=U
Protocol=TCPIP
Hostname=10.116.152.112
Portnumber=50000
Security=0
No comments:
Post a Comment