DB2 安装 Fixpack 10 时,db2iupdt 报错!

[复制链接]
查看11 | 回复7 | 2014-3-10 14:09:19 | 显示全部楼层 |阅读模式
在 安装 完 FixPack 10 之后,
重新绑定 实例 之前,
执行 更新实例命令出错,
命令如下:
/opt/IBM/db2/V8.1/instance/db2iupdt db2inst1
错误信息如下:
[root@localhost instance]# ./db2iupdt db2inst1
DBI1250E Applications are still using instance

db2inst1.
Explanation:
There are applications that are still running that are using the
specified instance. All applications using this instance must be
terminated before the command can be completed successfully.You
can get a list of the applications that are currently using the
instance by issuing the command:

db2 list applications
User Response:
You can either wait for the applications to end by themselves, or
you can explicitly force the applications to end.You can logon
as the instance owner and run the command

db2 force application all
Note that some applications may have unexpected behaviour when
terminated using the above command. After all the applications
have stopped, stop the database manager using "db2istop"
command.

DBI1122E Instance db2inst1 cannot be updated.
Explanation:
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
本人 已经
执行过
db2stop force
没有任何输出
以 root 用户执行
ps -ef|grep db2inst1
也没有任何输出,
[root@localhost instance]# ps -aux |grep db2
Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
root 7401 0.0 0.6 6848 3268 ? Ss 14:03 0:00 /opt/IBM/db2/V8.1/bin/db2fmcd
dasuser 7414 0.0 0.9 9756 4964 ? S 14:03 0:00 /home/dasuser/das/bin/db2fmd -i dasuser -m /home/dasuser/das/lib/libdb2dasgcf.so
dasuser 7500 0.0 1.0 11188 5256 pts/0 S 14:04 0:00 /home/dasuser/das/adm/db2dasrrm
root 10050 0.0 0.0 1364 432 pts/1 R+ 15:29 0:00 grep db2
杀掉进程后,
执行 db2iupdt db2inst1
仍然报 实例还活着
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
is there any error about db2gcf in db2diag.log?
if so please temporary change
the following lines in db2iutil script(/usr/opt/db2_08_01/instance)


${DB2DIR?}/bin/db2gcf -i ${INSTNAME?} -s -t 10 1> /dev/null 2>

/dev/null



TO



${DB2DIR?}/bin/db2gcf -i ${INSTNAME?} -s -t 50 1> /dev/null 2>

/dev/null



then run the db2iupdt again.



NOTES:



the default permission for this script is



-r--r--r-- 1 root bin
137284 Aug 15 2004db2iutil
, so after changing the script, pls remember to change back permisson to
the -r--r--r--.

=========================
OR:
1. db2gcf -i db2inst1 -s -t 10

==>db2gcferror: GCFCaller Load failed

2. ln -s /opt/IBM/db2/V8.1/lib/libdb2gcf.so /usr/lib/libdb2gcf.so
3. db2gcfg -i db2inst1 -s -t 10

Instance: db2root1

DB2 State : Operable

4. db2iupdt db2inst1

==>successfull

5. db2start

==>successfull
=========================
actually the easiest way to fix it is droping and recreating the instance
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
ipcs -a|grep db2inst1的输出呢?
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
试试db2_kill
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
db2iauto在执行前没有运行?
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
这种报错,应该是还有应用连接。
回复

使用道具 举报

千问 | 2014-3-10 14:09:19 | 显示全部楼层
建议把 数据库的端口号或者db name 更改一下,等升级完毕后,再更改回去。
这样就避免主机上直接连了。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行