Database transactions performed during a pdm_k_reindex

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

What are the database transactions that are performed during a pdm_k_reindex?

Environment

Service Desk Manager 12.x, 14.1 and 17.x

All Supported Database Servers

Resolution

The following database transactions are performed during a pdm_k_reindex.

This command initializes the utility for re-indexing knowledge documents and updating search related settings.

1. Turns on flag in column "reindex_on" in the table USP_PROPERTIES
   
   
2. Truncates current search table (EBR_FULLTEXT or EBR_FULLTEXT_ADM tables)
   
   
3. Populates current search table with keyword data (EBR_FULLTEXT or EBR_FULLTEXT_ADM tables)
   
   
4. Copies changed/added "noise-words", "special terms", "synonyms", and "parse settings" in the EBR_PROPERTIES table
   
   
5. Switch tables (EBR_FULLTEXT or EBR_FULLTEXT_ADM tables)
   
   
6. Creates indexes in the current table (EBR_FULLTEXT or EBR_FULLTEXT_ADM tables)
   
   
7. Turns off the flag in the "reindex_on" column in the table USP_PROPERTIES