IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

ENABLE DATABASE

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

CONNECT TO database-name
The name of the database that is a target for this command. You can omit this parameter, if DB2DBDFT is set and the user is running the command under a user ID with the necessary DB2 authorizations.

USER userid USING password
Use a password and userid to connect to the database.

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.

Changes to the database
This command grants DBADM authority to the DB2 instance owner associated with the DB2 instance of the enabled database.

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

Changes to the file system
None.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]