DB2远程登录配置

来源：互联网发布：dreamweaver mac 编辑：程序博客网时间：2024/05/29 09:05

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

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

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

1.服务器端操作

[db2inst2@xifenfei ~]$netstat-nap |grepdb2sysc
(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/db2sysc0     
[db2inst2@xifenfei ~]$  db2 list db directory
 
 System Database Directory
 
 Number of entriesinthe directory = 1
 
Database 1 entry:
 
 Databasealias                      = XIFENFEI
 Database name                        = XIFENFEI
 Local database directory             =/home/db2inst2/xifenfei
 Database release level               = c.00
 Comment                              =
 Directory entrytype                = Indirect
 Catalog database partition number    = 0
 Alternate serverhostname           =
 Alternate server port number         =
 
--配置监听协议
[db2inst2@xifenfei ~]$ db2set db2comm=tcpip
 
--配置实例端口
[db2inst2@xifenfei ~]$ db2 update dbm cfg using svcename 5000
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATIONcommandcompleted
successfully.
 
--重启生效
[db2inst2@xifenfei ~]$ db2stop
04/02/201212:33:36     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2inst2@xifenfei ~]$ db2start
04/02/201212:33:41     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
[db2inst2@xifenfei ~]$netstat-nap |grepdb2sysc
(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/db2sysc0

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/LINUX9.5.0
 SQL authorization ID   = DB2INST1
 Local databasealias  = 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  

0 0