IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

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
    


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]