Posted: 8 Sep 2020 23:05 EDT Last activity: 19 May 2021 8:03 EDT
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?
***Edited by Moderator: Pooja Gadige to add platform capability tags***
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.
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!