27 | 27 Jul 2015 @ 10:53 PDT | carrie's blog | Global Weights in SLES 11 Priority Scheduler | Thanks Carrie !!
|
26 | 22 Jul 2015 @ 07:10 PDT | carrie's blog | New, Simplified Approach to Parsing Workload Selection | Thanks Carrire.
I think i should raise this concer in Viewpoint Area. Well My question is as:
Workload Information is blank for fastload session in Viewpoint. When we ch... |
25 | 20 Jul 2015 @ 10:05 PDT | carrie's blog | Global Weights in SLES 11 Priority Scheduler | Hi Carrie,
Typo Mistake: please consider "MEDIUM" AL in place of "HIGH" AL in Point 1.
|
24 | 20 Jul 2015 @ 09:49 PDT | carrie's blog | Global Weights in SLES 11 Priority Scheduler | Hi Carrie,
Please help me to understand the below points.
1. We have Appliance system with SLES 11 & 14.10.05.03 DB. Can we consider "Lowest SLG tire Remaining Globa... |
23 | 15 Jul 2015 @ 08:17 PDT | carrie's blog | New, Simplified Approach to Parsing Workload Selection | Hi Carrire,
Thanks for this Blog.
My DB version is 14.10.05.03 and we have TASM on this system. We created one workload for Batch in SLG layer. When i check the fastload session i... |
22 | 07 Jun 2015 @ 03:25 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Thanks a lot Carrie :)
|
21 | 07 Jun 2015 @ 03:24 PDT | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Hi Carrie,
Thanks for this blog. I have one query:
As per your blog " Expediting Express Request" if we enable EnableExpediteExp parameter and reserve some AWTs then it w... |
20 | 04 Jun 2015 @ 10:42 PDT | carrie's blog | Expediting Express Requests | Hi Carrie,
I have a query regarding the AWTs category WorkType08/09/10:
Are AWTs assiggn to WorkType08,WorkType09,WorkType10 when we reserve AWTs in viewpoint in Ruleset (General->... |
19 | 27 May 2015 @ 10:23 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Hi Carrie,
I checked the stats job and found some information
In Analyze Job under Missing Tab, there is one column "Recommendation" which has two values Yes/No only.
I approve... |
18 | 24 May 2015 @ 11:54 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Thnks Carrie :)
When Analyze job runs. it give recommendations in 6 tabs (Missing,Usage,stale,Deactive,Reactive,Automate).
when i got recommendation from Analyze job i approved all the re... |
17 | 14 May 2015 @ 09:48 PDT | carrie's blog | New opportunities for statistics collection in Teradata 14.0 | Hi Carrie,
I have some doubt. please help:
1. If a table is being accessed only by PI then do we still need to collect stats on table.
2. if table is well distributted(zero skewness) and th... |
16 | 20 Apr 2015 @ 08:41 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Hi Carrie,
I have doubt regarding BLC and MVC tables.What will be the stats manager behavior (CPU,IO etc) for MVC and BLC tables?
will the stats proccess will be slow?
|
15 | 16 Apr 2015 @ 07:02 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | thanks Carrie
|
14 | 13 Apr 2015 @ 08:38 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Thanks Carrie :)
we are facing one issue due to OBJECT logging( OUC). One fastload is in abort state more than 18 hours. We found on knowlege article KAP316902A. The same has been raised t... |
13 | 29 Mar 2015 @ 11:18 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Hi Carrie,
what is the difference in between
when we automate stats for a database by clicking automate option in statistics tab and when we select the database through analyse job... |
12 | 20 Mar 2015 @ 08:26 PDT | carrie's blog | Statistics Threshold Functionality 101 | Thanks Carrie :)
|
11 | 17 Mar 2015 @ 09:06 PDT | carrie's blog | Statistics Threshold Functionality 101 | Hi Carrie,
There are 980 Database exists in my system. If i enable usecount logging for each database then is there any impact ?
DBQLRULES table will have 1000 rows. so Is it fine ?
Is i... |
10 | 15 Mar 2015 @ 09:28 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | HI Carrie,
We just ran the StatsManager. When we ran it, we found some the tables have "Skipped" state. Is that mean that stats collects skipped thses tables because tables do ... |
9 | 09 Nov 2014 @ 08:40 PST | carrie's blog | Utility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED) | Thanks Carrie.
|
8 | 18 Oct 2014 @ 02:15 PDT | carrie's blog | Utility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED) |
Hi Carrie,
There is limit for load utilities (fastload Mload etc) in Teradata system that is handling by MaxLoadTask parameter in DBS control. According to this we can increase th... |
7 | 15 Oct 2014 @ 03:12 PDT | carrie's blog | Recommended Dictionary Statistics to Collect in Teradata 14.0 | Thanks Carrie :)
|
6 | 14 Oct 2014 @ 08:10 PDT | carrie's blog | Recommended Dictionary Statistics to Collect in Teradata 14.0 | Hi Carrie,
I am using TD 14.10. During stats colletion on DBC tables i got warning :
COLLECT STATISTICS DBC.Indexes COLUMN (TableId, IndexNumber, DatabaseId);
... |
5 | 11 Oct 2014 @ 04:20 PDT | Viewpoint | Teradata Viewpoint 14.10 Release | Hi ,
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 :
Unable to synchronize SystemId: 2 | id: 4 with... |
4 | 08 Oct 2014 @ 09:31 PDT | carrie's blog | Easing Into Using the New AutoStats Feature | Thanks a lot Carrie :)
|
3 | 06 Oct 2014 @ 10:41 PDT | carrie's blog | Easing Into Using the New AutoStats Feature |
Hi Carrie,
I have one more doubt. It will be a great help if you provide some input.
I have enabled XMLPLAN and STATUSAGE logging for one account and enable database loggi... |