Enabling Real Time Indexes

Follow these steps to enable Real Time Indexes.

  1. Verify that your index is current by running a full or incremental build.

    This allows a baseline index for RTI to add records.

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

    1. Enter the search definition (from the list above) in the filter box and select Search.

    2. Select the correct search definition by selecting the row in the grid.

    3. Select the Enable check box.

  3. If the Configure Batch check box is already selected, a list of selected Batch jobs for RTI enabled transactions are displayed.

    Use the Document Count field to set a minimum threshold beyond which RTI is disabled for the selected trigger records. Use the Honor Batch Switch to decide which processes (batch programs) honor the RTI batch switch.

    Note:

    PeopleSoft Applications delivers a list of batch jobs that disables RTI if the number of records to be processed adversely affects RTI performance. These batch jobs are added to the Configure RTI page. Based on system demands, administrators can set a minimum threshold to determine when the batch job disables RTI.

  4. Select Save.

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

    MSS, DB2, and Oracle are supported.

    Note:

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

    Some browsers open three tabs with the SQL in them. Close the one that are not applicable.

  6. Provide the trigger to your database administrator to apply to the database and have them bounce all process schedulers.

    WARNING:

    Any time a change is made to the RTI configuration using the Configure Real Time Indexing page, or using PeopleCode in the application class, and 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.