By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,012 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,012 IT Pros & Developers. It's quick & easy.

Restore database from v7.2 to v8.2

P: n/a
Dear all,

I'm a new beginner of DB2. I face 2 question during restore the data.

I have 2 DB2 servers on my company. Server A is running on V7.2 and
Server B is running on v8.2 (Enterprise Server). I backup a database
from Server A and restore it on Server B.

Question 1)
"SQL2542N database name is not match on the source file" error
prompted. The date and time are entered correctly during restore
command.

Question 2)
Somebody told me that V7.2 database can't restore on V8.2 directly. Is
it true? If yes, how can I get the data on Server B.

Thank you for your help.

Best Regards,

Justy

Jun 9 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
m
ch********@gmail.com wrote:
Dear all,

I'm a new beginner of DB2. I face 2 question during restore the data.

I have 2 DB2 servers on my company. Server A is running on V7.2 and
Server B is running on v8.2 (Enterprise Server). I backup a database
from Server A and restore it on Server B.

Question 1)
"SQL2542N database name is not match on the source file" error
prompted. The date and time are entered correctly during restore
command.

Question 2)
Somebody told me that V7.2 database can't restore on V8.2 directly. Is
it true? If yes, how can I get the data on Server B.

Thank you for your help.

Best Regards,

Justy

V7 will DEFINITELY restore to V8 - providing they are the same platform.
Windows -> Windows, Unix -> Unix. What platform are you using? Are you
trying to rename the DB?

Jun 9 '06 #2

P: n/a
I have restored V7.2 offline backups to V8.2 and it works like a charm.

You will have to convert your indexes to type-2 afterwards.

Just wondering ? Is there anything else that should be performed in
order to have a full complain V8.2 system, or do we only need to
convert the indexes ?

Thanks,

Dear all,

I'm a new beginner of DB2. I face 2 question during restore the data.

I have 2 DB2 servers on my company. Server A is running on V7.2 and
Server B is running on v8.2 (Enterprise Server). I backup a database
from Server A and restore it on Server B.

Question 1)
"SQL2542N database name is not match on the source file" error
prompted. The date and time are entered correctly during restore
command.

Question 2)
Somebody told me that V7.2 database can't restore on V8.2 directly. Is
it true? If yes, how can I get the data on Server B.

Thank you for your help.

Best Regards,

Justy


Jun 9 '06 #3

P: n/a
You don't even need to convert your indexes immediately after migrating
(which the restore v7.2 to V8.2 does).
V7.2 Type1 indexes can be converted with the V8.2 REORG command or when you
do the first reorg of the table under V8.2.

Here's the full text of your error msg.
SQL2542N No match for a database image file was found based on
the source database alias "<database-alias>" and
timestamp "<timestamp>" provided.

Explanation:

The backup image file filename consists of a database alias and a
timestamp component. A filename is constructed from the source
database alias and timestamp parameters provided in the Database
Restore call. No filename existed in the source directory that
matched based on the source database alias and timestamp
provided. If this error was received from an automatic
incremental restore then a required image was not found based on
the timestamp and location in the database history.

Either the timestamp you provided is wrong or the path you specified to
restore from is wrong
Please provide the command and the path where your image to restore is.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Michel Esber" <mi****@us.automatos.com> a écrit dans le message de news:
11**********************@i40g2000cwc.googlegroups. com...
I have restored V7.2 offline backups to V8.2 and it works like a charm.

You will have to convert your indexes to type-2 afterwards.

Just wondering ? Is there anything else that should be performed in
order to have a full complain V8.2 system, or do we only need to
convert the indexes ?

Thanks,

Dear all,

I'm a new beginner of DB2. I face 2 question during restore the data.

I have 2 DB2 servers on my company. Server A is running on V7.2 and
Server B is running on v8.2 (Enterprise Server). I backup a database
from Server A and restore it on Server B.

Question 1)
"SQL2542N database name is not match on the source file" error
prompted. The date and time are entered correctly during restore
command.

Question 2)
Somebody told me that V7.2 database can't restore on V8.2 directly. Is
it true? If yes, how can I get the data on Server B.

Thank you for your help.

Best Regards,

Justy


Jun 10 '06 #4

P: n/a
Dear all,

Thank you for your help and suggestion. I have try to rename the backup
name and make sure the path of backup. And, I use command "db2ckbkp" to
check the detail information of backup image file. But the problem
didn't solve.

Once, I compared 2 different backup image from v7.2 and v8.2.
"Instance" of databases are different. V7.2 database is "DB2", V8.2
database is "DB2CTLSV". Is it the different of instance name to cause
the problem? Do you any idea?

Thanks a lot !!

Best Regards,

Justy

Jun 13 '06 #5

P: n/a
Instance name should not matter ...
If you want to restore the following image (of database OLTPDBP on
instance db2ip)

OLTPDBP.0.db2ip.NODE0000.CATN0000.20060527114855.0 01
To a database OLTPDBQ in instance db2iq, then use the command

Restore database OLTPDBP into OLTPDBQ
ch********@gmail.com wrote:
Dear all,

Thank you for your help and suggestion. I have try to rename the backup
name and make sure the path of backup. And, I use command "db2ckbkp" to
check the detail information of backup image file. But the problem
didn't solve.

Once, I compared 2 different backup image from v7.2 and v8.2.
"Instance" of databases are different. V7.2 database is "DB2", V8.2
database is "DB2CTLSV". Is it the different of instance name to cause
the problem? Do you any idea?

Thanks a lot !!

Best Regards,

Justy


Jun 14 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.