Question & Answer
Question
How can I use jdbc3 in AIX 6 to display Chinese characters in IBM Tivoli Netcool/Impact 5.1.1?
Cause
The netcool.log file contains the following message:
" An unrecognized CHARSET property was specified:UTF-8(GB18030,gb2312)"
Answer
The message usually indicates that the incorrect CHARSET is specified in
$NCHOME/impact/etc/<ServerName>_com.sybase.jdbc3.jdbc.SybDriver.props
CHARSET=<value>
You must replace <value> with a valid character set value. The value must be a character set that is supported by the object server or the Sybase database that you use.
This link refers you to the supported locales document, for the supported languages, for each platform. The JRE does not support all languages on all platforms.
http://www.oracle.com/technetwork/java/javase/system-configurations-139862.html
The following example shows the configuration that is required to enable Impact 5.1.1 and AIX 6.1 to display Chinese characters:
[impact:/opt/netcool/log]# locale
LANG=zh_CN
LC_COLLATE="zh_CN"
LC_CTYPE="zh_CN"
LC_MONETARY="zh_CN"
LC_NUMERIC="zh_CN"
LC_TIME="zh_CN"
LC_MESSAGES="zh_CN"
LC_ALL=
[impact:/opt/netcool/log]# locale charmap
IBM-eucCN
[impact:/opt/netcool/impact/etc]# vi NCI_com.sybase.jdbc3.jdbc.SybDriver.props
"NCI_com.sybase.jdbc3.jdbc.SybDriver.props" 1 line, 18 characters
CHARSET=eucgb
Check that there are no trailing blank spaces after "CHARSET=<value>"
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21468888