PTF IP23023 fixes APAR IC66613 This fix handles the following situation: Problem Description : Some of the queries using NSE Fuzzy search on numerical/alphanum values consumes lot of memory and results in a system hang or CTE0104 error. The memory allocated is not freed even after the termination of application. This APAR fix addresses the following: 1.Memory is freed after the query returns with CTE0104 error. 2.Reduces the memory consumption in case of Fuzzy search on alphanumerical values that contain a combination of SBCS and DBCS characters The fix can be applied to Net Search Extender installations V95GA and V95FP3. Installation on AIX: ==================== 1) as instance owner: - db2text stop - db2stop 2) as root: - 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 and libcteitl20.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 1738377 Aug 13 23:24 libitxc5032.a) - slibclean 3) as instance owner: - db2start - db2text start - db2text level should now show the below COS and ITL levels itlR3-89_IC66613 COSLibR5-28"