Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Lock level table db2

    Hi Colleagues,

    Somebody can say me how to look the lock level in a table db2.


    Thank you for advanced.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS are you using?

    Andy

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi,
    I am using DB2 Version 9.5 and OS AIX 6

    Thank you for advanced.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

  5. #5
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi,

    I need to look if the lock level in the table is row or table, if you can give me an example is welcome.
    Than yuo for advanced.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Maybe you want what is in syscat.tables.locksize

    Andy

  7. #7
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    you can get the lock level info from the lock snapshot "db2 get snapshot for locks on DB_NAME".

    From the snapshot look out for something like the following ( based on whether you are in V8 or V9).

    Lock object type = Row
    Lock mode = Exclusive Lock (X)
    Lock mode requested = Next Key Share (NS)
    Name of tablespace holding lock = USERSPACE1
    Schema of table holding lock = DB2(R)
    Name of table holding lock = STAFF
    ------
    Lock Name = 0x00020026000000000000000054
    Lock Attributes = 0x00000000
    Object Type = Table
    Tablespace Name = USERSPACE1
    Table Schema = XXXX1
    Table Name = SIXXXX1
    Mode = S

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

Posting Permissions

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