Backing up and restoring indexes

Use the following steps to back up enabled databases and text indexes created by DB2 Net Search Extender:

  1. To find out which indexes DB2 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 DB2 Net Search Extender services with the following command:
    db2text stop
  3. After backing up the database, back up the index directories and subdirectories.
  4. Restart DB2 Net Search Extender services with the following command:
    db2text start

Use the following steps to restore the enabled databases and text indexes created by DB2 Net Search Extender:

  1. Stop DB2 Net Search Extender with the following command:
    db2text stop
  2. Restore the backup copies of the index directories to the same path as before.
  3. Restart DB2 Net Search Extender with the command:
    db2text start