This command enables a database to create and exploit full-text indexes on text columns.
Authorization
You must run this command as a database administrator to enable the database. This requires you having SYSADM authority to be able to grant DBADM to the DB2 instance owner.
Command syntax
>>-ENABLE-DATABASE-FOR-TEXT--+----------------------+---------->< '-|connection-options|-' connection-options |--+--------------------------------------------------------------+--| '-CONNECT-TO--database-name--+-------------------------------+-' '-USER--userid--USING--password-'
Command parameters
Usage
This command prepares the connected database for use by DB2 Net Search Extender. It is a mandatory step before you can create a DB2 Net Search Extender index on tables/columns in the database.
You can view the database defaults established after running the command by using the DB2EXT.DBDEFAULTS catalog view.
The ENABLE DATABASE command creates various database objects in the schema DB2EXT, such as DB2 Net Search Extender catalogs, UDFs, and stored procedures. After running the command, the following catalog views are available:
db2ext.dbdefaults db2ext.textindexes db2ext.textindexformats db2ext.indexconfiguration db2ext.proxyinformation
Note that DB2 Text Information Extender views are also available for backward compatibility reasons. See Appendix C, Net Search Extender information catalogs for further information.
Also note that the above tables are located in the default tablespace of the database, known as IBMDEFAULTGROUP. This is distributed over all the nodes defined in db2nodes.cfg