Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Posts
    3

    Unanswered: DB2 AIX 7.2 problem

    Dear all,

    I am new to DB2. After installed DB2 7.2,
    I try to restore a 6.2 database backup but it said that the codeset of image does not match with the current db setting (Create database failed)
    how can I change the default codeset and territory?

    Thank you very much.

  2. #2
    Join Date
    Oct 2001
    Posts
    68
    The same thing happened to us using AIX.

    What I had to do was create a database with the exact same CODESET settings as the backup. Restore the backup image into this new one, then use db2move to extract the table defs and data to the "true" target. Remember though db2move is not as comprehensive and you may have to recreate some RI and other constraints on the tables.

    WP

  3. #3
    Join Date
    May 2002
    Posts
    3
    I tried to create a new database and restore the image to that new database. But I come across an error 'SQL1009N'. Can anyone help?

    Thanks a lot

  4. #4
    Join Date
    Oct 2001
    Posts
    68
    SQL1009N The command is not valid.

    Explanation: The command is not supported when issued on a
    client-only workstation or against remote databases. An example
    of such a command is cataloging a local database.

    The command cannot be processed.

    User Response: Possible solutions include:

    o Issue the specified command from a non client-only
    workstation or from the workstation where the database
    resides.

    o Verify that the database is cataloged correctly.

    o Issue a different command.

    What exactly is the syntax of your command and more importantly WHERE are you running it from?

    WP

  5. #5
    Join Date
    May 2002
    Posts
    3
    Sorry, I post the wrong error number in my previous reply. I have to go back to company to check the error code first.

    Thanks for your help !

Posting Permissions

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