PTF IP00014_70666 fixes the following APARs IC70666 - U+FF5E: FULLWIDH TLIDE,U+2015: HORIZONTAL BAR,U+FF0D:FULLWIDTH HYPHEN-MINUS ,U+2225: PARALLEL TO RETURN IN CORRECT RESULTS IC69858 - USING DOUBLE-BYTE QUESTION MARK IN TEXT-SEARCH RETURNS ZERO RECORDS IC67341 - HALFWIDTH KATAKANA AND KATAKANA VOICED SOUND MARK RETURN INCORRECT RESULTS Apply the fix only to Net Search Extender installation FP3. Installation on AIX: ==================== 1) as instance owner: - db2text stop - db2stop 2) as root: - Unzip the archive: NSE_95_INTERIM_IP00014_70666.tar.gz - slibclean - change to directory /lib64 (e.g. /opt/IBM/db2/V9.5/lib64) - make a backup copy of the old libs: libitxc5032.a,libctecnt20.a , libcteitl20.a ,libctecp.a and libcteue.a - copy the new libs into the directory /lib64 - check the permissions and ownership of the new libs. The libs needs permission 555 and needs to belong to the owner and group bin. (e.g. -r-xr-xr-x 1 bin bin 731172 Oct 12 14:40 libctecnt20.a) - copy libctecp.a and libcteue.a into the directory /function - check the permissions and ownership of the new libs. The libs needs permission 555 and needs to belong to the owner and group bin. - slibclean - update DB2 instance. 3) as instance owner: - db2start - db2text start - db2text level should now show the below COS and ITL levels itlR3-90 COSLibR5-29 NOTE: ==== This Note is applicable only for SJIS database and for the searches that are used on double byte special characters. An environment variable is introduced which needs to be manually set/unset depending on the conversion table in use. If default conversion table is used , set the following environment variable before creating the index . export NSE_SJIS_USE_IBM_UCODE= TRUE db2set DB2ENVLIST=NSE_SJIS_USE_IBM_UCODE Restart DB2/NSE This helps in converting the characters in SJIS format to UNICODE according to IBM conversion table during update index process. The variable should be unset while Microsoft conversion table is in use.