Monday, March 21, 2011

db2imigr vs db2iupgrade

Hello All, 

If you are migrating the instance from DB2 V9.1 to V9.5:

1) Since we are migrating the instance from V9.1 to V9.5, make sure we meet the Prerequisites before starting the migration process.

Migration for DB2 servers:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.qb.migration.doc/doc/c0011933.html

2) Once we meet the  Prerequisites, we migrate the instance to 9.5 using "db2imigr" command.

3) Once done migrating the instance to 9.5, we migrate the database's under that instance using "migrate database" command.

====

If you are migrating the instance from DB2 V9.1 to V9.7:

1) Since we are migrating the instance from V9.1 to V9.7, make sure we meet the Prerequisites before starting the migration process:

Upgrade essentials for DB2 servers:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.qb.upgrade.doc/doc/c0023734.html

2) Once we meet the  Prerequisites, we migrate the instance to 9.7 using the "db2iupgrade" command since db2imigr is deprecated.

3) Once done upgrading the instance to 9.7, we upgrade the database's under that instance using "upgrade database" command.

We use db2imigr and db2iupgrade commands only when upgrading the instance from a lower version. db2imigr is deprecated starting DB2 9.7 and we use db2iupgrade instead.

Thanks
Samyn

No comments:

Post a Comment