Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Unanswered: meaning of a "lock name"

    I'm just wondering if any meaningful information can be obtained by interpreting a lock name as it appears in the lock snapshot, e.g.

    Code:
    Lock Name                   = 0xA6B2A69FA4A17C7D9176505041

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Hexadecimal Code

    Hi,

    This seems a hexadecimal code. We have tried many options to intercept what it is all about however we have had no success.

    Please let us know if you have some break through.

    Thanks in Advance.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Re: Hexadecimal Code

    The documentation says:
    "Internal binary lock name. This element serves as a unique identifier
    for locks."

    What more do you need? Curious.

    jono
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    For a row lock, I think it is the table id and RID.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Hexadecimal Code

    Originally posted by J Petruk
    The documentation says:
    "Internal binary lock name. This element serves as a unique identifier
    for locks."

    What more do you need? Curious.

    It is I who is curious :-)

  6. #6
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Re: Hexadecimal Code

    Originally posted by n_i
    It is I who is curious :-)
    You spent all Easter thinking about this, didn't you?

    There seems to be some pattern to it, locks of the same type seem to share the same characters, locks on the same table seem to share some characters... I doubt they publish anything official on the subject though.

    I think it goes tablespace id -> object id (table) -> a bunch of other stuff -> lock type (row/mode)?
    --
    Jonathan Petruk
    DB2 Database Consultant

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Hexadecimal Code

    Does it name include the database seed also ?

    Cheers
    sathyaram

    Originally posted by J Petruk
    You spent all Easter thinking about this, didn't you?

    There seems to be some pattern to it, locks of the same type seem to share the same characters, locks on the same table seem to share some characters... I doubt they publish anything official on the subject though.

    I think it goes tablespace id -> object id (table) -> a bunch of other stuff -> lock type (row/mode)?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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