IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Viewing text index status

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.


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