Utilities for filtering on long string field content in a Db2 database

You can filter based on the content of long string fields if the IBM® Db2® Text Search feature is enabled. This feature is also known as full text searching.

The Db2 Text Search feature is installed and configured during the IBM OpenPages® installation process. For more information, see the IBM OpenPages Installation and Deployment Guide

Warning: Do not include long string fields that are encrypted using field level encryption in the search criteria because they can return unexpected results.

If you are using OpenPages on IBM Software Hub, you must download the full text search utilities before you can apply the filters.

For more information, see Post-provisioning setup for OpenPages.

Long string fields allow users to enter values over 4 KB in length. For information about setting up long text fields, see Long String data type.

You can do the following tasks to manage full text searching:

For information about how to disable Db2 text search, see Disabling a database for Db2 Text Search.

To apply filters with long string fields, you must change the Platform > Database > Text Indexes setting to true.

If the value is set to true, filtering is enabled on long string fields. The default value is false.

For details on working with settings, see Viewing the Configuration and Settings page.