dbTalk Databases Forums  

Restore from 7.2 to 8.1

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Restore from 7.2 to 8.1 in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony Do
 
Posts: n/a

Default Restore from 7.2 to 8.1 - 08-27-2003 , 09:31 PM






I have 2 database both was full backup from V7.2 fax pack 8

Database "one" can be restored to V8.1 without the need to migrate to
Database "two" can be restored to V8.1 but it is now asking to be migrated
to V8.1

How do I migrate it to the new version?
And below is the error message



[IBM][CLI Driver] SQL5035N The database requires migration to
the current release. SQLSTATE=55001




Explanation:

The database was created on a lower level system release. The
Migrate Database command must be used to convert the database to
the current release level.

The command cannot be processed.

User Response:

Perform the Migrate Database command before attempting to use the
database with the current system release.

If this message is received during a restore, drop the existing
database before proceeding.

sqlcode : -5035

sqlstate : 55001




Reply With Quote
  #2  
Old   
ashok
 
Posts: n/a

Default Re: Restore from 7.2 to 8.1 - 08-29-2003 , 08:20 PM






Try:
MIGRATE DATABASE database-alias [USER username [USING password]]

-- ashok

"Tony Do" <tony (AT) somewhere (DOT) onearth> wrote

Quote:
I have 2 database both was full backup from V7.2 fax pack 8

Database "one" can be restored to V8.1 without the need to migrate to
Database "two" can be restored to V8.1 but it is now asking to be migrated
to V8.1

How do I migrate it to the new version?
And below is the error message



[IBM][CLI Driver] SQL5035N The database requires migration to
the current release. SQLSTATE=55001




Explanation:

The database was created on a lower level system release. The
Migrate Database command must be used to convert the database to
the current release level.

The command cannot be processed.

User Response:

Perform the Migrate Database command before attempting to use the
database with the current system release.

If this message is received during a restore, drop the existing
database before proceeding.

sqlcode : -5035

sqlstate : 55001

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.