Re: Locking problem ... again
At 07:43 01/02/06 +0200, Brett Geer wrote:
Hi Brett.
When the meaning of the question is different, I'm sorry.
Please try the following.
lock table cocinstn exclusive;
update cocinstn set ins_pub_company = 26 where ins_pub_company = 9;
and run the command "onstat -k"
iif921uc1@ifmx28 onstat -k
Informix Dynamic Server 2000 Version 9.21.UC1 -- On-Line -- Up 15 days
00:28:12 -- 36864 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
a01f8e0 0 a40d7d8 a01fa84 HDR+X 1001a8 0 0
^^^^^ <- Exclusive locked
a01fa84 0 a40d7d8 0 HDR+S 100002 207 0
2 active, 2000 total, 2048 hash buckets, 0 lock table overflows
Regards.
>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
>-----------------------------------------------------------------
--
$B0KF#Ci%F%/%N%5%$%(%s%93t<02q<R(B
INFORMIX$B1D6H?d?JIt(B $B2.86!!6P(B
Tsutomu.Ogiwara@ctc-g.co.jp/ifmx-tech@ctc-g.co.jp
102-0074 $BEl5~ET@iBeED6h6eCJFn(B2-3-14
TEL.03-5212-4880 FAX.03-5212-4889