The text_db Database

During the installation of the Full-Text Search engine, a database named text_db is added to Adaptive Server using the installation script installtextserver, as described in “Running the installtextserver Script”. The database does not contain any user data, but contains two support tables: vesaux and vesauxcol. These tables contain the metadata used by the Full-Text Search engine to maintain integrity between the Adaptive Server source tables and the Verity collections.

When updating the collections after an insert, update, or delete is made to an indexed column, the Full-Text Search engine queries the vesaux and vesauxcol tables. These tables determine which collections contain the modified columns so that all affected collections are updated. The Full-Text Search engine also uses these tables when it is brought online, to make sure that all necessary collections exist.