RE: Deadlocks and ONSTAT deadlock trace files
select first 10 * from sysmaster:sysptprof
order by deadlks desc
------------------------------------------
Alexey Sonkin
> -----Original Message-----
> From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]
> On Behalf Of Pero
> Sent: Friday, December 24, 2004 3:31 AM
> To: informix-list@iiug.org
> Subject: Re: Deadlocks and ONSTAT deadlock trace files
>
> only in application's log
>
> On 26 Nov 2004 08:25:22 -0800, serge.vedrine@domtar.com (Vedster)
> wrote:
>
> >Hi.
> >
> >I am a DBA who is new to Informix technology. My application
produced
> >5 deadlock situations yesterday. In the /tmp directory I have 5
> >ONSTAT_DEADLOCK_* files. How can I find the table which is in
> >deadlock situation and the related SQL commands ?
> >
> >Thank you for your help.
>
sending to informix-list