DEACTIVATE CACHE

This command releases a cached table. A persistent cache is kept to be reused on the next ACTIVATE command. Until the next activation, search operations via the stored procedure are no longer possible on the deactivated cache.

Authorization

According to the DB2 catalog views, the userid in this command must have the CONTROL privilege on the table the full-text index was created for.

Command syntax

Read syntax diagramSkip visual syntax diagram>>-DEACTIVATE-CACHE-FOR-INDEX----------------------------------->

>--+------------------+--index-name--FOR-TEXT------------------->
   '-index-schema-"."-'

>--+----------------------+------------------------------------><
   '-|connection-options|-'

connection-options:

|--+--------------------------------------------------------------+--|
   '-CONNECT-TO--database-name--+-------------------------------+-'
                                '-USER--userid--USING--password-'

Command parameters

index-schema
The schema of the text index as specified in the CREATE INDEX command. If no schema is specified, the userid of the DB2 connection is used as schema name.
index-name
The name of the text index as specified in the CREATE INDEX command.
CONNECT TO database-name
The name of the database that is target for this command. You can omit this parameter, if DB2DBDFT is set and the user is running the command on the server. Note that the user ID must have the required DB2 authorizations.
USER userid USING password
Use a password and userid to connect to the database. If not specified, a connection is attempted from the current user ID without a password.

Usage

Note that this command could not be issued when one of the following commands is running on the index:

Note

After deactivation of a persistent cache, the cache is made inaccessible for search by the stored procedure. However, this can be used for fast ACTIVATE, unless an update was performed in the meantime.

In this case, the persistent cache is automatically recreated from scratch using the ACTIVATE CACHE command.