This command enables Text Extender to search in text files that are not in a DB2 UDB database.
Tip |
---|
This command cannot be used if the text columns in the table share a common index, as described in Enabling a text table. |
Authorization
You must have at least one of the following for the table:
ALTER privilege
SELECT privilege
UPDATE privilege.
>>-ENABLE TEXT FILES--table-name---HANDLE--handle-column-name---> >-----+-----------------------+---------------------------------> '-| text-information |--' >-----+----------------------------+----------------------------> '-| index-characteristics |--' >-----+----------------------------+----------------------------> '-UPDATEINDEX--+-UPDATE---+--' '-NOUPDATE-' >-----+------------------------------+--------------------------> '-TABLESPACE--tablespace-name--' >-----+---------------------+---------------------------------->< '-COMMITCOUNT--count--' text-information |---+---------------+---+---------------------+-----------------> '-CCSID--ccsid--' '-LANGUAGE--language--' >-----+-----------------+---------------------------------------| '-FORMAT--format--' index-characteristics |---+-----------------------------------------------------------------+-> '-INDEXTYPE--+-PRECISE----+---+--------------------------------+--' +-LINGUISTIC-+ '-INDEXOPTION--+-CASE_ENABLED-+--' +-DUAL-------+ '-NORMALIZED---' '-NGRAM------' >----+--------------------------------------------------------------------------------+-> | .-,------------. | | V | | '-INDEXPROPERTY--SECTIONS_ENABLED--+-DOCUMENTMODEL--+---(-----modelname---+---)--' '-DOCUMENTMODELS-' >----+----------------------------------------+-----------------> '-UPDATEFREQ--+-NONE------------------+--' '-| update-frequency |--' >-----+-------------------------------------------------------------------------------+> +-DIRECTORY--directory----------------------------------------------------------+ | .--------------------------------------------------------------------------. | | | .-,---------------------. | | | V V | | | '----DIRECTORY--directory--ON--+-NODE--+---(-----node--+-----------+--+---)---+-' '-NODES-' '-TO--node--' >---------------------------------------------------------------| update-frequency |---MIN--(--mindocs--)--D---(--+-*------------+---)---H---------> | .-,-------. | | V | | '----0...6---+-' .-,---------. V | >----(--+-*-------------+---)---M---(-----0...59---+---)--------| | .-,--------. | | V | | '----0...23---+-'
Command parameters
For a description of the other command parameters, see ENABLE TEXT COLUMN.
Usage notes
This command adds a handle column to the specified DB2 table. Each handle column is associated with a collection of external text files, and is used by Text Extender's UDFs. An index is created that is associated with these files.
After you have enabled the text files, initialize handles in the handle column using INIT_TEXT_HANDLE. Then fill the index using UPDATE INDEX.
You cannot reuse a handle column name if that name has been used before in ENABLE TEXT FILES to identify a handle column of a text column.
A log table is created for recording changes to the files, but you must activate the triggers manually to record these changes because DB2 UDB does not have the files under its control and is therefore not aware of such changes. See Updating an index for external files for a description of how to do this.
If you run out of log space in this step, see Enabling a text column in a large table for possible solutions.