Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Jan 2012 @ 15:28:01 GMT


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


Subj:   Re: Generate collect statistics statement
 
From:   Dieter Noeth

JAMES PARK wrote:

  I ran as DBC.  


  The error message was "COLLECT Failed. 5578: Statistics cannot be collected on table DBC.'DBQLEXPLAINTBL'  


  And the same errors happened for other tables DBC.DBQLOBJTBL, DBQLOGTBL, DBQLSQLTBL, RESUSAGEIPMA and others.  


Hi James,

this works on TD13 without error, are you running an old release?

Btw, i wouldn't collect stats on DBQL and ResUsage tables, they grow fast during a day and are usually deleted in a nightly batch, you'd need to recollect several times a day.


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: 27 Dec 2016