db2ext.textindexformats view

Format and model information for indexes is available in the db2ext.textindexformats view. This is an example using the index name:

db2 "select FORMAT from DB2EXT.TEXTINDEXFORMATS where INDSCHEMA='myschema' 
     and INDNAME='myindex'" 

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

Table 14. db2ext.textindexformats view
Attribute Type Notes
INDSCHEMA VARCHAR(128) Schema name for the index (used as prefix for indexname and schemaname in the log table).
INDNAME VARCHAR(128) Index name specified in CREATE INDEX command.
FORMAT VARCHAR(30) The model is bound to this format.
MODELNAME VARCHAR(30) The name of a document model.
MODELFILE VARCHAR(256) File containing the model definition.
MODELCCSID INTEGER CCSID of MODELFILE.
DEFAULT INTEGER Currently 1, as multiple formats in an index are not currently supported.