IBM Support

IBM Text Search

Technical Blog Post


IBM Text Search


 IBM DB2 Text Search provides extensive capabilities for searching data in text columns that are stored in a DB2 table. The search system provides fast query response times and a consolidated, ranked result set that quickly and easily locates the information that you require.

DB2 Text Search

  But we have some restrictions.  I'm trying to list some of them as below.


No exactly maching term in Fuzzy search result

  The Fuzzy search result with the search key string in Japanese contains NOTHING even if the normal search result with the same search key string in Japanese contains some rows.

  Because IBM Text Search utilizes the N-gram segmentation technique or the morphological analysis technique in the text index and in the Basic text search, but not in the Fuzzy text search.


Technote# 1986910: Restriction on the Fuzzy search in CJK language on IBM Text Search

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]