(DB2)Database migration problems.....from 7.2 to 8.2

[scar1978]

Hi
I am trying to migrate a database from DB2 7.2 to 8.2 on Windows XP. both are on different machines.
i am getting the following error

first i took a back up of the database
C:\>db2 restore database MQSICMDB
Restored the database sucessfully but couldnt migrate as unable to rebind

then i trierd to rebind
C:\Program Files\IBM\SQLLIB\bnd>db2 bind @db2cli.lst blocking all grant public

LINE MESSAGES FOR db2cli.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL1024N A database connection does not exist.
SQLSTATE=08003
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.


Then i tried to connect to Database

C:\Program Files\IBM\SQLLIB\bnd>db2 connect to MQSICMDB
SQL5035N The database requires migration to the current release.


and when i tried to migrate i got the following error


C:\Program Files\IBM\SQLLIB\bnd>db2 migrate database MQSICMDB
SQL1088W The database was created, but an error occurred while binding the
utilities. The utilities are not bound to the database


what am i supposed to do

 

[aixnag]

Seems you didn't follow all the post migration activities. Before i suggest to do something. I would like to know what steps you followed so far (Describe in very high level.

aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2