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.

db2set DB2CODEPAGE=1252 -g

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

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.

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?

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.