Two requests try to update the same row
at the exact same time.
One waits.
One wins.
One might silently overwrite the other.
Do you know how to prevent this in SQL? 🤔
#SQL #Database #Databases #OptimisticLocking #RowLocking #RaceCondition #DistributedSystems #PostgreSQL
8
Here is a rowlocking good joke:
1
Happy to have made significant contributions to the core features of this super system #Db2z @Db2World #DataSharing #ParallelSysplex #CouplingFacility #RowLocking #Type2Index #CommitLSN #HybridJoin #IndexANDingORing #ARIES #logging #recovery Long Live #Db2 #DonHaderle
24 Apr 2018
Check out @DineshNirmalIBM latest blog celebrating 35th anniversary of one of the world's greatest software products #Db2z
ibm.co/Db2-35-DN exciting future with #Machine_Learning #AI the future is all about the exploiting enterprise #DATA #Db2
2
3
