1.增加编目节点http://www.cndba.cn/hbhe0316/article/4769http://www.cndba.cn/hbhe0316/article/4769

[db2inst1@db01 ~]$ db2 catalog tcpip node node2 remote 192.168.2.123 server 50000
DB20000I  The CATALOG TCPIP NODE command completed successfully.
DB21056W  Directory changes may not be effective until the directory cache is 
refreshed.

2.查看节点编目http://www.cndba.cn/hbhe0316/article/4769

[db2inst1@db01 ~]$ db2 list node directory

 Node Directory

 Number of entries in the directory = 1

Node 1 entry:

 Node name                      = NODE2
 Comment                        =
 Directory entry type           = LOCAL
 Protocol                       = TCPIP
 Hostname                       = 192.168.2.123
 Service name                   = 50000

3.数据库编目，as后面的别名不超过8个字符

[db2inst1@db01 ~]$ db2 catalog db testdb as testdb12 at node node2
DB20000I  The CATALOG DATABASE command completed successfully.
DB21056W  Directory changes may not be effective until the directory cache is 
refreshed.

4.查看数据库

[db2inst1@db01 ~]$ db2 list db directory

 System Database Directory

 Number of entries in the directory = 3

Database 1 entry:

 Database alias                       = TESTDB
 Database name                        = TESTDB
 Local database directory             = /db2data/testdb
 Database release level               = 10.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

 Database 2 entry:

 Database alias                       = TESTDB12
 Database name                        = TESTDB
 Node name                            = NODE2
 Database release level               = 10.00
 Comment                              =
 Directory entry type                 = Remote
 Catalog database partition number    = -1
 Alternate server hostname            =
 Alternate server port number         =

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle