| Subject | Re: Lock conflict on no wait transaction - finding the user. |
|---|---|
| Author | Alexandre Vinhaes - DBA - TIC |
| Post date | 2016-12-08T17:31:19Z |
Hi all,
how to query transactions/users in "waiting for lock" ? It would be usefull in time of problems. In other words, I would like to have the related query to execute via isql and identify users waiting another transactions blocking row or range of rows.
Thanks.
Atenciosamente.
Alexandre Vinhaes
+55 21 2196-5206
Administrador de Banco de Dados - Setor Informática
+55 21 2196-5206
Administrador de Banco de Dados - Setor Informática
2016-12-06 13:20 GMT-02:00 Alexandre Vinhaes - DBA - TIC <ticdbab01@...>:
Hi all,how to query transactions/users in "waiting for lock" ? It would be usefull in time of problems. In other words, I would like to have the related query to execute via isql and identify users waiting another transactions blocking row or range of rows.Thanks.Alexandre.