Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Jan 2010 @ 15:42:43 GMT


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


Subj:   Re: Step Name column of DBC.DBQLSTEPTBL
 
From:   Dieter Noeth

Rehman Ansari wrote:

  In DBC.DBQLSTEPTBL there is one column Stepname which contains values as Edt, FDS, JIN, MLK, MRD, RET, SplTAB Can anyone explain what that mean?  


Search the "Database Administration" manual for "step descriptions" to get a list.


  Also using DBC.DBQLSTEPTBL how to trace exact step of Query which is utilising more resource.  


In newer releases there's a lots of columns with info about CPU/IO/Spool-Usage etc. within that table.


Dieter



     
  <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: 15 Jun 2023