Informix Locking Questions ???
Posted in 1995
I have a few questions regarding Informix locking (I'm
not an Informix newbie and I'm kind of ashamed that I
have to ask these questions - I've been to the classes,
but this wasn't covered). We're running 6.00 on HP/UX
(duh).
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).
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).
tia,
Bill
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
/*** Hewlett-Packard Company
/ ***\\ CTS - Colorado Springs
/ \\ / 1900 Garden of the gods
/* / \\ /**\\ Colorado Springs, CO 80907
/***\\ / \\/ \\ Mailstop: C103G
/ \\ \\
/ Bill Border \\ \\ EMail: border@cs.itc.hp.com
/ SAP/Database Engineering (TN/719)590-3402 Fax: 590-3596