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.