Answer Posted / Fahad Javed
In SAP MaxDB, locks on joins are managed using a two-phase locking (2PL) mechanism. This means that when a transaction needs to read or write data, it acquires a shared lock (S-lock) or an exclusive lock (X-lock), respectively. If another transaction tries to acquire a conflicting lock, it is held until the first transaction releases its lock.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category