Enabling product-scoped cacheless search

Prior to running the product-scoped cacheless search, you must enable it by running the qsearch_process_queue command once for every database in the following format:

qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -enable_product_scoping

This generates the QSEARCH_filter_queries_by_product_scoping preference in Teamcenter with a value of 1 (true). It also creates the following tables in the Teamcenter database:

• PQSEARCHINDEXABLEITEM
• PQSEARCHINDEXABLEOCCTHREAD
• PQSEARCHINDEXABLEAPN

Note: If you want to disable the product scoped-cacheless search, run the qsearch_process_queue -u={USER_ID} -p={PASSWORD} -g={GROUP} -disable_product_scoping -drop_table command once for every database.