无法通过控制中心连接到db2服务器... - 帮助! [英] unable to connect to a db2 server through the control center ... - Help !

查看:137
本文介绍了无法通过控制中心连接到db2服务器... - 帮助!的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

嗨再次,


我一直在尝试使用

连接到远程数据库我的控制中心在WinXp上。


我正在使用个人版DB2 v8.1.9.700作为控制中心

WinXp。


我'我设置了一个节点(一个远程连接),以便到达这个

远程数据库,但它似乎没有工作......远程数据库

是旧版本DB2 v7.1.0.40并且在Linux RedHat ES3.0上。


每次,我都有SQL0805N模块NULLID.SYSSH200

还没有找到。 SQLSTATE = 51002

我在这个新闻组上看到,个人UDB受到限制,并且我不能连接到远程数据库。


我只是想知道它是否属实。


TIA,

Andy是DB2的初学者。

Hi again ,

I''ve been trying to connect to a distant database with
my control center on WinXp .

I''m using a personnal edition DB2 v8.1.9.700 for the control center on
WinXp.

I''ve setup a node (a distant connection ) in order to reach this
distant database but it doesn''t seem to work ... The distant database
is in a older version DB2 v7.1.0.40 and is on a linux RedHat ES3.0 .

Each time , I have SQL0805N the module "NULLID.SYSSH200"
hasn''t been found . SQLSTATE=51002
I read on this newsgroup that Personal UDB is restricted and that i
won''t be able to connect to a distant database .

I just want to know if it is true .

TIA,
Andy the beginner in DB2 .

推荐答案

嗨Andy,

使用db2配置辅助并测试是否可以ping通

来自客户端的数据库。在db2环境(db2cmd)中,执行

list db2目录

命令,查看是否列出了远程数据库。


如果不可能,则必须重新配置。


阅读文章了解更多信息。
http://www-106.ibm.com/developerwork...301chong2.html


纠正我,如果有任何问题..

干杯,

Thiru

WantedToBeDBA

WantedToBeDBA {at} gmail {dot} com

Hi Andy,
Use db2 Configuration Assist and test whether its possible to ping
the database from the client. in db2 environment(db2cmd), execute
list db2 directory
command and see whether you have be listed with remote database.

If its not possible, you have to re-configure.

Read the article for more information.
http://www-106.ibm.com/developerwork...301chong2.html

Correct me if any problem..
Cheers,
Thiru
WantedToBeDBA
WantedToBeDBA {at} gmail {dot} com


Hi Thiru,


Big谢谢你的回答。


我做了DB2 Version 8 Connectivity Cheat Sheet中的说法。并且

它工作正常。


但它带来了另一个问题:为什么控制中心显示

同样的错误?


在服务器端有什么可做的(添加一些java

库或db2选项)?


感谢您的帮助,如果您能回答这个问题,它将会成为我这一天的答案。

Hi Thiru ,

Big thanks for your answer .

I did what was said in the "DB2 Version 8 Connectivity Cheat Sheet" and
it works fine .

But it brings another question : why does the control center display
the same error ?

Is there something to do about it on the server side (adding some java
library or a db2 option) ?

Thanks for the help and if u can answer this question , it''s going to
be the answer that makes my day .

< br>

" Andy K" < AK **** @ yahoo.com>在消息中写道

news:11 ********************** @ g44g2000cwa.googlegr oups.com ...
"Andy K" <ak****@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
嗨Thiru,

非常感谢您的回答。

我做了DB2 Version 8 Connectivity Cheat Sheet中所说的内容。并且
它工作正常。

但它带来了另一个问题:为什么控制中心显示相同的错误?

有什么可做的关于它在服务器端(添加一些java
库或db2选项)?

感谢您的帮助,如果您能回答这个问题,它将会
成为我的一天的答案。
Hi Thiru ,

Big thanks for your answer .

I did what was said in the "DB2 Version 8 Connectivity Cheat Sheet" and
it works fine .

But it brings another question : why does the control center display
the same error ?

Is there something to do about it on the server side (adding some java
library or a db2 option) ?

Thanks for the help and if u can answer this question , it''s going to
be the answer that makes my day .



确保关闭控制中心并重新启动它。它有一个非常好的习惯,就是把东西存放在缓存中。


Make sure you close down the Control Center and restart it. It has a very
nasty habit of storing things in cache.


这篇关于无法通过控制中心连接到db2服务器... - 帮助!的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

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