Db2 Text Search index location

It is important to note that the default index location has changed in this release.

For an integrated Text Search server, configuration and collection metadata is stored in instanceHome/sqllib/db2tss/config on UNIX or instanceProfilePath\instance_name\db2tss\config on Windows.

The configuration and collection metadata for each text search index require little space. However, unless a custom path is specified, the location for text search indexes is in a subdirectory of db2tss/config. This location is often restricted in size, it is therefore strongly recommended to configure the defaultDataDirectory parameter for the Text Search server to a custom location with sufficient disk space if you plan to create multiple or large indexes with an integrated Text Search server.

The location of collection data is determined when you create a collection and is stored in the collection.xml file. For stand-alone Db2 Text Search servers, the location of configuration files for collections is determined by the defaultDataDirectory parameter. By default, the collection configuration directory is <ECMTS_HOME>\config\collections, while the collection data is in a subdirectory under the defaultDataDirectory\collection_name\data\text collection configuration directory.

In any case, if you plan to create multiple large indexes, consider storing them on separate or striped disk devices, in particular if concurrent index updates are scheduled.