Setting up product-scoped cacheless search

At some customer sites, a significant proportion of the product structure data in the databases is no longer in use, for example, it belongs to programs that are complete and no longer active. If you index this data for spatial searches, it has an adverse impact on the speed at which indexes are created and also on search performance. This enhancement allows you to limit spatial and attribute searches to active programs, which may correspond to end items, top-level items, or top-level product items. When product-scoped search is deployed, users can search on all levels of the product.

By default, all data is unsearchable and you must run the qsearch_process_queue utility on the chosen product structures to mark all items and occurrences that are part of those structures as indexable. The create_or_update_bbox_and_tso utility then processes only bounding boxes attached to indexable product structures and their components. This utility also identifies missing bounding box and TSO data for indexable products.

Once an active structure is indexed, you can make incremental updates to its spatial search index, rather than generating a complete new index each time. Incremental index updates are restricted to product structures previously identified as active. To process the queue, the administrator runs the qsearch_process_queue utility with the -process_queue option.

To deploy cacheless search for a product-scoped strategy:

1. Ensure you have enabled or upgraded cacheless search with Teamcenter Environment Manager (TEM) before you begin the deployment procedure.
2. Ensure that live background updates are turned off while you manually process the product data.
3. Prepare your data for processing by updating legacy transforms and removing cycles from the database. This step must be completed carefully or the results of searches may be incorrect.
4. Enable product-scoped cacheless search.
5. Make the product indexable. This step makes all components of the chosen product available for cacheless searches.
6. Create the bounding boxes and TSO files for the chosen product.
7. After the bounding boxes and TSO files are available, populate the queue with the entries for the chosen product. Do not run the qsearch_process_queue utility until the create_or_update_bbox_and_tso has finished.
8. Process the queue for the chosen product.
9. If you want to make other products in the database available for cacheless searches, repeat steps 3 through 6 for each product in turn.
10. Query for and process any bounding boxes remaining in the database that do not belong to the products you have already processed.
11. Configure live background updates with Dispatcher or cron jobs to process changes to the indexed data.

Note: In a typical system, you may run a cron job every 15 minutes to process updates. The value could be adjusted, depending on how frequently data changes and the extent of those changes.

Always turn off live background updates if you run the qsearch_process_queue utility to manually process the queue.