IBM DB2 LUW DBA Tutorial -- Database Upgrade from 10.x to 11.1

/**

声明：此随笔为在youtube上学习‘ IBM DB2 LUW/UDB DBA Tutorial for Beginners' 课程笔记.

YouTube视频连接：https://www.youtube.com/watch?v=Pjvwm4rC5Ok&list=PLCNIKwM6iuv7g1hDWDcNkc66vZuVJmvZg

**/

Upgrade:

Reading the documentation + Preparing the plan

Check pre-requisites

Take backup!

1. Copy 11.1 to /mnt/db2/product folder

2. Extract & install in /opt/ibm/db2/V11.1

*Don't create instance

3. Make sure you stop 10.1 instance (db2inst1, db2fenc1)

4. As a root:

　　cd /opt/ibm/db2/V11.1/instance

　　./db2iupgrade -u db2fenc1 db2inst1

5. Upgrade databases

　　db2 "upgrade database <database name>"