I would like to verify the facts or what I think the fact is.
1.) When inserting a row, does DB2 on OS/390 always locks whole table with
2.) Is it different with DB2 on Win/Linux/Unix?
In MS SQL Server online help I found a chapter about Key-Range Locking
which is apparently a mechanism used to enable concurrent inserts and other
dml. Never tested it, will give it a try just to see.
I am somewhat surprised to see more advanced concurrency mechanism in MS
product. I thought DB2 would be superior database in terms of concurrency.
PS. This is not a flame bate, but If you feel like it then just go ahead :)