DB2 code page issue on V9.5

sxvank · **Joined:** Mon Jun 01, 2009 8:59 am **Posts:** 12

Expert,

We have migrated the db2 instance from v8.1 to v9.5 . After migration we are facing the issue like below

SQL0332N Character conversion from the source code page
"<source-code-page>" to the target code page "<target-code-page>"
is not supported.

Below is the DB code page setup

Database configuration release level = 0x0c00
Database release level = 0x0c00

Database territory = GB
Database code page = 1208
Database code set = UTF-8
Database country/region code = 44
Database collating sequence = IDENTITY
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Database page size = 4096

Please suggest me to resolve the code page issue. we are not able to insert the values in to the table.

Cameron McKenzie · **Posted:** Wed Aug 12, 2009 9:05 am

Quote:

Explanation
The operation failed because there is no code page conversion between the source-code-page and target-code-page. This may be due to one of the following reasons:
The character repertoires of the source code page and the target code page are incompatible, and therefore may cause character loss and corruption when converting between the source and target code pages.
This specific code page conversion is not supported.
Some of the possible operations that can cause this error include:
Connecting a client to a database where the client's code page is different from the database code page.
Executing an SQL statement where the client's code page is different from the database code page.
Importing or exporting a WSF or IXF file where the file's code page is different from the database code page.
Federated system users: the data source does not support the specified code page conversion.

http://publib.boulder.ibm.com/infocente ... 0332n.html