DB2 Text Search / Net Search Extender

Install TS with Rich Text :

Run db2iupdt as root: 

>db2iupdt -j “TEXT_SEARCH,db2_db2inst1,55005” db2inst1 

And this will setup the first part of TS. 

Then you will need to: 

1) login as instance owner 

2) cd $HOME/sqllib/db2tss/config 

3) configTool configureParams -configPath $HOME/sqllib/db2tss/config -installPath $HOME/sqllib/db2tss 

4) configTool generateToken -configPath $HOME/sqllib/db2tss/config -seed abcd 

5) configTool configureParams -tempDirPath /tmp/of_db2ints9 -logPath $HOME/sqllib/db2dump/tslog -installPath $HOME/sqllib/db2tss -configPath $HOME/sqllib/db2tss/config 

6) configTool configureHTTPListener -configPath $HOME/sqllib/db2tss/config -adminHTTPPort 55000 

7) db2start 

8) db2ts "start for text" 

9) db2ts "ENABLE DATABASE FOR TEXT CONNECT TO dbname USER db2inst1 USING <password>”; 

NET Search Extender index verification tool :

checknseindex

NSE Indexes :

db2 "select indschema, indname, indexdirectory from db2ext.textindexes"

NSE Locking services :