RE: Are Deadlocks function of extents number ?
Fred,
Deadlocks usually have two major reasons:
1. Poorly written/designed application
2. Tables with high concurrent insert/update access
are created with 'page' level locking.
My advise is to verify the locking mode
for those table, that cause deadlocks.
To identify these tables, run
select * from sysmaster:sysptprof order by deadlks desc
I can't imagine how deadlocks can relate to the number
of extents in the table.
------------------------------------------
Alexey Sonkin
> -----Original Message-----
> From: oxow@yahoo.com [mailto:oxow@yahoo.com]
> Subject: Are Deadlocks function of extents number ?
>
> Hi,
>
> I have just a little question :
>
> I am wondering if the Deadlocks is linked to the number of extents ?
>
> I am asking this question because some developers of a third
> application told me that the deadlock we have on the database and some
> slowness problems were due to our number of extent on some specific
> tables. Tables that they had designed.
>
> Btw, we have a 7.31.FC6 on Hp-ux11.
>
> So, could you help me to know if it is effectivly correct.
> Thanks in advance.
>
> Best Regards
> Fred
sending to informix-list