This command enables the current database to store text data.
Authorization
You must have:
SYSADM authority
DBADM authority.
Command syntax
>>-ENABLE DATABASE---------------------------------------------><
Command parameters
None.
Usage notes
You must be connected to a database , either explicitly or implicitly, before issuing this command (see CONNECT). This command prepares the connected database for use by Text Extender. It is a mandatory step before a Text Extender text table or text column can be enabled in the database .
ENABLE DATABASE creates a Text Extender catalog view called DB2TX.TEXTINDEXES, described in Working with the Text Extender catalog view, and a catalog view called DB2TX.TEXTCOLUMNS used for "performance" queries.
It also creates text configuration settings, described in Text configuration settings.
Some other administration work is also done, such as the declaration of UDTs and UDFs.