IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

db2ext.indexconfiguration view

Index configuration parameters are available in the db2ext.indexconfiguration view. The view is available through normal SQL query facilities. This is an example using the index name:

db2 "select VALUE from DB2EXT.INDEXCONFIGURATION where INDSCHEMA='myschema' 
     and INDNAME='myindex' and PARAMETER ='INDEXSTOPWORDS'" 
 

Additional contents of the view are found in the following tables.

Table 11. db2ext.indexconfiguration view

Attribute Type Notes
INDSCHEMA VARCHAR(128) Schema name of the index.
INDNAME VARCHAR(128) Name of the index.
PARAMETER VARCHAR(30) Type of parameter.
VALUE VARCHAR(512 Value of the parameter.

For the PARAMETER and VALUE attributes, there are several values available.

Table 12. db2ext.indexconfiguration view

Attribute and values Attribute and values
PARAMETER VALUE
- TREATNUMBERASWORDS - 0 or 1
- INDEXSTOPWORDS - 0 or 1
- UPDATEDELAY - seconds >= 0

For further information, see the CONFIGURATION option of the CREATE INDEX command.


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