| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Migration Issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| MSAT |
 Posted: Fri Nov 04, 2005 9:59 pm Post subject: Database Migration Issue |
 |
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi,
As part of the MQ WorkFlow migration ( From 3.3.2 to 3.5 ) I migrated DB2 UDB from 7.1+FP5 to DB2 V8.1 + FP2
After migration we took the backup and restore it, It is giving below error.
"D:\temp\dbbackup>db2 restore database tmpdb from .
SQL2570N A database cannot be restored on a platform that does not match the
platform on which the backup image was created."
Is it the migration problem ?
What procedure I need to follow to solve this issue ?
It is very urgent !!!!!!!!!
Note : I tried to install DB2 V8.1 + FP2 freshely in other system and tried to restore the database it works fine.
Thanks
MSAT |
|
| Back to top |
|
 |
| paulgroo |
| Posted: Wed Nov 09, 2005 3:43 am Post subject: |
|
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
This is a DB2 question not an workflow question, but...
Did you try taking an extract from the database instead creating an image. I'm pretty sure the image will hold a lot more information about the system than what you need. An extract should just give the sql that you need to import into the new, upgraded database. |
|
| Back to top |
|
|
| ramires |
| Posted: Wed Nov 09, 2005 7:31 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Are you restoring a image taken in the same platform?
I guess you cannot restore a db2 aix db in a db2 windows
Regards |
|
| Back to top |
|
|
| MSAT |
| Posted: Thu Nov 17, 2005 2:13 am Post subject: |
|
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi,
Yes I tried on the same machine(Windows 2000 Advanced Server).
But, finally I uninstalled older version after taking DB2 backup. And then reinstalled new version. And migrated the databases.
(Actually when u restore the database using RESTORE db2 command at that time the command automatically migrates the database.)
Thanks For reply
SAT |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
