I have 2 instances on the same box say Inst1 and Inst2. Inst1 has got a database say db1 with following properties:

Database territory = JP
Database code page = 932
Database code set = IBM-932
Database country/region code = 81
Database collating sequence = UNIQUE

I have cataloged db1 on Inst2 which has its own databases as well.

When I try to connect to db1 from Inst2, I am getting error:

db2 connect to db user username using passwd

SQL0332N There is no available conversion for the source code page "819" to
the target code page "UNKNOWN". Reason Code "1". SQLSTATE=57017

I was reading thru all the posting on this issue before and found changing
DB2CODEPAGE setting will help. I did as below:

db2set DB2CODEPAGE=932

After this when i tried to connect, it connected, but then I was not able to connect to databases on the Inst2 itself and got the same error as above.

Can anyone tell how can i get access to both.

Also one strange thing, when another user tries to log in by using his id, he is able to connect without any issue. He could even connect to the local databases. This is without doing any change.

Please help.

We are on Db2 Aix 4.3

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.0.64", "s040812", "U498349", and FixPak "7".
Product is installed at "/usr/opt/db2_08_01".