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