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

    Unanswered: steps for monitoring locks in tables.

    Hi, colleagues,
    Can anyone tell me the steps to monitor locks on tables, my idea is to build a script and executing collect information of locks in the tables.

    Thank you very much.

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    three ways:
    1 db2 get snap shot for locks on <dbname> (plz update monitor switches first )
    2 db2pd -d dbname -locks show locks
    3 db2 create event monitor for locks ..........................(maybe some performance impact)

Posting Permissions

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