IBM Enterprise Records, Version 5.1.2    

Report performance tuning

You can apply performance tuning changes to some of the provided IBM® Enterprise Records reports.

The following table describes the performance suggestions related to some of the reports delivered with IBM Enterprise Records.

Report Name Performance suggestions
Actions Performed by a User The SQL_query statement associated with this report depends on the I_Event48 index definition. For information about improving audit logging and search performance when Auditing is enabled, see the Improving audit logging a search performance topic in the IBM FileNet® P8 Performance Tuning Guide.
Folders and Records on Hold Define a new Index on the Content Platform Engine Database LINK table to help with all hold link-involved queries for RecordHoldLink and RMFolderHoldLink. The column order for this new Link table index is defined as create_date DESC, head_id, tail_id, object_class_id. For more information about the LINK table, see the Database Table Schemas topic in the Content Platform Engine Java and .NET Developer's Guide.


Feedback

Last updated: November 2013
ier_report_perf.htm

© Copyright IBM Corporation 2013