Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Question Unanswered: DB2 codepage convert problem??????

    I encounter a problem of changing the db2 codepage 950, that is set as creating the db, to codepage 1252.

    I have a db2 6.2 backup with codepage 950 and i want to upgrade it to db2 7.2 and change codepage to 1252.

    thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: DB2 codepage convert problem??????

    Well, recently we had the same problem, and this is what we end up doing:

    >> Restore the database to original code page
    >> Use db2look utility to extract the structure
    >> Create database with new code page using the structure created above
    >> Use import/export and/or load command to move the data

    There might be an easier way out there but I couldn't find!!!!

    dollar

    Originally posted by foolagainhk
    I encounter a problem of changing the db2 codepage 950, that is set as creating the db, to codepage 1252.

    I have a db2 6.2 backup with codepage 950 and i want to upgrade it to db2 7.2 and change codepage to 1252.

    thanks in advance.

Posting Permissions

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