sniger
asked on
db2 how to connect to remote database from my
Hi, how to define the remote connection in my local db2 instance running on mac, I want to connect to a db2 database running on port 5000 on some IP address. On my local mac I have db2 instance running, and db2 prompt
ASKER
So, I don't need connect command ?
How to SQL then dbname ?
How to SQL then dbname ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
From the DB2 command line processor, use the CATALOG TCPIP NODE and the CATALOG DATABASE commands
CATALOG TCPIP NODE nodename REMOTE {hostname | IP address} SERVER 50000
CATALOG DATABASE dbname [as localname] AT NODE {nodename}
Good Luck!
Kent