Question
2
Replies
26
Views
Posted: September 8, 2020
Last activity: September 9, 2020
Solved
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?
Posted: 5 months ago
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!
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