Subject Re: Row Locking
Author Chooi-Ting
because i found sometime my client application (in C and using ODBC
API library) takes longer time to complete and sometime fast. I don't
know whether my query that send from my application is in deadlock or

--- In, Ann Harrison
<aharrison@i...> wrote:
> Chooi-Ting wrote:
> >how do we know that database deadlock has happenned ? by using
> >command gstat ? or gds_lock_print ?
> >
> When one process has been waiting for a lock for 10 seconds, the
> database walks the lock graph, looking for deadlocks. If it finds
> it sends a failure notification to one of the participants. Why
do you
> ask?
> Regards,
> Ann