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
>>-DEACTIVATE-CACHE-FOR-INDEX-----------------------------------> >--+------------------+--index-name--FOR-TEXT-------------------> '-index-schema-"."-' >--+----------------------+------------------------------------>< '-|connection-options|-' connection-options |--+--------------------------------------------------------------+--| '-CONNECT-TO--database-name--+-------------------------------+-' '-USER--userid--USING--password-'
Command parameters
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. |