Archives of the TeradataForum

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

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

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>>