Re: Locking problem ... again
nopes
brett
Andrew Hamm wrote:
>
> 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?
--
-----------------------------------------------------------------
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
-----------------------------------------------------------------
How about using onstat -k, or a query against the sysmaster to find out
what is actually locked, and work from there?
Hope this helps,
Will
In article <95oir7$hmu$1@news.xmission.com>,
Brett Geer <brett@brabys.co.za> wrote:
>
> nopes
>
> brett
>
> Andrew Hamm wrote:
> >
> > 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?
>
> --
>
> -----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
Sent via Deja.com
http://www.deja.com/