InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 09:52:14 GMT20http://www.teradata.com/teradataforum/Topic15978-9-1.aspxIs the PMon values less or greater than DBQL?Are you shure you presses the refresh button in PMon the right time?Could you post some numbers?If this repeats for certain types of queries you should open an incident.DieterTue, 14 Jul 2009 08:16:19 GMTdnoethhttp://www.teradata.com/teradataforum/Topic15978-9-1.aspxcan anyone help me on this please?Tue, 14 Jul 2009 03:00:45 GMTBharathhttp://www.teradata.com/teradataforum/Topic15978-9-1.aspxI look for the maximum of current spool with pmon during query execution and compare it with dbqllogtbl spool usage column value after query execution.Mon, 06 Jul 2009 01:41:17 GMTBharathhttp://www.teradata.com/teradataforum/Topic15978-9-1.aspxAnd comparing it to what?DieterThu, 02 Jul 2009 13:52:57 GMTdnoethhttp://www.teradata.com/teradataforum/Topic15978-9-1.aspxMeasuring by the spoolusage column of the dbqlogtblThu, 02 Jul 2009 10:22:33 GMTBharathhttp://www.teradata.com/teradataforum/Topic15978-9-1.aspxHow are you measuring?Wed, 01 Jul 2009 08:07:22 GMTRandom_thoughthttp://www.teradata.com/teradataforum/Topic15978-9-1.aspxTHE SPOOLUSAGE FOUND IN DBQLOGTBL FOR A QUERY IS NOT CORRECT. IT DIFFERS A LOT FROM THE ACTUAL SPOOL USAGEOF A QUERY.Let me know any other way to extract accurate spool information after query execution.Wed, 01 Jul 2009 07:31:16 GMTBharath