Today you cannot exclude description from Alert e-mail. The feature to exclude description from Alert e-mail is on our roadmap. (VP-25801)
I would suggest you look at orange book for recommendations and pros and cons of enabling certain logging. It very well describes the best practice of Auto Stats.
Orange Book - Automated Statistics Management, 541-0009628
Re: Will Auto Stats identify Multi-Column stats as unused stats..?
The answer is yes....
I am using a stats manager portlet for automation and tried automating the job for one of my schema. Initially when i created a collect job and Scheduled it to run everyday it ran fine. But for lst 3-4 days it was failing with the strange error ,
Unable to synchronize SystemId: 10 | id: 9 with Teradata on 'CollectJob:11'!
Today when i was just debugging for this error, it just clicked in my mind that i had dropped some backup table from this schema and those where included in the stats jobs which did not help the stats job to execute properly. I went ahead and edited the job and removed the tables which i dropped after which i ran the job and it was succesfully(Waiting for the next scheduled run).
Just wanted to know that is there any mechanism to skip these kind of senario in the jobs and let the job run and complete with a warning message that the table which was dropped was not found or something similar?
Any help in this matter is highly appreciated !!!
Thanks & Best Regards,
I am using stats manager for autostats. I try with three databases scope for this at first time.When i ran the analyze job i got the error :
Analyze job getting data from PDCRDATA. i try to run it but everytime i am getting this error.
can anybody help on this.
Thanks - Sandeep.
We're trying to disable the thresholds for a number of objects.
Is there a way to script this?
Vpt seems to only allow 1 object at a time.
Enjoyed your article!
Can we have Teradata Managed Servers running on OS SLES 11 and database nodes running on OS SLES 10? Is there a compatibility matrix available?
Viewpoint TMS doesn't support SLES 11 yet. You can work with your CSR to get compatibility matrix.