Skip to Content
avatar image
Former Member

MaxDB: Monitoring running queries on 7.9

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 19, 2017 at 12:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded