MaxDB: Monitoring running queries on 7.9

[Former Member]

Hi,

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

[JamesZ]

Hi,

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,
James