If you choose to implement catalog search functionality for your site, you should be aware of the following limitations:
Searches that query columns with LONGVARCHAR datatypes (such as the CATENTRY long description) are extremely slow. This is because the values are very large (32kb).
Case-insensitive searches are not permitted on LONGVARCHAR datatypes due to DB2 limitations.
Searches that query columns with LONG datatypes (such as the CATENTDESC long description) are not supported.