Intent Locks: Used to establish a lock hierarchy.

意向锁：用于建立锁的层次结构。

youdao

For large objects and long field data, DB2 escalates Intent None (IN) locks to Share (S) locks and therefore is approximately 10% slower.

对于大型对象和 long 字段数据，DB2 将 Intent None (IN) 锁升级为 Share (S) 锁，因而要慢大约 10%。

youdao

So we can see 3 active locks: exclusive lock on key (row) level and 2 intent-exclusive locks on the page and table levels.

我们看到了3个锁信息，一个排它锁在行记录上，两个意向排它锁在页级以及数据表对象上。

youdao