软件开发 db2 10.1

db2实例升级失败,找不到原因

各位大神们在一个测试环境里的一个instance做升级的时候一直出错,苦思无果特来寻求帮助,能给予指导:这个是在升级中的错误:# ./db2iupgrade db2inst2DBI1446I  The db2iupgrade command is running.DB2 installation is being initialized.DBI1124E  ... 显示全部
各位大神们在一个测试环境里的一个instance做升级的时候一直出错,苦思无果特来寻求帮助,能给予指导:
这个是在升级中的错误:
# ./db2iupgrade db2inst2
DBI1446I  The db2iupgrade command is running.


DB2 installation is being initialized.


DBI1124E  Instance db2inst2 cannot be upgraded.

Explanation:

An attempt was made to upgrade an instance. This instance cannot be
upgraded because:

*  The instance is still active.
*  Upgrading this instance is not supported.
*  This version of the db2iupgrade command cannot be used to upgrade
   this instance.

User response:

Ensure that the instance is ready for upgrading and you are using the
correct version of the db2iupgrade command. For more information on
upgrading an instance, refer to the DB2 Information Center.


A major error occurred during the execution that caused this program to
terminate prematurely. If the problem persists, contact your technical service
representative.

For more information see the DB2 installation log at
"/tmp/db2iupgrade.log.8519924".
DBI1264E  Errors were encountered in running db2iupgrade. Please
      refer to the installation log file /tmp/db2iupgrade.log.8519924 for more
      information.

Explanation:

All processed and failed operations have been saved into this log file.

User response:

Do not modify this file in any way. This file is for IBM Technical
Support reference.

这个是log里面的内容:
# cat /tmp/db2iupgrade.log.8519924

DB2 Setup log file started at:  Tue Mar 11 11:11:50 2014 IST
============================================================

Operating system information: AIX 6.1
ERROR: DBI1124E  Instance db2inst2 cannot be upgraded.

Explanation:

An attempt was made to upgrade an instance. This instance cannot be
upgraded because:

*  The instance is still active.
*  Upgrading this instance is not supported.
*  This version of the db2iupgrade command cannot be used to upgrade
   this instance.

User response:

Ensure that the instance is ready for upgrading and you are using the
correct version of the db2iupgrade command. For more information on
upgrading an instance, refer to the DB2 Information Center.


ERROR: The "db2iupgrade" command failed. Ensure the command parameters are
valid, that errors reported in the log file are fixed, then rerun the command.


Post Install Recommendations
-----------------------------

Required steps:
There were some errors detected during DB2 installation. To collect the information files from the system, run the "db2support -install" command with the proper         options before reporting the problem to IBM service. For information regarding the usage of the db2support tool, check the DB2 Information Center.


DB2 Setup log file finished at:  Tue Mar 11 11:11:52 IST 2014
============================================================



我查了db2diag的信息, 但是没看明白, 也不知道改如何去查:
2014-03-11-11.11.52.543885+330 I96622764A395        LEVEL: Error
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, config/install, sqlfcsys, probe:35
RETCODE : ZRC=0xFFFFEC41=-5055
          SQL5055C  The content of the database configuration file is not
          valid.


2014-03-11-11.11.52.545970+330 I96623160A425        LEVEL: Error
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : bytesr
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFE6E98 : 0000 0000 0000 1000                        ........

2014-03-11-11.11.52.546217+330 I96623586A425        LEVEL: Error
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : ptr->release
DATA #1 : Hexdump, 2 bytes
0x09001000A1D87AF8 : 0C00                                       ..

2014-03-11-11.11.52.546396+330 I96624012A426        LEVEL: Error
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : ptr->chksum
DATA #1 : Hexdump, 4 bytes
0x09001000A1D87AE8 : 0000 419B                                  ..A.

2014-03-11-11.11.52.546574+330 I96624439A433        LEVEL: Error
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : ptr->dbm_cfg_version
DATA #1 : Hexdump, 2 bytes
0x09001000A1D87AFC : 2520                                       %

2014-03-11-11.11.52.546767+330 I96624873A369        LEVEL: Severe
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, config/install, sqlf_alert, probe:1
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFE6F40 : FFFF EC41                                  ...A

2014-03-11-11.11.52.546944+330 I96625243A395        LEVEL: Severe
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, config/install, sqlfcsys, probe:1
RETCODE : ZRC=0xFFFFEC41=-5055
          SQL5055C  The content of the database configuration file is not
          valid.


2014-03-11-11.11.52.547285+330 I96625639A394        LEVEL: Severe
PID     : 10813458             TID : 1              PROC : db2iure
INSTANCE: db2inst2             NODE : 000
HOSTNAME: infbz1080.in.ibm.com
EDUID   : 1
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:30
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFE71D4 : FFFF EC41                                  ...A 收起
参与10

查看其它 8 个回答lushn 的回答

lushn lushn 数据库管理员 IBM
# cat  /tmp/db2idrop.log.14614688

DB2 Setup log file started at:  Tue Mar 11 12:33:34 2014 IST
============================================================

Operating system information: AIX 6.1


Existing instances to configure:
    Instance name:                              db2inst2
        Instance user information:
            User name:                          db2inst2





Initializing instance list :.......Success
ERROR: An error occurred while dropping the instance "db2inst2". The return
value is "1". If the problem persists contact your technical service
representative.

ERROR: An error occurred while configuring the instance "db2inst2".

Configuring DB2 instances :.......Failure

DB2 Setup log file finished at:  Tue Mar 11 12:33:49 IST 2014
============================================================

删除也是个问题了~~@!
软件开发 · 2014-03-11
浏览1324

回答者

lushn
数据库管理员 IBM
评论30

lushn 最近回答过的问题

回答状态

  • 发布时间:2014-03-11
  • 关注会员:1 人
  • 回答浏览:1324
  • X社区推广