check MaxDB active sessions/connections

[Former Member]

Hello,

when stop sap instance, I got the following information:

Stopping the SAP instance DVEBMGS20 
----------------------------------
 Shutdown-Log is written to /home/chpadm/stopsap_csrt35_20_DVEBMGS20.log
 Instance on host csrt35 stopped
 Waiting for cleanup of resources.............................................................................
 Running /usr/sap/CHP/SYS/exe/run/stopdb 
Trying to stop database ...
Log file: /home/chpadm/stopdb.log
There are still active users connected to the database.
On order to shutdown the database with stopdb you first have to stop all
database applications. This includes MCOD instances and database utilities.

Checking ADA db Database
------------------------------
 ABAP Database is running

But this is not MCOD instance and no DB utilities is still used (at least I don't know). It is an ECC6SR3 on MaxDB 7.7 system.

Could you help, how to find the active session/connection? It there something like v$session (like oracle)? Any help is appreciated.

Rongfeng

[Former Member · Accepted solution]

Hello Rongfeng,

please check if SAP note 1148232 helps you.

Regards

Ivan

[Former Member]

Hi Ivan,

thank you very much.