SQLDBX Remote Link DB2 database

1. Download IBM Data Server Client First, Baidu Cloud Link: Http://pan.baidu.com/s/1kVBVjan Password: 2GTZ

2. After installing the client, open cmd and run db2cmd. Then perform the following steps in Db2cmd.

The first step is to create the node

Syntax: DB2 catalog TCPIP nodes < node names > remotes < remote database address > server < port number >

Example: DB2 catalog TCPIP node Mynode remote 192.168.1.90 server 50000

Step two, create the remote DB instance

Syntax: DB2 catalog DB < remote database name > as < local alias > at node < created node name >

Example: DB2 catalog db Remotedbname as mydbname at node Mynode

Step three, connect the database

Syntax: DB2 CONNECT to < contact name > user < username > Using < password >

Example: DB2 CONNECT to Mydbname user username using Pssword (user name and password are the user name and password for remote server)

Reference Links: http://www.xuebuyuan.com/450788.html

SQLDBX Remote Link DB2 database