Studio monitoring options

[Former Member]

Hi

Regarding HANA Studio monitoring, i have few doubts.

1)what parameters are used for Session time out?
does the Session parameters under Indexserver.ini controls above?

2)Any parameter exists in config file to control the multiple login permission for DB user?
(suppose if multiple time same users login,should allow warning etc?)

Regards
Magalingam

[Former Member]

Hello,

I am not sure if this is a Studio question but more an Engine question.

idle_connection_timeout seems to fit the most to your need.
But there is no parameter to force a logoff after some time.
There is not way to limit the number of connections for one user.

Regards, Wolfgang

[Former Member]

Hello Wolfgang

Thanks for reply.

So there is not  Session control at Studio end?

Also can you tell me how to test this parameter idle_connection_timeout?

I changed to value 2 and made it idle with studio for few minitues, but no message says about session timeout.

Any document explains about this?

Regards

[Former Member]

Hello,

I am not sure what you mean by "Session control at Studio end".

As Studio is an Admin Tool it uses a JDBC property to reconnect on session time out "jdbc:sap://server:port?reconnect=true".

Also idle_connection_timeout does only work when there is no result set open.

Maybe Studio is the wrong tool to test session time outs. I recommed that you write a small test programm where you can check for any "session time out" exceptions from JDBC/Engine.

Regards, Wolfgang

[Former Member]

Hi Wolfgang

Thanks for reply.

ok i understand Studio does not have session time out features.

you mentioned, Idle_connection_timeout does only work when there is no resultset open?

what does it mean can you please elaborate a bit for testing.

I did not get clear idea about how sessions management is done in HANA? and can be tested.

you said to create small test program? are you talking about java program to check for exception in log file?

Sorry if i am not catching your point...can you pls clarify a bit.

Appreciate your response in advance.

Regards

[Former Member]

Hi,

just a quick update.

There is now the option „Auto-Reconnect“ which is triggering the usage of connect option “reconnect=false/true“.

The option is now available in the system property page.

Regards, Wolfgang