Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Dec 2002 @ 07:54:41 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: New Years Wish List
From:   Howard Bradley

Hi Dave , response to your reply below

1) v2r5.0

So I believe - if its ok I will swap this one out for Frank's 1) Users who are interested enough in their query performance to read the explains! - Fantastic idea.

2) why not use pmon?

I am a novice with PMON but I don't seem to be able to get the current total cpu or i/o for a query - the "total AMP cpu" option appears to be for the session and most of our users log on at 9 and log off again at 5 (on the Friday more often than not !) and the "delta AMP cpu" appears to be since the last time I refreshed rather than start of active query. I just thought it would be nice to run sel * from dbc.activequeries where probably wrong='y';

Dennis , thank for your advice

  This is called TDQM and is available in v2r4.1 and beyond.  

I had read about this but neither myself nor our DBA's have had a chance to play with it yet. My original wish was for he Teradata system itself to be intelligent and intuitive enough to learn about the persistent problem users in the same way we all do. I would envisage the implementation of such a feature to also include DBS control settings for maximum strength of sarcasm / abuse in error messages for example 0 mildly polite up to 10 for extremely offensive, I would love to see the users reaction to "Error 4926 - For god sake I don't believe you have done it again, the joins all wrong , its gonna skew to 1 amp and you are going to shaft every competent user on the system. Please find an alternative career". It is only a wish list after all :-)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020