This guide describes how you can move your existing ICC itemtypes with NSE indexes to DB2TS based indexes. The guide is based on ICC 4.0.1 FP15 release. It might be that some of the issues are fixed in the future. The guide also assumes that your CM8 system is already configured for DB2TS.
The following steps are required to use DB2TS in general with Content Collector
- Install “IBM FileNet P8” as repository system in addition to Content Manager
This is required because if you do not install this connector you will have a blanc configuration page under “General Settings” > “Full Test Search Services Support” in the ICC configuration manager and the DB2TS cannot load the full text settings from the configuration database during the startup procedure.
2. Install CM8_DB2TS_Support. After the installation copy the “mailapi.jar” from \ContentCollector\ctms to \ContentCollector_DB2TS_Support\jar and SQLLIB\db2tss\plugins. Now run the AddICCConstructor_Email.ps1 to add the constructor information to the library server database.
3. Start DB2TS and verify in the log that the constructor could be loaded successfull
4. Create a new DB2TS based email itemtype with the Content Collector
Now you need to create an additional property for the batch handling while adding the items to the DB2TS stagingview table. In my case I called it TSMove.
Add this property to the itemtype.
Now you also can set a default value for this property which makes the selection afterwards easier. But this is not required.
Now you need to identify the primary key for oyur ICC itemtype. By default this should be COMPKEY in the corresponding ICMUTxxx table.
Find the ICMUT table in the ICMSTNLSKEYWORDS table.
db2 select keywordname,keywordcode from icmstnlskeywords where keywordname like ‘ICCNSE’
Now find the primary key of the table.
db2 “SELECT NAME FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = ‘ICMUT01014001’ AND KEYSEQ > 0 ORDER BY KEYSEQ ASC”
So the primary key is COMPKEY.
Now you need to find the stagingview table of the itemtype. This could be done with the following SQL.
db2 select INDNAME,STAGINGVIEWNAME,COLLECTIONDIRECTORY from sysibmts.tsindexes
I use the collection directory to identify the index. So now you have the stagingview table. You can now add the items from you ICMUT table into the stagingview table, so that the ICCIndexer can process them.
If you have a lot of mails in your itemtypes I recommend to create batches maybe by selection of the CREATES or ICCMailDate properties. This is also why I added the TSMove property, so that I also can mark the objects that are already porocessed.
Now insert the COMPKEYs from the ICMUT table into your stagingview. T
db2 “insert into sysibmts.TSSTAGING_545213 (OPERATION, TIME, BKUPSTATUS, PK01) SELECT 0, CURRENT_TIMESTAMP, -1, COMPKEY from ICMADMIN.ICCNSE001”
Refer to the following infocenter article for more information about the stagingview tables of DB2TS.
https://www.ibm.com/docs/en/db2/11.5?topic=views-sysibmtstsstaging-view