Unix Technical Forum

db2 connection problem (codepage)

This is a discussion on db2 connection problem (codepage) within the DB2 forums, part of the Database Server Software category; --> lvmbi@worf:~$ db2 connect to sqldba user username using difficultpwd SQL0332N Character conversion from the source code page "923" to ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 01:11 PM
michael.bierenfeld@web.de
 
Posts: n/a
Default db2 connection problem (codepage)

lvmbi@worf:~$ db2 connect to sqldba user username using difficultpwd
SQL0332N Character conversion from the source code page "923" to the
target
code page "UNKNOWN" is not supported. SQLSTATE=57017
lvmbi@worf:~$

The documentation speaks about setting the environment variable LC_ALL
to de_DE@euro. But that does not help. That target code page is still
unknown. Does anybody know what to do ?

Regards

Michael
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 01:11 PM
michael.bierenfeld@web.de
 
Posts: n/a
Default Re: db2 connection problem (codepage)

in /etc/default/locale

LANG=de_DE.iso88591

is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 01:11 PM
Colin Booth
 
Posts: n/a
Default Re: db2 connection problem (codepage)

michael.bierenfeld@web.de wrote:

> in /etc/default/locale
>
> LANG=de_DE.iso88591
>
> is your friend


I thought that 923 was 8859-15 and I believe that there are characters in
8859-15 that are not in 8895-1

Is the client with the problem on the same or a different system to the DB2
server. I assume that you can connect from the instance owner on the same
system as the server. Compare the working with the not working, in
particular the conversion files in /.../instanceowner/sqllib/conv. Also the
environmet varialbs such as LANG

It is also possible that the version of DB2 may make a difference. Are the
client and server the same version and fixpack

Colin
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:03 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com