Connect the DB2 client to the server

After the DB2 server is installed, the client is installed on another machine.

The client uses the configuration assistant step by step. When connecting to the server, an error message is returned:

Sqlcode:-30081 sqlstate: 08001, which indicates a TCP/IP error, which is hard to solve.

After checking for half a day, I don't know what the problem is, but I can use the console to query the connection on the server.

So I checked the information on the Internet and found the solution as follows:

Open the CLP console on the client and execute
1. Add nodes to the customer
DB2 catalog TCPIP node generate (node name) Remote 10. 146. ***. *** (Server IP) server 50000 (port)
2. Add a database to a node
DB2 Catalog Database sample (Database Name) as sample (alias) at node generate (name of the node to be mounted)
3. Set the encoding format of the database
Db2set db2codepage = 1386 (GBK), 819 (UTF-8)
4. --- command abort

DB2 terminate

 

The third step can be skipped.

Refresh the server in connect to see the server you just added.

Done.

What is puzzling:

1. When using the assistant configuration, you can find other DB2 services created by others, but I cannot find them. Is there anything unconfigured;

2. I cannot connect to the console using the assistant, but the link can be successfully linked from the console. Is it a software issue or a configuration issue?

Hope you can give me some advice!