$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

How to find and kill connections to Hana database ?

Jan 27, 2017 at 02:05 AM

1.6k

avatar image

Hi All,

Currently I have run something like below to find connected sessions and kill using studio:

1. find connections a schema

SELECT * FROM"SYS"."M_CONNECTIONS"

WHERE "CURRENT_SCHEMA_NAME" = 'MYSCHEMA'

and "CONNECTION_STATUS" = 'IDLE'

2. kill

ALTER SYSTEM DISCONNECT SESSION'300091

This is too time consuming and by the time I kill one session another one pops up. In the SQL server you have Activity Monitor where you can filter by database and right click to kill a session. Is there something similar in Hana?

I'm an application consultant and I don't have the time to remember commands or write scripts so wondering if there is anything easier in the Hana world.

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Jan 27, 2017 at 02:50 AM
0

You can cancel connections in SAP HANA Studio's Admin editor.

Just right-click on the connection you like to cancel.

Concerning "I'm an application consultant and I don't have the time to remember commands..." I'd say you probably shouldn't be administering the database in that case anyhow. If your job doesn't entail this, then you shouldn't be fiddling with it either, as you might cause quite some damage by either not knowing how things work or misunderstanding how they work.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Lars...That worked

regarding your comment about not fiddling with the database...agree ....but GUI helps people who are multitasking

0