Skip to Content
0
Former Member
Apr 10, 2009 at 01:45 AM

check MaxDB active sessions/connections

824 Views

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