Operations ‐ Upgrade Db2 Server From 9.7 to 11.1 - andyoolala/DB2 GitHub Wiki

Verify database is ready for upgrade

$ su - $db2inst
$ db2start
$ /opt/ibm/db2/V11.1/instance/bin/db2ckupgrade $DB_NAME -l $LOG_FILE

upgrade instance

$ su - $db2inst
$ db2stop
$ su - root
$ cd /opt/ibm/db2/V11.1/instance/
$ ./db2iupgrade -a SERVER -u $db2inst $db2inst

The execution completed successfully.

For more information see the DB2 installation log at
"/tmp/db2iupgrade.log.11528".
DBI1070I  Program db2iupgrade completed successfully.

Elapsed : 3 Minutes

upgrade database

$ su - $db2inst
$ db2start
$ db2 connect to $DB_NAME
SQL5035N  The connection failed because the database product has been updated
and the database needs to be upgraded  SQLSTATE=55001

$ db2 upgrade database $DB_NAME
$ db2 connect to $DB_NAME

   Database Connection Information

+ Database server        = DB2/LINUXX8664 11.1.4.7
 SQL authorization ID   = $db2inst


 Local database alias   = $DB_NAME

Elapsed : 3 Minutes

rebind packages

$ su - $db2inst
$ db2 connect to $DB_NAME
$ db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(NULL, 'SYSIBMADM', NULL)"
$ db2rbind $DB_NAME -l $LOG_FILE

migrate execute plan objects

$ db2exmig -d $DB_NAME -e $SCHEMA_NAME_EXECUTEPLAN_TABS_LOCATED