Configuring DB2 Text Search in a partitioned environment
From the developerWorks archives
Date archived: January 12, 2017 | First published: August 29, 2013
DB2® Text Search enables DB2 database applications to perform full text-search by using embedded full text-search clauses in SQL and XQuery statements. This allows you to create powerful text-retrieval programs. DB2 Text Search supports full-text search in both non-partitioned and partitioned database environments. Partitioned setups are often used for large workloads, and as the text search index is partitioned according to the partitioning of the table, careful planning of configuration and administration tasks is needed to account for search performance and high availability requirements. The article describes the concepts behind the text index partitioning scheme and the impact on administration, the configuration for text search of a sample partitioned database setup, and discusses monitoring features and workload control options.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.