Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20

    Unanswered: Lokwaits increasing with onstat -p command

    Hi,

    I am new to informix.

    I have been observing that lokwaits are increasing when i use the command onstat -p.what does this mean and when could this be an issue.How do i check what is causing this lokwaits or to find out more on these lokwaits.

    Is there any sql that can give more details about this lokwait.

    Thanks
    Ravindra

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Lockwaits is equal to the time ids has to wait to acquire a lock. Normally this is caused by table or page level locking. You could switch to row level locking...
    onstat -k will give you an overview of the current locking status.
    rws

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    You are probably using page-level locking - which is the default. A couple of questions are - how big are the rows you are looking at (calculate how many rows are on each page) and how ofter are you running onstat -p ? Depending on the number of rows you may want to incorporate row-level locking - but that means you will have to increase the number of locks. What about deadlocks - how many are showing ? Also, how many lokwaits are showing between time intervals - versus how many transactions for your instance ? You can reset the counters by using onstat -z. If possible, it may be helpful for you to post the onstat -p and onstat -k outputs.

    To create a table with row level locking:

    CREATE TABLE table_name
    {
    declarations ...
    )
    LOCK MODE ROW

    or for an existing table use:

    ALTER TABLE table_name LOCK MODE (ROW)

Posting Permissions

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