Archives of the TeradataForum
Message Posted: Thu, 12 Jul 2012 @ 12:09:09 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|