Skip to Content
0
Former Member
Jan 11, 2011 at 02:01 PM

MAXDB 7.8.01.019: Problem with the command monitor

141 Views

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