Hello MAXDB experts,
I am trying to perform an SQL analysis on a customer system with MAXDB 7.8.01.019. Unfortunately it doesn't work.
- The runtime for the SQL statements in the resource monitor is much too high (factor 1000000). It seems that this is a known problem (PTS 1195067).
- The command monitor dosn't display execution plans. Error message: "Fehler bei der Bestimmung des Ausführungsplans".
Furthermore the SQL statements are displaced from table sysmonitor after a few seconds. I assume this is related to the first problem (factor 1000000). I already tried to use higher threshold values (e.g. runtime >=500000 ms or 500000000 ms instead of 500 ms), but it didn't work.
Best regards
Thomas Fleer