how to analyze deadlock situation?

[giselle_lin]

Hi Guru,

Can you provide some information of analyze SAP level deadlock situation?

I know in DB01 we can check DB level deadlock, we can see who is holding lock and who is waiting for it.

But in SM12, there is only lock holder, how can I know who is waiting for this lock?

Thanks.

[former_member227578 · Accepted solution]

can go to SM66, find the running process which is reading/accessing the table shown in DB01.

Cheers

Chris

[giselle_lin · Accepted solution]

Hi Chris,

Thanks for the reply.

but how to analyze SAP level deadlock without DB level deadlock?

I mean in SM12 there are lock holders that maybe waiting for each other. But in SM12 we can't see the waiting list...