DB2 Database upgrade from db2 9.7 to db2 11.1

Note: First try below steps on test or non-prod server.

• Keep software ready and accessible.
• root access required to install binaries.
• create new mount point for v11.1 binary installation and allocate sufficient space to new mount point.

Binary installation and upgrade steps

• Take offline database backup keep it safe
• Login as root user or sudo root
• Unzip binary file

DB2LUW_11.1_FP1_RDBMS_LNXx64.zip

unzip DB2LUW_11.1_FP1_RDBMS_LNXx64.zip

• create new mount point for db2 v11.1 binary installation.

• run db2 prerequisites command, prerequisites command will be in unzipped binary file.

If no error or warning message then good to go ahead with binary installation,

• Install db binaries, once installation complete check DB2 installation log file completely.

• Stop db2 instance running on db2 v9.7, Make sure no application connected to database, use below db2stop command and ip clean

• Upgrade instance, Go to db2 v11.1 binary installation path

db2dbtut :- Instance name and fence id

• Instance upgrade command completed successfully, now switch to instance owned id start the instance and check db2 version.
• switch to instance db2dbtut, upgrade all database in instance db2dbtut using below db upgrade command

dbtut :- Database name

• Run runstats on all database tables.