Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2007
    Posts
    38

    Unanswered: Instance cannot be updated or upgraded

    Hi,

    I have stopped all the db2 processes and when I try to upgrade the instance I get the error

    DBI1122E Instance cannot be updated or upgraded.

    I am upgrading from V9.1.4 to V9.7.3

    Thanks in advance.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Check to see if there is a log file on /tmp directory (not sure where it is on Windows). There is also an upgrade check program you can run that will tell if there any potential problems with upgrading an instance.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2007
    Posts
    38
    The tmp filesays:


    DBI1122E Instance dbacq01 cannot be updated or upgraded.

    Explanation:

    An attempt was made to either update or upgrade an instance. This
    instance cannot be updated or upgraded because:

    * One of the following commands cannot be used to either update or
    upgrade this instance: db2iupdt, db2iupgrade, or db2nrupdt.
    * The instance is still active.

    User response:

    Ensure that you are using the correct version of one of the following
    commands: db2iupdt, db2iupgrade, or db2nrupdt. Also, ensure that there
    are no DB2 processes running at the instance. Retry the command.


    DBI1079I Output is saved in the log file /tmp/db2iupdt.log.31773.

    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.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You didn't say what command you issued.

    You need to read the documentation on Upgrading to DB2 Version 9.7 on the InfoCenter website (make sure you are using the 9.7 infocenter. Also, I would use 9.7.4 since it is the latest.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2007
    Posts
    38
    I gave the command ./db2iupdt dbacq01

    dbacq01 - instance name

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Read the instructions I mentioned above.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated before : The instance is still active.
    some processes are active - try to find them and stop/kill them
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •