Enabling the text search feature on Db2
About this task
To enable the text search feature on Db2® database:
- Make sure that the Db2 database is configured with the Net Search Extender plug-in.
- Log in to the Db2 server using the Command Editor or Command Line Processor with a user ID having DBA privileges.
- Verify that the text search index creation
customer_overrides.propertiesfile that is located in the
<INSTALL_DIR>/propertiesdirectory to set the
The text search indexes that are created on Db2 database using the
<INSTALL_DIR>/repository/scripts/EFrame_TextIndexAdds.sql script are
automatically updated every 6 hours. The DBA can modify this script to change this frequency, if
necessary. Before running the
EFrame_TextIndexAdds.sql script, the DBA must update
the "/*Database*/" string in the
EFrame_TextIndexAdds.sql script and specify the