Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: Create new database from Image

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    50

    Re: Create new database from Image

    Originally posted by thanhtung2003
    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

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    30
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •