When DB2 performs an index or table scan, DB2 will block on a row lock when it comes across an uncommitted row which another transaction has exclusively (X) locked.
DB2 在执行索引或表扫描时,如果遇到一个被另一个事务独占 (X) 锁定的未提交行,那么 DB2 将阻塞在行锁上。
For MDC tables, the selection of BLOCKINSERT may improve the performance of INSERT operations by locking at the block level and avoiding row locks for INSERT operations.
对于mdc表,选择BLOCKINSERT可以提高INSERT操作的性能,因为使用的是块级的锁,避免了为INSERT操作使用行锁。
The solidDB solution is made possible by the ability to allocate row images and row shadow images (different versions of the same row) without using inefficient block structures.
solidDB 解决方案之所以能够实现, 是因为做到了分配行镜像和行影子镜像(相同行的不同版本),而不必使用低效的 块结构。
应用推荐