Re: Informix Locking Questions ???

Bill Border (border@col.hp.com) wrote: : 1. Does Informix do deadlock detection - we've observed : circumstances that appear to be deadlocks between : threads and they just sit there (no reads/writes/ : locks). Yes, Informix does deadlock detection. It traces all through the lock lists to make sure that you aren't waiting for someone who's waiting for someone who's ... (etc etc) ... who's waiting for you. : 2. How (if at all) does Informix timeout waiting locks - : we've also observed circumstances where a thread that : is waiting seems to wait forever. When you try to : see what type of resource a thread is waiting on, : the address seen in onstat -u does not appear in : onstat -s or onstat -k (the book says that any : address found in onstat -u should be in onstat -s : or onstat -k). If the book says that, it's wrong. There are other conditions in 6.00+ that you can be waiting on. Try onstat -g con, or some of the other -g options. By the way, if this is your SAP system, and I suspect it is (Hi, Bill!), try to upgrade to the latest version. I have vague recollections of some problem that got fixed (I think it was in R/3 but that might just be wishful thinking ;-) June ---- June Tong Informix Asia/Pacific ---- ---- On-Loan Engineer Singapore ---- ---- Location-du-jour: Auckland, NZ (home of the America's Cup) ---- ---- junet@informix.com (65) 298-1716 ----