Hello all,

I have a following problem.

I create a backup image (online and offline) so that i would like to create a new database from this image.

But there is a problem :'SQL2548N Database codepage "1208" indicated in the backup image differs from that of the current on-disk database codepage "1252". The Restore operation has failed'
I tried to use db2set db2codepage =1252 but there is not result.

Thanhks

Hi,

There are two ways to achieve the task

1 set
db2set db2codepage =1208
db2stop
db2start
Than restore the db.

2.
2a)create a database with same name as of the backup image with the codeset of 1208.
2b) run the restore command
restore db <dbname> into <dbname which you had created>

If the container path are different than you should go for the redirect option of the restore command.

I believe this will solve your problem


Cheers,
Pushp