Transaction Status and Connection Status in Hana Studio

[former_member590428]

Dear Experts,

We're running a Hana 2.0 DB. I noticed in the Hana studio (Performance -> Sessions) that there are numerous sessions that are 'Active' in the 'Transaction Status' Column but the the 'Connection Status' is 'Idle'. The corresponding dialog WP, in my case (which i tracked back in SM66 using the client pid column in the session view of the studio) is in 'Waiting' status. The application source column in the studio shows that Its executing the /SDF/SAPLMON program (SDFMON)

I am not sure why the 'Transaction Status' shows as 'Active' while the connection status is 'Idle'. Let me refer to the Administration guide authored by Lars Breddemann:

===============

A client application (AS ABAP in this case) will open a session and reuse it as long as the application is active"

A transaction occurs within a session and there could be multiple transactions within a session.

================

Does this mean that a session can be idle while the transaction operating within the session is 'Active'? Since the ABAP workprocess that initiated the SDFMON is in 'Wating' status now, what could be happening with this particular transaction?

Thanks for your time!

Regards,

JK

[lbreddemann]

Yes, a connection can be in idle state while a transaction is active.

That's the same when you are having a phone call but nobody is currently saying anything. The conversation (transaction) is still ongoing (active) but the telephone line (connection) currently doesn't transport anything.

Maybe both sides are currently thinking about what to say next, maybe they are busy doing other things altogether, who knows.

But until they either say more about the current topic of conversation (transaction), finish it off (commit/rollback) and move on to another topic (new transaction) or hang up the phone (connection disconnect & implicit rollback) the state of the transaction will be 'active' and that of the connection will be 'idle'.