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
