Installation verification on Windows

You should verify that your copy of NetSearch Extender is properly installed to prevent some maintenance issues.

Complete the following steps to verify that Net Search Extender is correctly installed.

• Non partitioned environment:
  1. Set up the sample text indexes as follows:
     1. Call db2cmd to open a DB2® command window.
     2. Change to sqllib\samples\extenders\db2ext
     3. From the DB2 command window, call nsesample.bat yourdb. Note that this command creates the database if it does not already exist.
     4. Check the generated output file nsesample.log in the current directory.
  2. Call the following sample queries to execute in the DB2 command window:
     1. Connect to your database using db2 connect to yourdb
     2. Execute the sample queries using db2 -tvf search
     3. Check the results of the queries contained in the script. Note that every query should return one or more hits.
  If there are no errors in the nsesample.log file and all the queries are working, Net Search Extender is successfully installed.
• Partitioned database environment: Set up the sample text indexes as follows:
  1. Call db2cmd to open a DB2 command window.
  2. Change to <sqllib>\samples\extenders\db2ext
  3. From the DB2 command window, call nsesample_partitioned.bat <yourdb>.
  4. Check the generated output file nsesample_partitioned.log in the current directory.
  If there are no errors in the nsesample_partitioned.log file and all the queries are working, Net Search Extender is successfully installed.