远程连接问题
[db2inst1@localhost ~]$ db2set
DB2COMM=TCPIP
dbm参数设置：
TCP/IP Service name (SVCENAME) = 50000
2： windows客户端的命令：
D:appdb2db2v105SQLLIBBIN>db2 catalog tcpip node mynode1 remote 192.168.44.1
29 server 50000 remote_instance db2inst1
DB20000I CATALOG TCPIP NODE 命令成功完成。
DB21056W 直到刷新目录高速缓存之后，目录更改才生效。
D:appdb2db2v105SQLLIBBIN>db2 catalog db mydb at node mynode1
DB20000I CATALOG DATABASE 命令成功完成。
DB21056W 直到刷新目录高速缓存之后，目录更改才生效。
连接db2数据库：
D:appdb2db2v105SQLLIBBIN>db2 connect to mydb user db2inst1 using db2
SQL30081N 检测到通信错误。正在使用的通信协议："TCP/IP"。正在使用的通信
API："SOCKETS"。检测到错误的位置："192.168.44.129"。检测到错误的通信功能：
"connect"。特定于协议的错误代码："10060"、"*" 和 "*"。 SQLSTATE=08001
请问各位是什么原因哪？
操作系统间能够ping通：
D:appdb2db2v105SQLLIBBIN>ping 192.168.44.129
正在 Ping 192.168.44.129 具有 32 字节的数据:
来自 192.168.44.129 的回复: 字节=32 时间=15ms TTL=64
来自 192.168.44.129 的回复: 字节=32 时间<1ms TTL=64
来自 192.168.44.129 的回复: 字节=32 时间<1ms TTL=64
8同行回答
可是现在db2start启动时却出现下面的问题：
[db2inst1@localhost db2dump]$ db2start
SQL5043N Support for one or more communications protocols specified in the DB2COMM environment variable failed to start successfully. However, core database manager functionality started successfully.
db2diag.log里面的内容：
2013-07-22-17.26.33.106553+480 I16442496G387 LEVEL: Error
PID : 24691 TID : 2994727792 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
HOSTNAME: localhost.localdomain
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:47
MESSAGE : DIA3202C The TCP/IP call "bind" returned an errno="13".收起
db2set -all
[i] DB2_CAPTURE_LOCKTIMEOUT=ON
[i] DB2_OPT_MAX_TEMP_SIZE=512
[i] DB2_ENABLE_AUTOCONFIG_DEFAULT=yes
[i] DB2PROCESSORS=1
[i] DB2CODEPAGE=1386
[i] DB2AUTOSTART=yes
[g] DB2_COMPATIBILITY_VECTOR=MYS
[g] DB2SYSTEM=db2
[g] DB2ADMINSERVER=dasusr1
db2set
DB2_CAPTURE_LOCKTIMEOUT=ON
DB2_OPT_MAX_TEMP_SIZE=512
DB2_ENABLE_AUTOCONFIG_DEFAULT=yes
DB2PROCESSORS=1
DB2CODEPAGE=1386
DB2AUTOSTART=yes
db2set DB2COMM=TCPIP,NETBIOS
db2set
DB2_CAPTURE_LOCKTIMEOUT=ON
DB2_OPT_MAX_TEMP_SIZE=512
DB2_ENABLE_AUTOCONFIG_DEFAULT=yes
DB2PROCESSORS=1
DB2COMM=TCPIP,NETBIOS
DB2CODEPAGE=1386
DB2AUTOSTART=yes
>db2 update dbm cfg using svcename 50000
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
重启数据库再试试收起
Using the DB2 Database Assistant to create an ODBC source, the remote DB2 instance cannot be discovered/contacted. The following error is seen:
The search for databases on the network failed.
Entire error message is:
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". ....... Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
The remote instance hasn't been setup to listen for tcpip connections.
Resolving the problem
db2 update dbm cfg using
db2set -all
db2set db2comm=tcpip
db2stop force
db2start
Retry the DB2 database discovery/ODBC source creation.