Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Upgrading DB2 on AIX

 2 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Phil Romov
Veteran Member
Posts: 44
Veteran Member
7/9/2012 1:41 PM
    Would like to hear any tips anyone has regarding DB2 upgrade on AIX


    In particular, I want to do the upgrade in-place.  For example, I already have 9.1, and I just want to upgrade it to 9.5 (or 9.7) without installing a second copy of db2 anywhere.  What's the best way to do this?  Is it possible?


    I found this on google http://publib.boulder.ibm...ng_db2_95_to_97.html but the DB2 9.1 delivered by lawson doesn't have any db2ckupgrade or db2iupgrade

    Thanks as always
    Phil
    Phil Romov
    Veteran Member
    Posts: 44
    Veteran Member
    7/10/2012 12:22 PM
      Figured it out - mostly referencing this: http://techsatwork.com/bl...on-steps-for-aix.pdf

      For me, it boiled down to installing 9.7 binaries somewhere on the machine (along with ese_c license) and then as root doing db2imigr instance, db2level to confirm, db2start and db2 migrate db
      Phil Romov
      Veteran Member
      Posts: 44
      Veteran Member
      7/10/2012 1:20 PM
        Also, tip - if remote queries stop working all of a sudden with SQL30081N 10061, make sure your SVCENAME is set up:
        db2 update dbm cfg using svcename [entry in /etc/services -or- port number]
        confirm db2comm=tcpip in db2set -all
        restart