#DateWhereItemComment
2512 Feb 2015 @ 08:22 PSTcarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Very 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 ...
2412 Feb 2015 @ 07:32 PSTcarrie's blogDetermining Precedence Among TASM Planned EnvironmentsHello 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, ...
2312 Feb 2015 @ 06:39 PSTcarrie's blogExpediting Express Requests Hello Carrie, Wonderful Article. I have a few questions concerning Expediting Express Requests: (a) You have mentioned the DBQLogTbl Column "ParserExpTime" den...
2221 Jan 2015 @ 03:49 PSTToolsConquering Big Data with Teradata Data Mover parallelismThanks Kevin for the article. It's a valuable article on the features which are usually neglected.  -Smarak
2107 Jan 2015 @ 12:16 PSTViewpointTeradata 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...
2026 Nov 2014 @ 01:04 PSTGeneralWorking 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...
1920 Nov 2014 @ 05:06 PSTViewpointNode Resources Portlet - Take 2Hello Steve,   The Alert "PeakSpoolSpace" available in "Database Space" Alert Type is defined as PeakSpool divided by MaxSpool in the Configuration Guide. The Value i...
1819 Nov 2014 @ 05:55 PSTToolsIntroducing 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 ...
1719 Nov 2014 @ 01:55 PSTToolsIntroducing Teradata WalletThanks 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 &...
1606 Nov 2014 @ 04:43 PSTViewpointNode Resources Portlet - Take 2Hello 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...
1505 Nov 2014 @ 03:33 PSTUDAAccessing Historical and Current Data with Unity DirectorPaul, 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...
1405 Nov 2014 @ 02:44 PSTUDAAccessing 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 ...
1303 Nov 2014 @ 05:00 PSTUDAAccessing 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 ...
1223 Sep 2014 @ 07:20 PDTToolsIntroduction 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...
1122 Sep 2014 @ 06:14 PDTToolsA Day in the Life of a Unity Data Mover JobWonderful Article, Kevin. It's difficult to read the article & not feel compelled to comment on the wonderful presentation.   Smarak
1022 Sep 2014 @ 06:11 PDTUDAA reliable rebooting mechanism for Data Mover ServicesThanks 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...
908 Sep 2014 @ 04:25 PDTDatabaseBasic Teradata Admin Tools - 2 Minute GuideAlso 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...
808 Sep 2014 @ 02:17 PDTDatabaseBasic 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...
705 Nov 2012 @ 09:29 PSTcarrie's blogIf 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...
622 Oct 2012 @ 12:21 PDTViewpointKiller queries: Track them, find them, fix themHello 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...
509 Oct 2012 @ 11:53 PDTToolsMigrating Priority Scheduler settings to TASM Using Teradata Workload AnalyzerThanks 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...
409 Oct 2012 @ 10:47 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksThank You Carrie. Your comments are always highly anticipated and appreciated. Thanks for the help again.
302 Oct 2012 @ 01:00 PDTcarrie's blogAutomated 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...
201 Oct 2012 @ 11:48 PDTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksHi 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...
101 Oct 2012 @ 11:40 PDTcarrie's blogPenalty 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...