db2_nse [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== DB2 Text Search / Net Search Extender ======

**Install TS with Rich Text :**
<sxh bash>
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>”; 

</sxh>


**NET Search Extender index verification tool :**
<sxh bash>
checknseindex
</sxh>

**NSE Indexes :**
<sxh bash>
db2 "select indschema, indname, indexdirectory from db2ext.textindexes"
</sxh>

**NSE Locking services :**