连接到V9远程数据库时出错 [英] Error connecting to V9 remote database

查看:181
本文介绍了连接到V9远程数据库时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好,


我在连接到新的v9数据库盒时遇到问题。相关的

信息如下:


DB2_db2inst1 60000 / tcp

DB2_db2inst1_1 60001 / tcp

DB2_db2inst1_2 60002 / tcp

DB2_db2inst1_END 60003 / tcp

TCP / IP服务名称(SVCENAME)= DB2_db2inst1


[db2inst1 @mairhtin db2dump] $ db2set

AUTOSTART =是

DB2COMM = tcpip

SQL30081N检测到通信错误。沟通

协议

正在使用:TCP / IP。正在使用的通信API:SOCKETS。

位置

其中检测到错误:67.170.223.55。沟通

功能

检测错误:连接。协议特定错误代码:

" 10061"," *",

" *"。 SQLSTATE = 08001

db2目录tcpip节点homesvr远程67.170.223.55服务器DB2

_db2inst1

db2 catalog db sample as sample2 at node homesvr

数据库2条目:


数据库别名= SAMPLE2

数据库名称=样本

节点名称= HOMESVR

数据库发布级别= b.00

评论=

目录条目类型=远程

目录数据库分区号= -1

备用服务器主机名=

备用服务器端口号=


节点1条目:


节点名称= HOMESVR

评论=

目录条目类型= LOCAL

协议= TCPIP

主机名= 67.170.223.55

服务名称= DB2_db2inst1

任何帮助都将不胜感激。


Mairhtin O''Feannag

解决方案

db2set

AUTOSTART =是

DB2COMM = tcpip


SQL30081N检测到通信错误。沟通

协议

正在使用:TCP / IP。正在使用的通信API:SOCKETS。

位置

其中检测到错误:67.170.223.55。沟通

功能

检测错误:连接。协议特定错误代码:

" 10061"," *",

" *"。 SQLSTATE = 08001

db2目录tcpip节点homesvr远程67.170.223.55服务器DB2

_db2inst1

db2 catalog db sample as sample2 at node homesvr

数据库2条目:


数据库别名= SAMPLE2

数据库名称=样本

节点名称= HOMESVR

数据库发布级别= b.00

评论=

目录条目类型=远程

目录数据库分区号= -1

备用服务器主机名=

备用服务器端口号=


节点1条目:


节点名称= HOMESVR

评论=

目录条目类型= LOCAL

协议= TCPIP

主机名= 67.170.223.55

服务名称= DB2_db2inst1

任何帮助将不胜感激。


Mairhtin O''Feannag


4月23日上午11点34分,mairhtin o''feannag < n ... @ none.comwrote:


您好,


我在连接到我的时遇到问题新的v9数据库框。相关的

信息如下:


DB2_db2inst1 60000 / tcp

DB2_db2inst1_1 60001 / tcp

DB2_db2inst1_2 60002 / tcp

DB2_db2inst1_END 60003 / tcp

TCP / IP服务名称(SVCENAME)= DB2_db2inst1


[db2inst1 @mairhtin db2dump]


db2set

AUTOSTART = yes

DB2COMM = tcpip


SQL30081N检测到通信错误。沟通

协议

正在使用:TCP / IP。正在使用的通信API:SOCKETS。

位置

其中检测到错误:67.170.223.55。沟通

功能

检测错误:连接。协议特定错误代码:

" 10061"," *",

" *"。 SQLSTATE = 08001

db2目录tcpip节点homesvr远程67.170.223.55服务器DB2

_db2inst1

db2 catalog db sample as sample2 at node homesvr


数据库2条目:


数据库别名= SAMPLE2

数据库名称=样本

节点名称= HOMESVR

数据库发布级别= b.00

评论=

目录条目类型=远程

目录数据库分区号= -1

备用服务器主机名=

备用服务器端口号=


节点1条目:


节点名称= HOMESVR

评论=

目录条目类型= LOCAL

协议= TCPIP

主机名= 67.1 70.223.55

服务名称= DB2_db2inst1


任何帮助将不胜感激。


Mairhtin O''Feannag




你的远程服务器启动了吗?


Hello,

I''m having problems connecting to my new v9 db box. The pertinent
information is below:

DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp

TCP/IP Service name (SVCENAME) = DB2_db2inst1

[db2inst1@mairhtin db2dump]$ db2set
AUTOSTART=yes
DB2COMM=tcpip

SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "67.170.223.55". Communication
function
detecting the error: "connect". Protocol specific error code(s):
"10061", "*",
"*". SQLSTATE=08001

db2 catalog tcpip node homesvr remote 67.170.223.55 server DB2
_db2inst1
db2 catalog db sample as sample2 at node homesvr
Database 2 entry:

Database alias = SAMPLE2
Database name = SAMPLE
Node name = HOMESVR
Database release level = b.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Node 1 entry:

Node name = HOMESVR
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 67.170.223.55
Service name = DB2_db2inst1
Any help would be appreciated.

Mairhtin O''Feannag

解决方案

db2set
AUTOSTART=yes
DB2COMM=tcpip

SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "67.170.223.55". Communication
function
detecting the error: "connect". Protocol specific error code(s):
"10061", "*",
"*". SQLSTATE=08001

db2 catalog tcpip node homesvr remote 67.170.223.55 server DB2
_db2inst1
db2 catalog db sample as sample2 at node homesvr
Database 2 entry:

Database alias = SAMPLE2
Database name = SAMPLE
Node name = HOMESVR
Database release level = b.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Node 1 entry:

Node name = HOMESVR
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 67.170.223.55
Service name = DB2_db2inst1
Any help would be appreciated.

Mairhtin O''Feannag


On Apr 23, 11:34 am, "mairhtin o''feannag" <n...@none.comwrote:

Hello,

I''m having problems connecting to my new v9 db box. The pertinent
information is below:

DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp

TCP/IP Service name (SVCENAME) = DB2_db2inst1

[db2inst1@mairhtin db2dump]


db2set
AUTOSTART=yes
DB2COMM=tcpip

SQL30081N A communication error has been detected. Communication
protocol
being used: "TCP/IP". Communication API being used: "SOCKETS".
Location
where the error was detected: "67.170.223.55". Communication
function
detecting the error: "connect". Protocol specific error code(s):
"10061", "*",
"*". SQLSTATE=08001

db2 catalog tcpip node homesvr remote 67.170.223.55 server DB2
_db2inst1
db2 catalog db sample as sample2 at node homesvr

Database 2 entry:

Database alias = SAMPLE2
Database name = SAMPLE
Node name = HOMESVR
Database release level = b.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Node 1 entry:

Node name = HOMESVR
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 67.170.223.55
Service name = DB2_db2inst1

Any help would be appreciated.

Mairhtin O''Feannag



does u''r remote server started ??


这篇关于连接到V9远程数据库时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆