Re: Deadlock - Problem.

Re: Deadlock - Problem.

This is a discussion on Re: Deadlock - Problem. within the Informix forums, part of the Database Server Software category; --> Hello, with this request, you will know which table is involved: Select tabname, sum (deadlks) deadlocks from sysptprof Where ...

		Unix Technical Forum > Database Server Software > Informix
Re: Deadlock - Problem.

#1 (permalink)

04-19-2008, 09:14 PM

Ahmed HADJOUTI

Posts: n/a

Re: Deadlock - Problem.

Hello,
with this request, you will know which table is involved:
Select tabname, sum (deadlks) deadlocks from sysptprof
Where tabname not like 'sys%'
Group by 1
Order by tabname;

zusers a écrit :

> Hello.
> I have any problem witch deadlock.
> Number of deadlocks is sometims fast go up.
> What can I do ???
> Can I recognize what is the name database which did make this deadlocks ?
>
> Thanks for Your help.
>
> E.N

sending to informix-list

« changing user passwords? | Read only connection »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 10:29 AM.