This blog promotes knowledge sharing through experience and collaboration. For more product information, visit our WebSphere Commerce CSE page. For easier navigation, utilize the Categories to find posts that match your interest.
Using the TI_DELTA_INVENTORY table
Out of the box, Commerce supports full inventory index build only but if you want to use a delta inventory index build to save time then you will need JR49419 for FEP6 or CF #1 (JR50553 for FEP7).
This fix is already included in FEP8+
Using this fix you will be able to track all search index-related delta change history for inventory in a workspace. This is done with the addition of a new tempory table TI_DELTA_INVENTORY. This temporary table is not populated by default and if you wish to use this table in FEP6 & FEP7 you must make sure the additional steps in the Readme are followed for JR49419 or JR50553.
Once the fix is installed and the additional steps are completed you will be able to use the TI_DELTA_INVENTORY table.
Here is the TI_DELTA_INVENTORY table summary from the KC
It's important to note that in order to run the UpdateSearchIndex job for delta reindexes you must use mode 6 as mentioned in the KC link below
Once you have these changes in place you can now manually populate the table with the catentries whose inventory was changed.After this the scheduled command UpdateSearchIndex will scan the records in TI_DELTA_INVENTORY and then call the preprocess job to populate the inventory temporary table(TI_INVENTORY_0), later buildindex will build the temporary table into inventory index.
ACTION_NAME_FULL_REINDEX = "F", ACTION_NAME_DELTA_REINDEX_UPDATE = "U",ACTION_NAME_DELTA_REINDEX_DELETE
Regarding the ACTION type in the TI_DELTA_INVENTORY table, you should only need to use the 'D', 'U' or 'F' action types when you insert the data into the table for indexing.