Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Hong Kong
    Posts
    41

    Unanswered: what is the meaning of 'key value' in locks snapshot?

    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?

  2. #2
    Join Date
    Aug 2004
    Posts
    138
    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

  3. #3
    Join Date
    Oct 2003
    Location
    Hong Kong
    Posts
    41
    Thanks chavadb2.
    But DB2 claims it will not lock index ...

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    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

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    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.

  6. #6
    Join Date
    Oct 2003
    Location
    Hong Kong
    Posts
    41
    Quote Originally Posted by grofaty
    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
    Thanks Grofaty. V7.2.5, ON AIX 5.X

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •