#DateWhereItemComment
1508 Oct 2013 @ 04:45 PDTcarrie's blogTASM State Changes are Streamlined in Teradata 14.0Hello Carrie, If more than 1 events are active at the same time, the action is decided by severity of the action. How is the Severity decided ? I wish to know the same for Exceptions aris...
1420 Jun 2013 @ 03:38 PDTcarrie's blogTASM State Changes are Streamlined in Teradata 14.0Hello If a System has more than 1 Ruleset, then which Ruleset is Active ? Cause, State Change affect the Working Values of each Rule within a Ruleset.
1318 Jun 2013 @ 05:14 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hello Carrie The DBC tables are usually point in time tables. More often,these data are moved into corresponding PDCR tables after say, 07 days. Also,DBAs use the PDCR tables for Analysis of c...
1231 May 2013 @ 11:02 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Hello Carrie,   My Question is: If a Query is in Delay Queue, then it means it is waiting for the say, Queries Count be lower than the Defined Throttle Limit.  The DBA can Release such...
1125 May 2013 @ 05:59 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hello,   As requested, I executed the mentioned 02 SQLs and they didn't give any Result-Set.   FYI: I am using the Teradata Express 14 Edition via VMWare Player. Does it have some...
1008 May 2013 @ 08:48 PDTstever's blogUnderstanding the System Health EquationThanks Steve for the response Having said that.if a Component is down what will be the Systems status in the system health portlet?
908 May 2013 @ 12:49 PDTstever's blogUnderstanding the System Health EquationAlso, to the "Down" State...We have Canary Enabled...   Having said that, I have seen the System as "Down" for any AMP/PE/Node Down Scenario. Could you confirm this ...
808 May 2013 @ 12:46 PDTstever's blogUnderstanding the System Health EquationHello Steve, In Teradata Viewpoint System Health Portlet, on multiple occasions, I have encountered High CPU Skew or High I/O [More than 80 %] when the number of Active Sessions is Zero. How i...
708 May 2013 @ 12:27 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hello,   I checked the DBQLogTBL Table and found that I have entries from 23rd April onwards. So, Instead of using 1st April-30th April as DBQL Date Range, I used Date Range from 23rd April-...
601 May 2013 @ 04:36 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hello,   I am new to TWA. I am using the 13.10 Version of TWA. Once, I select the Step1[Log as DBQL & Provide the Date Range & Category "Account String"], I am getting the ...
525 Apr 2013 @ 01:17 PDTDatabaseRight Sizing Data for Space Savings and PerformanceVery Nice Approach... I must say this David, your Practical Approach helps in quicker & efficient understanding than other Theoretical Article.   Also, the Same Approach with Integer or...
425 Apr 2013 @ 12:21 PDTDatabaseStatistics Collection Recommendations for Teradata 12Hello Carrie,   My Questions are related to your "Dropping MC Stats" Article & David Roth's Similar Article.   (a) You mentioned that the Data Content's Length m...
313 Apr 2013 @ 01:20 PDTcarrie's blogFlow Control and Spawned WorkHello Carrie,   Few Questions.   (a) The 1st line says "When an AMP temporarily closes the door to new work, that AMP is in a state that we call “flow control.”"...
212 Apr 2013 @ 12:03 PDTDatabaseRemoving Multi-Column Statistics – A Process for Identification of Redundant StatisticsAnother Thing Also.....   Assuming that Stats(Col_1,Col_2,Col_3) exists and all these 03 Columns are not used in Joining or Aggregate Operations, then the Dropping MC Stats' approach wou...
112 Apr 2013 @ 11:33 PDTDatabaseRemoving Multi-Column Statistics – A Process for Identification of Redundant StatisticsHello David & Carrie, Thanks for the Article & Discussions. I would like to wind up the whole 16-Byte Limit thing by a few questions/doubts: (a) You mentioned that the Data Content's...