Backing up and restoring text indexes

You must stop the Net Search Extender services before backing up or restoring enabled databases and text indexes.

Procedure

To back up enabled databases and text indexes created by Net Search Extender:
1. Find out which indexes Net Search Extender has created and where they are stored.
  Call a select statement on the db2ext.textindexes view:
```
db2 "select indschema, indname, indexdirectory from db2ext.textindexes"
```
2. Ensure that no index update is running, and then stop Net Search Extender services.
  Issue the following command:
```
db2text stop
```
3. After backing up the database, back up the index directories and subdirectories.
4. Restart Net Search Extender services.
  Issue the following command:
```
db2text start
```
To restore the enabled databases and text indexes created by Net Search Extender:
1. Stop Net Search Extender.
  Issue the following command:
```
db2text stop
```
2. Restore the backup copies of the index directories to the same path as before.
3. Restart Net Search Extender.
  Issue the command:
```
db2text start
```