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


  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.


  <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: 23 Jun 2019