Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Jul 2012 @ 12:09:09 GMT


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


Subj:   Re: Generate collect statistics statement
 
From:   bhanu.chintalapalli

Hi James Park,

I need to generate collect stats for 15+ databases, as in your below mail, I have seen that you have implemented procedure. Can you please share with me, It will help me a lot to work on collect stats for my retinue work.

As I have seen JK procedure, in that I find that ADWSTATS_TABLE, but I didn't find INSERT statement for this.

     CREATE SET TABLE dbadmin.ADWStats_Table,
             NO FALLBACK PROTECTION,
             NO BEFORE JOURNAL,
             NO AFTER JOURNAL,
             CHECKSUM = DEFAULT
             (
               DatabaseName CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL FORMAT 'X(30)',
               TableName CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL FORMAT 'X(30)',
               ADWStatsPerc BYTEINT DEFAULT 10 FORMAT '-(3)9'
             )
             UNIQUE PRIMARY INDEX UPI_ADWStats_Table ( DatabaseName, TableName );

If you have bundle of code, can you share it please?

Appreciate if you can help me it this.


-Regards,

Bhanu Prasad



     
  <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