Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: how i can get the lock detail information?

    i'm new user of db2(os390).
    i know use -display database(**) locks to see the lock information
    but i do not know how to differentiate the lock level ,row page table or ts.
    when i update 1 row data,i do not know it will lock a page or a table
    how can i do ?

  2. #2
    Join Date
    May 2003
    There are two ways:

    1. Look at the tablespace definition and see what the locksize is. If the locksize is ANY keep in mind that the locksize can escalate from page to tablespace at runtime.

    2. There are some monitoring tools, but I am not sure exactly all the ones that are available. Try checking the manuals. Hopefully some else can expound on this.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2004
    You can also look in the DB2 job in SDSF for the lock escalations.

Posting Permissions

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