I'm using IMA to return various session information to generally keep an
eye on how well the system is running.

I was wondering if any one has used it to dump out info when a deadlock
is detected and what syntax you used e.g. select * from
ima_deadlocked_sessions

Also, I would like to capture where locking has Escalated to table level
locks e.g. select * from ima_locklists where locktype = "Table"

Any suggestions or pointers would be gratefully appreciated.

Thanks

Gareth

Cymraeg:-
Mae'r neges hon yn gyfrinachol nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu
ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio
at wefan Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk

English:-
This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information Act 2000, Bro Morgannwg NHS Trust may be required to make public the
content of any emails or correspondence received. For further information on Freedom of Information, please refer to the Bro Morgannwg NHS
Trust website at www.bromor-tr.wales.nhs.uk.

On Jul 4, 6:50 pm, "Gareth Williams" <Gareth.Willi...@bromor-
tr.wales.nhs.uk> wrote:
> I'm using IMA to return various session information to generally keep an
> eye on how well the system is running.
>
> I was wondering if any one has used it to dump out info when a deadlock
> is detected and what syntax you used e.g. select * from
> ima_deadlocked_sessions
>
> Also, I would like to capture where locking has Escalated to table level
> locks e.g. select * from ima_locklists where locktype = "Table"
>
> Any suggestions or pointers would be gratefully appreciated.
>
> Thanks
>
> Gareth
>
> Cymraeg:-
> Mae'r neges hon yn gyfrinachol nad chi yw'r derbynnydd y bwriedid y negesar ei gyfer, byddwch mor garedig â rhoi gwybod
> i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadaua wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
> eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohonina chorff cysylltiedig.
>
> Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu
> ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio
> at wefan Ymddiriedolaeth GIG Bro Morgannwg arwww.bromor-tr.wales.nhs.uk
>
> English:-
> This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
> Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
> constituent part or connected body.
>
> Please be aware that, under the terms of the Freedom of Information Act 2000, Bro Morgannwg NHS Trust may be required to make public the
> content of any emails or correspondence received. For further informationon Freedom of Information, please refer to the Bro Morgannwg NHS
> Trust website atwww.bromor-tr.wales.nhs.uk.

Might be easier to just use errlog.log for this. Have a look in CBF
for what you want to turn on logging for.