I get the following piece of information from snapshot for locks:

Lock Object Name = 476723263
Node number lock is held at = 0
Object Type = Key Value
Tablespace Name = DTBS_SETSPACE1
Table Schema = SM_SET
Table Name = CORP_ENTITLE_QTY
Mode = X
Status = Granted
Lock Escalation = NO

and I don't quite understand what is Key value in Object Type. Does someone know? When will this type of lock be acquired?

Object type:
The type of object against which the application holds a lock (for object-lock-level information), or the type of object for which the application is waiting to obtain a lock (for application-level and deadlock-level information).

here key value.......may be pointing to INDEX key value. I am not sure

Thanks chavadb2.
But DB2 claims it will not lock index ...

Hi,

It depends on using type of index. The default type of index in version 8 is index type 2. But if you have migrated from version 7 and didn't apply reorg index statement, then lock can be made on indexes.

You should post the db2 version and fixpack level and os version and fixpack.

Hope this helps,
Grofaty

At the same time, what does
LockObject Name = 0 mean?

This is version 8.1 fp 5 on aix 5.2 and all indexes have been converted.

Thanks Grofaty. V7.2.5, ON AIX 5.X