Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Bill Border — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.