Chinaunix

标题: Setup Federated database Problem(急！！！) [打印本页]

作者: coolwinds 时间: 2007-04-14 07:41
标题: Setup Federated database Problem(急！！！)
是否有高手帮忙看看如何解决，困扰很久了 ^_^
客户端版本
$oslevel
5.3.0.0
$ db2level
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code release "SQL08023"
with level identifier "03040106".
Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", and FixPak
"10".
Product is installed at "/usr/opt/db2_08_01".

创建一个联邦数据库系统在第二步的时候出现如下错，查阅了很多相关资料都没有给出很好的解决方案，另外客户反应当我执行这条命令后数据库crash 掉了.(后来恢复)另外数据库系统是刚刚安装完 FixPack 10 后我开始创建联邦数据库的.

[db2inst1@server]/home/db2inst1
$ db2 "CREATE SERVER "TKV3I1U0" TYPE DB2/UDB VERSION '8.2' WRAPPER DRDA AUTHID "remoteuserl" PASSWORD "******" OPTIONS( ADD DBNAME 'TKV3I1U0')"
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL1224N  A database agent could not be started to service a request, or was
terminated as a result of a database system shutdown or a force command.
SQLSTATE=55032

正常的检查步骤都做过了比如

db2 get dbm cgf |grep FEDERATED=YES //ok

db2 "create wrapper DRDA library 'libdb2drda.a'"

当然还有兄弟告诉我说后台进程没有启动（这都是常识性的问题^_^）db2diag.log 根本看不出什么有意义的信息

[ 本帖最后由 coolwinds 于 2007-4-14 10:18 编辑 ]

作者: toms1981 时间: 2007-04-15 10:36
Do you able to create your DRDA???
May I know which package of DB2 you installed? Did it support Federated Database?
I remember there is one package of DB2 where it didn't support federated database so if you failed to create the DRDA then most likely your current DB2 package doesn't support Federated Database...

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)