Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

GET INDEX SETTINGS

This command displays the settings of an index, showing the following:

Authorization

None.

Command syntax

>>-GET INDEX SETTINGS--table-name------------------------------->
 
>-----+-----------------------------+--------------------------><
      '-HANDLE--handle-column-name--'
 

Command parameters

table-name
The name of the text table in the connected database whose index settings are to be displayed. The name must include an explicit schema name (qualifier) unless the schema name is the same as your user ID.

HANDLE handle-column-name
The name of the handle column whose index settings are to be displayed.

Usage notes

If the table is enabled as a multi-index table, this command displays the index settings of all enabled text columns in the table. If a handle-column-name is provided, this command displays the index settings of the specified column.

If the table is a common-index table, the settings of the common index are displayed. If a handle-column-name is provided, it is ignored.

If the table or column is enabled with the index property SECTIONS_ENABLED, the command GET INDEX SETTINGS displays the default model for the index. The default model is the model name you specified during enabling or the first model name in a list of model names. Here is an example:

Current index settings:
 
      Index type                (INDEXTYPE)  = LINGUISTIC
      Default model         (DOCUMENTMODEL)  = mymodel
      Update index option     (UPDATEINDEX)  = UPDATE
      Update frequency         (UPDATEFREQ)  = NONE
      Node 1
      Index directory           (DIRECTORY)  = /home/user1/db2tx/indices


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