db2 upgrade - liamlamth/blog GitHub Wiki

10.5 to 11.1

  1. instance owner: /opt/IBM/db2/V11.1/instance/db2ckupgrade dbname1 -l /tmp/result.log ...
  2. instance owner: db2stop
  3. root user: /opt/IBM/db2/V11.1/instance/db2iupgrade db2inst1

    • before/after: db2level

    • DBI1124E Instance db2inst1 cannot be upgraded.
      * The instance is still active and the -prepare parameter was not specified. * Upgrading this instance is not supported.
      * This version of the db2iupgrade command cannot be used to upgrade this instance. * The version of the currently installed product is the same as the version of which the upgrade was being attempted.
      possible reason: upgrade was done before (may be testing purpose) and incompletely restore back to old version

      check what version the instance is under

      • /opt/IBM/db2/V10.5/instance/db2ilist
      • /opt/IBM/db2/V11.1/instance/db2ilist add and delete the registered
      • /opt/IBM/db2/V10.5/instance/db2iset -a db2inst1
      • /opt/IBM/db2/V11.1/instance/db2iset -d db2inst1
  4. instance owner: db2start
  5. instance owner: db2 upgrade database dbname1
    ...
  6. db2 connect to dbname1
    db2 "select * from syscat.dbauth"
⚠️ **GitHub.com Fallback** ⚠️