#DateWhereItemComment
1321 Apr 2016 @ 08:40 PDTÜber SQLNew StatsInfo query for TD14Dieter, Any update on your 15.10 version - if any is needed?   Thanks - JK
1220 Dec 2011 @ 07:33 PSTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Carrie, In indicate: "Once you get on Teradata 13.10, if TASM is enabled, then the database is dictating the number of sessions each load job will get." What if you are on an Appliance where the...
1110 May 2011 @ 10:58 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskUlrich, We enjoyed your article and you are right - TPT is an excellent tool and one that TD probably doesn't understand its full potential. We @ Swift Transportation have developed an environme...
1013 Jan 2011 @ 08:57 PSTToolsTeradata Parallel Transporter #2 – Benefits of Scalable PerformanceTo whom it may concern (Mark?) - We've reviewed the Reference guide for TPT and found that these variables are not supported for the TPT UPDATE operator - shame!!
912 Jan 2011 @ 12:16 PSTToolsTeradata Parallel Transporter #2 – Benefits of Scalable PerformanceAccess to old MLOAD Variables from TPT UPDATE?? In our current mload processes, we capture row count statistics using system variables available and insert these stats into a table within the ML...
821 Dec 2010 @ 09:28 PSTToolsTeradata Parallel Transporter #1 – BasicsThanks Mark. Will keep you posted and if we have issues, can we get with you? We'll start working on our 'roll out' of the strategy in Jan. The current situation is good for this approach as we'll ...
721 Dec 2010 @ 06:12 PSTToolsTeradata Parallel Transporter #1 – BasicsMarkhay - thanks for getting back. Yes, we've figured this out with our tests pulling data form single source (AS400) to our Prod and Dev instances of TD. Works like a charm and are aware of your '...
614 Dec 2010 @ 09:02 PSTDatabaseWorkload Toolkit – Part 4 – Compression Analysisanees1176 - Sorry, I do not have a Compress Tool license and do not have any pricing. Please contact AtanaSoft directly through their website (atanasoft.com) or you can email Dave Richardson (Atana...
513 Dec 2010 @ 09:50 PSTToolsTeradata Parallel Transporter #1 – BasicsQuestion: Is it possible to create a TPT 'job' that would be able to extract data with one Producer (Export Operator) and load that single data set to two different Consumers (Load Operators) on tw...
409 Sep 2010 @ 07:01 PDTDatabaseWorkload Toolkit – Part 4 – Compression AnalysisGodminer - that's great and you're right about getting upper mgt to understand about there tools and specially with Teradata! If you go to na oracle shop, you normally see TOAD which is what AtanaS...
308 Sep 2010 @ 07:38 PDTDatabaseWorkload Toolkit – Part 4 – Compression AnalysisDear DN. As a DBA on a small site (just in data, not complexity) I use the PCMP suite of data collection facilities. Scripts run each night to scrape DBC tables (including DBQL tables) and put them...
208 Sep 2010 @ 07:33 PDTDatabaseWorkload Toolkit – Part 4 – Compression AnalysisGoldminer - I know Compress Tool well - was a BETA tester for it. For one customer, by compressing only 11 of their big tables with the Compress Tool (single run) they were able to save more than t...
103 Aug 2010 @ 01:12 PDTDatabaseWorkload Toolkit – Part 4 – Compression AnalysisDave, Compression (or doing it) is usually something everyone would LOVE to do - BUT, the tools available (???) are either limited, do not make the right decisions (e.g. compress all values u...