Database level lock
I know Pega handles object locking using Pega-level lock mechanism (PR_SYS_LOCK) but customer asks if database-level (row) lock is also applied? Or only Pega level lock is involved and there is no locking at database level?
Accepted Solution
Updated: 9 Sep 2020 4:32 EDT
Proximus
BE
Hello, There's always a lock a DB level to be able to write rows. In your pega app, if you open a tab in which you can update customer info (example) there will be a lock on this customer object but not lock yet at DB level. If you perform update and submit, transaction will make a lock at DB level. this is basic example of course. Regards Anthony
IT Solution Service
SG
I see. When work object is opened by Perform mode, system gets lock at Pega-level, but not database level yet. When actually inserted and updated in the table system does DB-level locking. Got it, thanks!