25 | 12 Feb 2015 @ 08:22 PST | carrie's blog | Statistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 | Very valuable article. Thanks Carrie.
In Teradata 14 onwards, we have this feature wherein the individual stats information of Col(A) & Col(B) can be used for Col(A,B) if the stats on ... |
24 | 12 Feb 2015 @ 07:32 PST | carrie's blog | Determining Precedence Among TASM Planned Environments | Hello Carrie,
Well-written Article. I have 01 question:
(a) For PE, the rightmost PE will take the highest precedence irrespective of whether the DBA wishes or not. For Health Condition, ... |
23 | 12 Feb 2015 @ 06:39 PST | carrie's blog | Expediting Express Requests |
Hello Carrie,
Wonderful Article. I have a few questions concerning Expediting Express Requests:
(a) You have mentioned the DBQLogTbl Column "ParserExpTime" den... |
22 | 21 Jan 2015 @ 03:49 PST | Tools | Conquering Big Data with Teradata Data Mover parallelism | Thanks Kevin for the article. It's a valuable article on the features which are usually neglected.
-Smarak
|
21 | 07 Jan 2015 @ 12:16 PST | Viewpoint | Teradata Data Lab and Viewpoint 14.0 releases |
Hello Gary,
When one create a DataLab Group, we only specify the "Allocated Space". This becomes the PERM Space for the Teradata User created for the newly created Lab G... |
20 | 26 Nov 2014 @ 01:04 PST | General | Working with Stored Procedures in Unity Director |
Thanks Paul for this article. This will rest a lot of perception about Unity handling of Stored Procedures along with encouraging the DBAs & Developers to use Exception Handling and the butt... |
19 | 20 Nov 2014 @ 05:06 PST | Viewpoint | Node Resources Portlet - Take 2 | Hello Steve,
The Alert "PeakSpoolSpace" available in "Database Space" Alert Type is defined as PeakSpool divided by MaxSpool in the Configuration Guide.
The Value i... |
18 | 19 Nov 2014 @ 05:55 PST | Tools | Introducing Teradata Wallet |
Hello Shawn & MaxG,
03 Questions concerning TD Wallet:
(a) The "list" command will show the item names only, not the item values. Any way for a user to see ... |
17 | 19 Nov 2014 @ 01:55 PST | Tools | Introducing Teradata Wallet | Thanks Shawn for the article & MaxG for answering the queries by all the Forum Members. These answers clearly enhance the understanding of Wallet especially concerning portability, Unix/Linux &... |
16 | 06 Nov 2014 @ 04:43 PST | Viewpoint | Node Resources Portlet - Take 2 | Hello Steve,
The "Viewpoint" user collects necessary information from the Teradata Systems as part of VP DCS services. So, is it safe to assume that Teradata Customer will always see a V... |
15 | 05 Nov 2014 @ 03:33 PST | UDA | Accessing Historical and Current Data with Unity Director | Paul, I have 1 question each about CREATE Balanced & CREATE Preferred.
(a) Question About CREATE Preferred:
Read A,B Write A,B Create Preferred = All Create Requests routed to A... |
14 | 05 Nov 2014 @ 02:44 PST | UDA | Accessing Historical and Current Data with Unity Director |
Hello Paul,
Thanks for your response. I would summarize your response & add few ascepts for clarification:
Considering that Director will manage the objects in ... |
13 | 03 Nov 2014 @ 05:00 PST | UDA | Accessing Historical and Current Data with Unity Director |
Hello Paul,
In Unity Director, assuming a Unity Server (Unity_A) manages 02 TD Systems (TD_1 & TD_2). When a new object (Table_1) is created through Unity, it appears in both ... |
12 | 23 Sep 2014 @ 07:20 PDT | Tools | Introduction to Teradata Data Mover: Create your first job |
Hello Jason,
I went through the above article series & also through the TEN Course by you on the same. I have a 04 questions, being new to the Data Mover application:
&nbs... |
11 | 22 Sep 2014 @ 06:14 PDT | Tools | A Day in the Life of a Unity Data Mover Job | Wonderful Article, Kevin. It's difficult to read the article & not feel compelled to comment on the wonderful presentation.
Smarak
|
10 | 22 Sep 2014 @ 06:11 PDT | UDA | A reliable rebooting mechanism for Data Mover Services | Thanks Yuan for the article. Even though a work-around has been devised, it's good to understand the various components & the dependency between them.
Your article is a supplement for Kevi... |
9 | 08 Sep 2014 @ 04:25 PDT | Database | Basic Teradata Admin Tools - 2 Minute Guide | Also Mike, can you tell us which document lists the various PDE States & DBS States along with their meaning ?
I am trying the understand the difference between PDE & DBS settings du... |
8 | 08 Sep 2014 @ 02:17 PDT | Database | Basic Teradata Admin Tools - 2 Minute Guide |
Hello Mike,
Thanks for your article. Just have a few question:
(a) The command "tpareset -x" or "tpa start" are executed at the root level and t... |
7 | 05 Nov 2012 @ 09:29 PST | carrie's blog | If You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now. | Thanks Carrie for the Valuable Suggestion. I would like to know 1 thing here:
When you mentioned the Non-Hashed Tables, the picture says "New Row goes to the AMP from which it was produced". How i... |
6 | 22 Oct 2012 @ 12:21 PDT | Viewpoint | Killer queries: Track them, find them, fix them | Hello Shrity...Thanks for the article. Very nice elaboration.
I would like to clear a few things:
(a) Amongst CPU Use and Impact CPU, which one is a more dominant factor for identifying Bad Quer... |
5 | 09 Oct 2012 @ 11:53 PDT | Tools | Migrating Priority Scheduler settings to TASM Using Teradata Workload Analyzer | Thanks BK and Anita for this article. It clears a few lingering questions in my mind. I am mentioning a few points in addition to a few questions:
(a) Can PD Sets and WD both exist simultaneousl... |
4 | 09 Oct 2012 @ 10:47 PDT | carrie's blog | How to Calculate Your Max Number of Usable AMP Worker Tasks | Thank You Carrie. Your comments are always highly anticipated and appreciated. Thanks for the help again. |
3 | 02 Oct 2012 @ 01:00 PDT | carrie's blog | Automated Demotions on the Appliance: What are Query Milestones? | Hello Everyone...I just need to clear a few things about Workload. Recently, I read about Resource Partition, Performance Group, Performance Period and Allocation Group. From what I have understood... |
2 | 01 Oct 2012 @ 11:48 PDT | carrie's blog | How to Calculate Your Max Number of Usable AMP Worker Tasks | Hi Carrie,
Thanks for the article.
1 Question though, when we receive Alerts for AWT Saturation, is it applicable for all the 80 AWTs (Reserved + Unreserved) or is it meant for the 62 (i.e. Excl... |
1 | 01 Oct 2012 @ 11:40 PDT | carrie's blog | Penalty Box Over-Population | Thanks Carrie for clearing a major doubt. I always thought what would happen if a query is demoted to a workload whose concurrency limit (set by Throttle) is already filled. As per your explanation... |