- 论坛徽章:
- 1
|
系统平台:AIX5.1+DB2V7.2,想升级到8.1
升级过程参照官方的PDF文档来做的,之前在相同平台的测试系统上已成功升级,在生产系统上升级遇到了问题。
已完成了db2imigr -u db2<dbsid> db2<dbsid>这一步。下面是后面接着的操作和出错提示:
p55a:db2gda 6> db2 migrate database GDA
SQL1478W The defined buffer pools could not be started. Instead, one small bufferpool for each page size supported by DB2 has been started.SQLSTATE=01626
p55a:db2gda 13> p55a:db2gda 13>db2set DB2_OVERRIDE_BPF=30000
p55a:db2gda 14> db2 migrate database GDA
SQL0752N Connecting to a database is not permitted within a logical unit ofworkwhen the CONNECT type 1 setting is in use. SQLSTATE=0A001
p55a:db2gda 17> db2 set client connect 1
SQL1246N Connection settings cannot be changed while connections exist.
p55a:db2gda 18> db2stop
06-13-2015 11:05:24 0 0 SQL1025N The database manager was not stopped becausedatabases are still active.
SQL1025N The database manager was not stopped because databases are still active.
p55a:db2gda 19> db2 list applications
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------------------------------------- -------- -----
DB2GDA db2bp 4 *LOCAL.db2gda.1A0B93025952 GDA 1
p55a:db2gda 20> db2stop force
06-13-2015 11:12:25 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
p55a:db2gda 21> db2start
06-13-2015 11:12:31 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
p55a:db2gda 22> db2 migrate database GDA
SQL0752N Connecting to a database is not permitted within a logical unit of
work when the CONNECT type 1 setting is inuse. SQLSTATE=0A001
p55a:db2gda 23> db2 list applications
SQL1611W No data was returned by Database System Monitor. SQLSTATE=00000
p55a:db2gda 24> db2 set client connect 1
SQL1246N Connection settings cannot be changed while connections exist.
p55a:db2gda 27> db2 set client connect 2
DB20000I The SET CLIENT command completed successfully.
p55a:db2gda 28> db2 migrate database GDA
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can beprocessed. (Reason "".) SQLSTATE=58004
请专家指点一下,万分感谢
如果我想要回滚到原版本,该如何操作,我在网上搜没有搜到什么文档。 |
|