LoveUnix » DB2 & Informix » db2实例32位升级64位 求教
让LU留住您的每

一天 让LU博客留住您的每一天
2007-6-15 10:47 夏亦寒
db2实例32位升级64位 求教

使用./db2iupdt -w 64 db2inst1后
$ db2level
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code release "SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and FixPak
"14".
Product is installed at "/usr/opt/db2_08_01".

#su - db2inst1

$db2start

数据库不能start


求教是什么原因

[[i] 本帖最后由 夏亦寒 于 2007-6-15 11:04 编辑 [/i]]

2007-6-15 10:55 夏亦寒
800建议

1.将数据export出来
2.重新创建64位的instance
3.把export数据load进去

不知道各位大大有谁做过,大概需要多长时间
现在的数据量在15g左右

2007-6-15 11:03 夏亦寒
下面是操作过程
请大大们帮忙看下
# pwd
/usr/opt/db2_08_01/instance
# ./db2iupdt -w 64 db2inst1
DBI1070I Program db2iupdt completed successfully.  

# su - db2inst1
$ db2start
^C06/15/2007 10:40:54     0   0   SQL1042C  An unexpected system error occurred.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
$ exit
# pwfd
ksh: pwfd:  not found.
# pwd
/usr/opt/db2_08_01/instance
# ./dasupdt dasuser1
[YOU HAVE NEW MAIL]
SQL4407W  The DB2 Administration Server was stopped successfully.
[YOU HAVE NEW MAIL]
SQL4406W  The DB2 Administration Server was started successfully.
DBI1070I Program dasupdt completed successfully.  

# su - db2inst1
$ db2start
06/15/2007 10:51:13     0   0   SQL1042C  An unexpected system error occurred.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

2007-6-15 12:31 beginner-bj
看db2diag.log

2007-6-18 09:58 darkbug
生产环境直接update呀,没干过,不过觉得800的办法应该可以,呵呵

2007-6-18 11:02 Smallsnail
1.将数据export出来
2.重新创建64位的instance
3.把export数据load进去

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.