Results 1 to 2 of 2

Thread: sql1006

  1. #1
    Join Date
    Oct 2008
    Posts
    4

    Unanswered: sql1006

    We are restoring a V8 database to V9 fp6 under Windows. The source database is a codepage 874 (Thai). The target server is codepage 1252 where the codepage has been reset to 874.

    The restore works but follows with a message that the database has not been migrated. After issuing the Db2 migrate command we see;

    SQL1006N The code page "11462254I" of the application does not match the code
    page "11462255I" of the database.

    it doesn't seem to matter the db2codepage is set at, both 874 and 1252 produce the same result (SQL1006).

    Any suggestions on how to get the migrate to work?

  2. #2
    Join Date
    Oct 2008
    Posts
    4
    Resolution: The environment variable "db2codepage" may exist at different levels (see db2set -all). The [e] level is the key and is controlled by the DOS SET command not by DB2SET. The [e] db2codepage needs to be set to the codepage of the database being restored. I also had the [i] level "db2codepage" variable set to the codepage of the backup as well, but it seems the [e] level is the important one.

Posting Permissions

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