Verifying that the sifter is functioning
Use the following procedure to verify that the sifter is functioning correctly:
- Make sure the LikeMinds database has transaction data. Attention: This procedure will work only if the LikeMinds database has transaction data. Also, you must shut down the WC_LikeMinds server in WebSphere Application Server to input database configuration changes.
- Stop the WC_LikeMinds server in WebSphere Application Server.
- In the Lps_User_Data table, update all values in the sift_pri
column to the numeric value "1".
For example:
update lps_user_data set sift_pri = 1
- Delete all rows in the Lps_Trx_Mentor table.
For example:
delete from lps_trx_mentor
- Delete all rows in the mentor pool table (that is, Lps_Trx_Pool).
For example:
delete from lps_trx_pool
- Start the WC_LikeMinds server inside WebSphere Application Server.
- If the instance is working correctly, you should see records begin to accumulate in the lps_trx_mentor table, and the lps_trx_pool table as customers browse the site.