********************************************************************
*       _   __  _____   ______                                     *
*      / | / / / ___/  / ____/                                     *
*     /  |/ /  \__ \  / __/                                        *
*    / /|  /  ___/ / / /___                                        *
*   /_/ |_/  /____/ /_____/     Index Migration 	           *
*                              readme for Windows                  *
*                                                                  *
********************************************************************

This readme provides the steps for migrating DB2 Net Search Extender indexes built under 32-bit DB2 instances 
to 64-bit instances on Windows.

Migration from 32-bit to 64-bit on Windows
******************************************

Planning:
=========

- Take a back-up of the database and Index directory from NSE V8/V9.x 32-bit system

Migration steps:
================

The sequence of steps for migrating a 32-bit instance with NSE indexes to a V9.x 64-bit instance is given below:

Assuming we have working V8/V9.x 32-bit DB and NSE indexes.

The 32-bit to 64-bit migration can be performed in two different ways depending on the environment:
a. The source and target machines are two different systems
b. The source and target machines are the same.

a. The source and target machines are different
   ============================================
   
- Prepare DB2 32-bit database for moving to DB2 V9.x 64-bit.
  The following drop statements are only necessary when migrating from Version 8.
  Execute the following calls before you migrate to Version 9.x because the Data Links Manager is unsupported since DB2Version 9.1
db2 Drop Specific Function DB2Ext.DataLinkContent1
db2 Drop Specific Function DB2Ext.DataLinkContent2
db2 Drop Specific Function DB2Ext.DataLinkContent4
db2 Drop Specific Function DB2Ext.DataLinkContent3
db2 Disconnect All
- Take a backup of the database and index files from the 32-bit instance.
- Move the backed-up files and database to the target machine where V9.x is installed.
- Migrate the required NSE databases to DB2 Version 9.x 64-bit.
- Restore the NSE indexes into the V9.x 64-bit set-up by following the below procedure:
	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
- Migrate the NSE database to the current release
	db2extmdb <database-name>
- Perform alter index by mentioning new index and work directories(make sure the instance owner has the sufficient 
  permission to access and alter the index files)
	Example: db2text alter index <index-name> for text index directory <new indexdir> work directory <new workdir>
- Perform searches as before and verify whether the new migrated index is searchable

b. The source and target machines are the same
   ===========================================
- Follow the below link for migrating to NSE v9.x 
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.nse.topics.doc/doc/t0052133.html
 
NOTE:
V9.x could be replaced with V9.1 or V9.5 or V9.7.