5.3 Enabling Real Time Indexes

To enable Real Time Indexes:

1. Perform a full or incremental build of the search definitions that you will enable. This allows a baseline index for RTI to add records.

2. Enable RTI on the search definition using the Configure Real Time Indexing page ( Select PeopleTools, Search Framework, Real Time Indexing, Configure Real Time Indexing).

   1. Enter the search definition in the filter box.

   2. Select the row containing the correct search definition.

   3. On the next page, select the Enable check box and Save.

3. Download the trigger SQL for your database environment using the Trigger SQL link.

   The platforms MSS, DB2, and Oracle are supported.

   Note:

   When you click the link, trigger SQL is generated for each supported database. Click Cancel if you do not have this database and the next database SQL is generated.

4. Provide the trigger to your database administrator to apply to the database and have them bounce all Process Schedulers.

Important:

Any time a change is made to the RTI configuration on the Configure Real Time indexing page or in the PeopleCode in the application class, whether or not a new trigger is generated and applied, the Process Scheduler must be restarted. If you do not restart the Process Scheduler, Real Time Indexing may not pick up the changes and could fail to index your data.

For additional information about configuring Real Time Indexing,

See PeopleTools, Development Tools, Search Technology, Administering PeopleSoft Search Framework, Using Real Time Indexing.