Restore database from v7.2 to v8.2

[chow.justy]

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

[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?

[Michel Esber]

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

[Pierre Saint-Jacques]

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

[chow.justy]

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

[Sathyaram Sannasi]

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