Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question Unanswered: lock-wait on tables

    AIX 5.2 DB2 8.1.4.

    At times i try to perform operations on tables that are in normal access
    mode. Nevertheless i instantly get a lock-wait i the applications listing, as
    soon as i try anything on the table.

    Is there any way that I can see a more detailed information on the table, and more precisely which process is locking it ??

    Thanks in advance for any advice.
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

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

    Re: lock-wait on tables

    Originally posted by Tank
    AIX 5.2 DB2 8.1.4.

    At times i try to perform operations on tables that are in normal access
    mode. Nevertheless i instantly get a lock-wait i the applications listing, as
    soon as i try anything on the table.

    Is there any way that I can see a more detailed information on the table, and more precisely which process is locking it ??

    Thanks in advance for any advice.
    GET SNAPSHOT FOR LOCKS ON DATABASE your_db_name

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Talking

    You're the man!
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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