Getting the db2text indexes information in DB2 9.x

September 16, 2012 in Database

You may want to get the db2text indexes information in your current DB2 database. In order to do this, you can get these information using this SQL statement:

SELECT INDNAME, TABNAME, COLNAME, LANGUAGE, RECREATEONUPDATE, CREATIONTIME, UPDATETIME, 
UPDATEFREQUENCY FROM db2ext.textindexes

Leave a reply

Your email address will not be published. Required fields are marked *


Skip to toolbar