IBM FileNet P8 Content Engine (CE) - Database row locks generated while updating Access Control Lists ( ACL ) on folders impact performance.

Troubleshooting

Problem

The following statement can be found in the CE trace logs with Application Program Interface (API) and Database (DB) trace options enabled : SELECT epoch_id, lock_sid, object_id, object_class_id, security_id, parent_container_id, replication_group_id, creator, create_date, modify_user, modify_date, lock_token, lock_timeout, lock_owner, security_policy_id, name, indexation_id FROM Container WHERE (object_id = :1 and home_id is null) for update; The 'select for update' statement is executed each time the ACL of a folder is changed.

Symptom

Because of database locking behavior, concurrent changes to the ACL of a folder are not possible. Each process must wait for the row lock to be resolved. This impacts performance in scenarios with many ACL changes.

[{"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Content Engine","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"4.5.0;4.5.1","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
FileNet Content Manager

Software version:
4.5.0, 4.5.1

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
145199

Modified date:
28 April 2025

UID

swg21447866

IBM Support

Tips