IBM FileNet P8, Version 5.2.1            

Improving processing of replication journal entries (Microsoft SQL Server)

For systems that use a Microsoft SQL Server database, add an index to the replication queue to improve the rate of processing of replication journal entries.

If there is a backlog of more than approximately 50,000 rows in the replication queue, add an index to reduce the backlog.

To create an index:

Use the Microsoft SQL Server database tools to enter the following command:
CREATE UNIQUE INDEX RQDES ON ReplicationQueue (destination_id, exclusion_id, seqnum_identity)


Last updated: October 2015
p8ppt070.htm

© Copyright IBM Corporation 2015.