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 12. 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 13. 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.