#DateWhereItemComment
2727 Jul 2015 @ 10:53 PDTcarrie's blogGlobal Weights in SLES 11 Priority SchedulerThanks Carrie !!  
2622 Jul 2015 @ 07:10 PDTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionThanks 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...
2520 Jul 2015 @ 10:05 PDTcarrie's blogGlobal Weights in SLES 11 Priority SchedulerHi Carrie, Typo Mistake:   please consider "MEDIUM" AL in place of "HIGH" AL in Point 1.    
2420 Jul 2015 @ 09:49 PDTcarrie's blogGlobal Weights in SLES 11 Priority SchedulerHi 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...
2315 Jul 2015 @ 08:17 PDTcarrie's blogNew, Simplified Approach to Parsing Workload SelectionHi 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...
2207 Jun 2015 @ 03:25 PDTcarrie's blogEasing Into Using the New AutoStats FeatureThanks a lot Carrie :)
2107 Jun 2015 @ 03:24 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadHi 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...
2004 Jun 2015 @ 10:42 PDTcarrie's blogExpediting Express RequestsHi 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->...
1927 May 2015 @ 10:23 PDTcarrie's blogEasing Into Using the New AutoStats FeatureHi 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...
1824 May 2015 @ 11:54 PDTcarrie's blogEasing Into Using the New AutoStats FeatureThnks 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...
1714 May 2015 @ 09:48 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi 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...
1620 Apr 2015 @ 08:41 PDTcarrie's blogEasing Into Using the New AutoStats FeatureHi 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?  
1516 Apr 2015 @ 07:02 PDTcarrie's blogEasing Into Using the New AutoStats Featurethanks Carrie
1413 Apr 2015 @ 08:38 PDTcarrie's blogEasing Into Using the New AutoStats FeatureThanks 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...
1329 Mar 2015 @ 11:18 PDTcarrie's blogEasing Into Using the New AutoStats FeatureHi 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...
1220 Mar 2015 @ 08:26 PDTcarrie's blogStatistics Threshold Functionality 101Thanks Carrie :)
1117 Mar 2015 @ 09:06 PDTcarrie's blogStatistics Threshold Functionality 101Hi 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...
1015 Mar 2015 @ 09:28 PDTcarrie's blogEasing Into Using the New AutoStats FeatureHI 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 ...
909 Nov 2014 @ 08:40 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Thanks Carrie.
818 Oct 2014 @ 02:15 PDTcarrie's blogUtility 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...
715 Oct 2014 @ 03:12 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Thanks Carrie :)
614 Oct 2014 @ 08:10 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi Carrie, I am using TD 14.10.  During stats colletion on DBC tables i got warning  :   COLLECT STATISTICS DBC.Indexes COLUMN (TableId, IndexNumber, DatabaseId);   ...
511 Oct 2014 @ 04:20 PDTViewpointTeradata 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...
408 Oct 2014 @ 09:31 PDTcarrie's blogEasing Into Using the New AutoStats FeatureThanks a lot Carrie :)
306 Oct 2014 @ 10:41 PDTcarrie's blogEasing 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...

Pages