Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    15

    Unanswered: How to set CODEPAGE to be a Global variable (on Linux) ?

    How do you set DB2CODEPAGE to be a global [g] variable ?

    The following command, executed as db2inst1, sets DB2CODEPAGE to be an instance [i] variable:

    db2set DB2CODEPAGE=1252

    Thanks,
    Colm.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    db2set DB2CODEPAGE=1252 -g

    Surprisingly, it's mentioned in the manual, right there, on page 203

  3. #3
    Join Date
    Aug 2004
    Posts
    15
    Surprisingly, that doesn't work for me. When I do db2set DB2CODEPAGE=1252 -g,
    followed by db2set -all, I don't see DB2CODEPAGE listed in the output.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Could that be some kind of permission problem? You probably need to be an instance owner to change a global value. Also, do you issue the command at the server or while being connected remotely?

  5. #5
    Join Date
    Aug 2004
    Posts
    15
    It turned out to be a permissions issue. I issued the db2set command locally, as the instance owner (db2inst1 in this case), but the instance owner did not have permissions to write to the default.env file because they were not in the 'root' group. (default.env is created by root, I'm guessing, as part of installation). So either giving default.env world write permissions or adding db2inst1 to the root group works.

Posting Permissions

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