Start of changeIBM FileNet P8, Version 5.2.1            

Improving Content Consistency Checker queries that use a date range

Content consistency checks that are run with a date range selected can be optimized for better query performance by adding indexes to the DocVersion and Annotation database tables.

You can improve query performance for content consistency checks that are run by using a Validate by Date Created or Validate by Date Modified validation range. To improve query performance, you append an Order by statement to the Consistency Checker SQL statement and add database indexes to the DocVersion and Annotation tables. The amount of improvement can vary, depending on the data.

You must be running Content Platform Engine 5.2.1.2-P8CPE-FP002 or later to use this option.

Important: Do not set the AppendOrderBy option without also creating the related indexes.

To tune date validation for Content Consistency Checker:

  1. Set the preference to add an Order by statement to the Consistency Checker SQL statement:
    1. In Content Consistency Checker, click File > Options.
    2. In the Report file location field, get the location of the ./plugins runtime directory. For example, C:/Users/Administrator/Desktop/workspace/.metadata/.plugins/com.ibm.filenet.ecm.consistencychecker.
    3. Save the file location and exit Content Consistency Checker.
    4. Use Windows Explorer to go to the org.eclipse.core.runtime/.settings subdirectory of the .plugins directory. For example, C:/Users/Administrator/Desktop/workspace/.metadata/.plugins/org.eclipse.core.runtime/.settings.
    5. Save a copy of the com.ibm.filenet.ecm.consistencychecker.prefs file that is in the .settings directory.
    6. Add the following line to the com.ibm.filenet.ecm.consistencychecker.prefs file: AppendOrderBy=1.
  2. Add database indexes to the DocVersion and Annotation tables.
    1. Connect to the object store database by using the database tool that is supplied with your database.
    2. Run the following commands for the OrderByDateCreated statement:
      • DocVersion table: create index I_Comp1 on schema.DocVersion ( storage_area_id, create_date, object_id)
      • Annotation table: create index I_Comp1 on schema.Annotation ( storage_area_id, create_date, object_id)
    3. Run the following commands for the OrderByDateLastModified statement:
      • DocVersion table: create index I_Comp1 on schema.DocVersion ( storage_area_id, modify_date, object_id)
      • Annotation table: create index I_Comp1 on schema.Annotation ( storage_area_id, modify_date, object_id)


Last updated: October 2015
p8ppt330.htm

© Copyright IBM Corporation 2015.
End of change