Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Toronto, Canada

    Unanswered: codeset changes when restore

    DB2 v9.5 ESE on AIX v6.1

    I need to have a database with
    Database code page = 819
    Database code set = ISO8859-1

    so I create a database with this codeset, but when I restore database (on v9.5) from backup file (from v8.2) into this database, codeset changes to:
    Database code page = 850
    Database code set = IBM-850

    which is the codeset of the database in backup image.

    What can I do to keep same codeset/page (819)?
    Last edited by MarkhamDBA; 06-16-10 at 16:31.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    You will need to use a backup of the database whose codeset is 819.

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    Backup/Restore only copies the data as-is and does not apply any kind of modifications/reorganizations. So it is just a binary copy.

    If you want to modify the code page, you need to export/import the data.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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