Skip to Content

MaxDB: Monitoring running queries on 7.9

Oct 18, 2017 at 09:15 AM


avatar image
Former Member


On MaxDB 7.7, we previously used the query: select * from commandstatistics where currentexecutecount > 0 to list the current running statements on our databases.

On our freshly installed MaxDB 7.9 (running on Windows 2012 R2) this query always returns "No results". The table itself is filled but the value in currentexecutecount never changes and seems to always be stucked to 0.

Question: is there a way to make this query work on 7.9 (a specific setting maybe?) or is there another way of listing the current running queries on the database?

Thanks in advance

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

1 Answer

James Zhang
Oct 19, 2017 at 12:26 AM


I would say this topic needs to involve developer who knows the background of commandstatistics dictionary, please raise a ticket to SAP support.

Best regards,

10 |10000 characters needed characters left characters exceeded