Locking problem ... again

Posted in 2001

Topics: Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

Brett Geer — Tue, 06 Feb 2001 07:43:31 +0200 — source: Informix-list mailing list archive (1991-1998)

Morning all, our box has say 29K records in a table I want to update, case in point: select count (*) from cocinstn where ins_pub_company = 9 returns 29651 now, update cocinstn set ins_pub_company = 26 where ins_pub_company = 9 grabs 60K locks before I kill it... Even with the table locked exclusive it grabbed 7K IDS 7.31.UC4 on AIX 4.3.3ML4 Any ideas? brett -- ----------------------------------------------------------------- Brett's 12th law of UNIX administration... People tend not to react well when they lose control over their computers. Typically, it brings out the worst in them ... ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------

↪ replying to Brett Geer

Andrew Hamm — Tue, 6 Feb 2001 17:57:40 +1100 — source: Informix-list mailing list archive (1991-1998)

Brett Geer wrote in message <95o4p6$d5q$1@news.xmission.com>... > >update cocinstn set ins_pub_company = 26 where ins_pub_company = 9> >grabs 60K locks before I kill it... Even with the table locked exclusive >it grabbed 7K > Errr Emmmm - is there referential integrity out there causing the extra locks?