(C) IBM Corp. 2000
DB2 Net Search Extender Administration and User's Guide
Summary |
---|
- When
- Once for each database that contains columns of text to be searched
in.
- Command
- ENABLE DATABASE FOR TEXT
- Authorization
- SYSADM
|
This command prepares the connected database for use by DB2 Net Search
Extender.
This command also declares DB2 Net Search Extender search functions and
procedures that are described in Chapter 15, SQL scalar search function and the SQL table-valued function.
When you enable a database, you create the following tables and
views:
- db2ext.dbdefaults
- Shows the database default values for index, text, and processing
characteristics.
- db2ext.textindexformats
- Shows the list of supported formats and the model files used.
- db2ext.indexconfiguration
- Shows the index configuration parameters.
- db2ext.textindexes
- A catalog view that keeps track of all text indexes.
- db2ext.proxyinformation
- Shows proxy information for accessing files using a proxy server.
For information on all the views, see Appendix C, Net Search Extender information catalogs.
When a database is enabled, it remains enabled until you disable
it.
Note |
---|
A fenced user ID that is different from the instance owner ID does not work
with partitioned databases. |
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]