Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Oct 2006 @ 15:54:00 GMT


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


Subj:   Re: Way to Copy Statistics.
 
From:   Bagare, Vinay

I have a DOS program which can generate Collect Stats DDL's. Like w/ any other program there is initial set up that you will need to have this working.

These are the changes that I could think off.

Unzip the file into a local drive.

Rename the files to Bat files (I had to rename that as outlook might quarantine these)

1.

     HOME dir
     Ren GenStats.txt GenStats.bat (Main program)

     Scripts Directory
     ren Chk_Stat.txt Chk_Stat.bat
     ren Chk_DB.txt Chk_DB.bat
     ren Chk_Tbl.txt Chk_Tbl.bat
     ren DB.txt DB.bat
     ren Out.txt Out.bat
     ren Tbl.txt Tbl.bat

2. Change all occurrences of this HOME_GenStat=C:\Vindoc\UTILITY\GenStats to a directory local to your machine. HOME_GenStat becomes your working home directory.

3. Maintain HOME_GenStat/logon/logon.txt - this is the file which has logon credentials

4. HOME_GenStat/file will have all the files which contain collect stats.

5. HOME_GenStat/scripts have some BAT files (you will need to rename as per point 1) and some generated by programs.

6. HOME_GenStat/GenStats.Bat expects 2 parameters viz. DatabaseName and TableName.

HELP STATS info is exported to a file. This file is imported into tables that are created by the scripts automatically and dropped at the end.

The user will need create tables as the metadata tables will be created in the database specified.

It's pretty straight forward. It can easily be converted to Unix Flavor.

Needs some work.


Thanks,

Vinay Bagare
W e l l P o i n t Inc.
Advisor - IM Database Administration


Admin Comment:

The ZIP File was sent as an attachment and has been placed on the TeradataForum website:

www.teradataforum.com/attach.htm



     
  <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