DB2远程登录配置

发表于 2012 年 04 月 12 日 由 惜分飞

联系：手机(13429648788) QQ(107644445)

链接：http://www.xifenfei.com/2891.html

1.服务器端操作

[db2inst2@xifenfei ~]$ netstat -nap | grep db2sysc (Not all processes could be identified, non-owned process info   will not be shown, you would have to be root to see it all.) tcp        0      0 0.0.0.0:55554               0.0.0.0:*                   LISTEN      8072 /db2sysc 0      [db2inst2@xifenfei ~]$  db2 list db directory     System Database Directory     Number of entries in the directory = 1   Database 1 entry:     Database alias                       = XIFENFEI   Database name                        = XIFENFEI   Local database directory             = /home/db2inst2/xifenfei   Database release level               = c.00   Comment                              =   Directory entry type                 = Indirect   Catalog database partition number    = 0   Alternate server hostname            =   Alternate server port number         =   --配置监听协议 [db2inst2@xifenfei ~]$ db2set db2comm=tcpip   --配置实例端口 [db2inst2@xifenfei ~]$ db2 update dbm cfg using svcename 5000 DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.   --重启生效 [db2inst2@xifenfei ~]$ db2stop 04 /02/2012 12:33:36     0   0   SQL1064N  DB2STOP processing was successful. SQL1064N  DB2STOP processing was successful. [db2inst2@xifenfei ~]$ db2start 04 /02/2012 12:33:41     0   0   SQL1063N  DB2START processing was successful. SQL1063N  DB2START processing was successful. [db2inst2@xifenfei ~]$ netstat -nap | grep db2sysc (Not all processes could be identified, non-owned process info   will not be shown, you would have to be root to see it all.) tcp        0      0 0.0.0.0:50000               0.0.0.0:*                   LISTEN      8462 /db2sysc 0

2.客户端配置

C:\Windows\system32>db2 catalog tcpip node vm_xff remote 192.168.1.90 server 50000 DB21061E  未初始化命令行环境。   --DB21061E错误解决 C:\Windows\system32>db2cmd   --编目节点 C:\Windows\system32>db2 catalog tcpip node vm_xff remote 192.168.1.90 server 50000 DB20000I  CATALOG TCPIP NODE命令成功完成。 DB21056W  直到刷新目录高速缓存之后，目录更改才生效。   --编目数据库 C:\Windows\system32>db2 catalog db xifenfei as xifenfei at node vm_xff DB20000I  CATALOG DATABASE命令成功完成。 DB21056W  直到刷新目录高速缓存之后，目录更改才生效。   C:\Windows\system32> db2 list node directory     节点目录     目录中的条目数 = 1   节点 1 条目：     节点名                            = VM_XFF   注释                            =   目录条目类型                    = LOCAL   协议                            = TCPIP   主机名                          = 192.168.1.90   服务名称             = 50000   --terminate使操作生效 C:\Windows\system32>db2 terminate DB20000I  TERMINATE命令成功完成。

3.验证登陆

[db2inst2@xifenfei sqldbdir]$ db2 connect to xifenfei user db2inst2 using xifenfei       Database Connection Information     Database server        = DB2 /LINUX 9.5.0   SQL authorization ID   = DB2INST1   Local database alias   = XIFENFEI   [db2inst1@xifenfei ~]$ db2 list applications   Auth Id  Application    Appl.      Application Id                                                 DB       # of           Name           Handle                                                                    Name    Agents -------- -------------- ---------- -------------------------------------------------------------- -------- ----- DB2INST2 db2bp.exe      45         192.168.1.1.38849.120411160214                                 XIFENFEI   1    DB2INST2 db2bp          50         *LOCAL.db2inst1.120402072313                                   XIFENFEI   1