Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming


Backing up and restoring indexes and enabled databases

You can backup and restore enabled databases and the text indexes that Text Extender has created.

To backup:

  1. Find out which tables have been enabled by Text Extender. To do this, enter
     db2tx "GET STATUS"
    

  2. Find out the names of the index directories used by the database. To do this, enter
     db2tx "GET INDEX SETTINGS"
    

  3. Stop the Text Extender server. To do this enter TXSTOP

  4. Backup the index directories and their subdirectories index and work.

  5. Backup the file desmastr.dat which is located in:
         instance_owner_home_directory/db2tx/txins000 (UNIX)
      or
         DMBMMPATH\db2tx\txins000 (OS/2 and Windows NT)
    

    Note that for partitioned databases, there are several instance directories, named txins000, txins001, ..., so it would be more convenient to backup the whole .../db2tx directory rather than the files in the individual directories.

  6. Restart the Text Extender server:
    TXSTART
    

To restore:

  1. Stop the Text Extender server:
    TXSTOP
    

  2. Save the existing desmastr.dat file.

  3. Restore the backup copy of the desmastr.dat file.

  4. Restore the backup copies of the index directories to the same path as before.

  5. Restart the Text Extender server:
    TXSTART
    


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