• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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