15 | 08 Oct 2013 @ 04:45 PDT | carrie's blog | TASM State Changes are Streamlined in Teradata 14.0 | Hello 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... |
14 | 20 Jun 2013 @ 03:38 PDT | carrie's blog | TASM State Changes are Streamlined in Teradata 14.0 | Hello
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. |
13 | 18 Jun 2013 @ 05:14 PDT | carrie's blog | Recommended Dictionary Statistics to Collect in Teradata 14.0 | Hello 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... |
12 | 31 May 2013 @ 11:02 PDT | carrie's blog | Intrepreting DBQL DelayTime in Teradata 13.10 | Hello 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... |
11 | 25 May 2013 @ 05:59 PDT | Tools | Advanced 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... |
10 | 08 May 2013 @ 08:48 PDT | stever's blog | Understanding the System Health Equation | Thanks Steve for the response
Having said that.if a Component is down what will be the Systems status in the system health portlet?
|
9 | 08 May 2013 @ 12:49 PDT | stever's blog | Understanding the System Health Equation | Also, 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 ... |
8 | 08 May 2013 @ 12:46 PDT | stever's blog | Understanding the System Health Equation | Hello 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... |
7 | 08 May 2013 @ 12:27 PDT | Tools | Advanced 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-... |
6 | 01 May 2013 @ 04:36 PDT | Tools | Advanced 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 ... |
5 | 25 Apr 2013 @ 01:17 PDT | Database | Right Sizing Data for Space Savings and Performance | Very 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... |
4 | 25 Apr 2013 @ 12:21 PDT | Database | Statistics Collection Recommendations for Teradata 12 | Hello 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... |
3 | 13 Apr 2013 @ 01:20 PDT | carrie's blog | Flow Control and Spawned Work | Hello 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.”"... |
2 | 12 Apr 2013 @ 12:03 PDT | Database | Removing Multi-Column Statistics – A Process for Identification of Redundant Statistics | Another 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... |
1 | 12 Apr 2013 @ 11:33 PDT | Database | Removing Multi-Column Statistics – A Process for Identification of Redundant Statistics | Hello 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... |