The migration of DB2 Server from Version 8.2 to Version 9.5 can be a seamless experience provided all the prerequisites have been fully met.
In a nut shell the DB2 Server migration task can be summarized as
1- Install the DB2 Software
2- Migrate the existing instances
3- Migrate the existing DB2 Administration Server
4- Migrate the existing databases
5- Additional post migration tasks if applicable
DB2 instances are migrated using the command db2imigr. The fencedID has to be provided along with the Instance name. Below is an example
root@db2dev /opt/IBM/db2/V9.5 ->$DB2DIR/instance/db2imigr -u db2fenc1 ivlm
db2ckmig was successful. Database(s) can be migrated.
DBI1070I Program db2imigr completed successfully.
A way the fencedID can be checked is while logging in using the instance owner and checking as follows;
ivlm@db2dev /home/ivlm ->ls -l ~/sqllib/adm/.fenced
-r–r–r– 1 db2fenc1 db2fgrp1 0 Mar 13 08:52 /home/ivlm/sqllib/adm/.fenced
Now the DB2 Administration Server can be easily migrated as shown below
root@db2dev /opt/IBM/db2/V9.5 ->$DB2DIR/instance/dasmigr
SQL4410W The DB2 Administration Server is not active.
SQL4406W The DB2 Administration Server was started successfully.
DBI1070I Program dasmigr completed successfully.
Finally the DB2 databases have to be migrated and only then the DB2 databases will have an open status.
ivlm@db2dev /home/ivlm -> db2 MIGRATE DATABASE ILMLOGS USER ivlm USING ivlm123
It is important to note that the user being used should have the SYSADM authority.
Once the database migration is successful the connection can be made to the database for verification
db2 => connect to ILMLOGS
Database Connection Information
Database server = DB2/AIX64 9.5.1
SQL authorization ID = IVLM
Local database alias = ILMLOGS
And then the below query can be executed
db2 "select * from syscat.dbauth"
Alternatively level of db2 can also be checked
ivlm@db2dev /home/ivlm ->db2level
DB21085I Instance “ivlm” uses “64″ bits and DB2 code release “SQL09051″ with
level identifier “03020107″.
Informational tokens are “DB2 v9.5.0.1″, “s080328″, “U814639″, and Fix Pack
“1″.
Product is installed at “/opt/IBM/db2/V9.5″.
The above contents are only to provide an overview; the IBM documentation has to be followed in order to understand the complete and full steps for migration.
