To get information about the current text indexes within the database, use the views. For example, if you want to know about the current database defaults, use the following command:
db2 "select * from db2ext.dbdefaults"
For information about the currently available indexes, their corresponding tables, and the number of indexed documents, use this command:
db2 "select indschema, indname, tabschema, tabname, number_docs from db2ext.textindexes"Use this command for information about the formats of a specific index:
db2 "select format, modelname from db2ext.textindexformats where indschema = 'DB2EXT' and indname = 'TITLE'"
For further information, see Appendix C, Net Search Extender information catalogs.
If COMMITCOUNT is not set, then the NUMBER_DOCS parameter from the db2ext.textindexes is not updated. To view the number of documents updated during the update process, use the following command:
db2text CONTROL LIST ALL LOCKS FOR DATABASE sample INDEX db2ext.title
For further information, see the CONTROL.