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

Comments are closed.

Skip to toolbar