本文档详细介绍了如何通过TCP/IP协议配置DB2客户端到服务器的远程连接，包括配置TCP连接、目录化数据库节点及验证连接等步骤。
0. Prerequisite
TCP connection must be configured on DB2 server.
1. Catalog the TCP/IP node on the DB2 client side:
Command:db2 catalog tcpip node <nodename> remote <hostname> server<service_name|port>
Sample: db2 catalog tcpip node <nodename> remote 192.168.1.1server 5000
2. Catalog the database on the DB2 client:
Command: db2 catalog database <databasename> as<databasealias> at node <nodename> authentication<auth_value>
Sample:db2 catalog database <databasename> as <databasealias> at node<nodename> authentication server
The <nodename> is the value configured in step 1
3. Verify the client-server connection:
$db2 connect to <databasename> user <username> using<password>
$db2 "select 1 from sysibm.sysdummy1"
$db2 terminate
DB2 command to check current node and database information:
$ db2 list node directory
$ db2 list database directory
扫一扫
2898
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
