#DateForumTypeThreadPost
4320 Mar 2016 @ 03:35 PDTGeneralTopicColumns Transformation to Sets boundaries   i have a table with the following values for Sets of values, need to generate teh start and the end of each set   Values ~~~~~ 1 2 3 4 5 11 ...
4202 Dec 2015 @ 11:03 PSTDatabaseReplyTeradata DBQL logging setup and maintanence document for TD 15aftre upgrade to 15.10 i can't find PDCRADM database installed, maybe DIPPDCR hadn't run. Do PDCR only availbale as separate PS product also on 15 ? it will be painful since the old SYS_M...
4101 Dec 2015 @ 09:29 PSTDatabaseReplyDBQL_logging_and_maintenance TD15XBased on teh last reponse in the below post PDCR is installed out of the box: https://forums.teradata.com/forum/database/teradata-dbql-logging-setup-and-maintanence-document-for-td-15
4022 Dec 2014 @ 02:16 PSTViewpointReplyTASM Exception and TASM Filtersi Recall this shoud be a new Feature in 15.10 or maybe already implemented in 15, not sure; but not on 14/14.10
3912 Dec 2014 @ 02:06 PSTCloud ComputingReplyPerformance issue with Teradata Express for VMware Player There should be three main reasons easly to rule out : 1. Processor: Check in Win. Task Manager & Suse system monitor to se whether COU is  always hitting 100% when runnign any operation...
3821 Sep 2014 @ 12:57 PDTDatabaseTopicHash Index To Eliminate Redistribution Onlyi want to use Hash index to Eliminate Redistribution only not to fetch the column Data. i'm using the following DDL:   CREATE HASH INDEX  DevDB.AMSH_HshInd , NO FALLBACK (Ac...
3728 Sep 2013 @ 07:03 PDTUDAReplyadvantages of teradata over other databasespalbiswarup IMO, size is not the primary factor; it;s more of how data accessed with regard to concurrncy and how complex analytical operation performed and more importantly the expected response t...
3621 Aug 2013 @ 06:23 PDTUDAReplyCompiling Stored Proc - VC++ not installed errorHad this error with TD Express 13.10 on wondows 7: CREATE PROCEDURE Failed.  [5862] C/C++ compiler is not installed. problem solved after  Installing vc++ 2012 redistributable and ...
3512 Aug 2013 @ 08:50 PDTDatabaseTopicVariable length Columns vs Fixed lengthAre there any performance implication using Variable / Fixed lenght Columns. i've passed a URl where it recommend alwasy using Fixed lenght for performacne reason. However,  i would...
3423 May 2013 @ 01:49 PDTDatabaseReplyACCOUNTING CPU usage fpr UDFit's C and we are 13.10. So it will be accounted though !
3322 May 2013 @ 05:22 PDTDatabaseTopicACCOUNTING CPU usage fpr UDFWe want to create UDF to perform some text manilulation like Oracle UDF's. To  Evaluatet he effectiveness of these function we are planing to compare CPU utilization for the query using t...
3203 Mar 2013 @ 11:46 PSTDatabaseReplySampled Stats vs Time trade-offThanks Dieter Carrie blog is very useful and having date columns not samples is on our plan now. I've noticed when minimizing the Sample size the number of values computed decreases; which can b...
3103 Mar 2013 @ 04:39 PSTDatabaseTopicRedistribution with LOJ despite same PIwhen i Join two tables having the same PI using Left outer Join on the PI (same column on both tables) ; Redistribution occur. However Inner join do not cause redistribution [by way of a RowHash...
3028 Feb 2013 @ 01:51 PSTDatabaseTopicSampled Stats vs Time trade-offOur Goal is we need to minimize collect sats time: we do use Combination for Full / Sample stats based on Row size: - Smaple 50% for all table's statitics combination for tables  > 5 ...
2907 Feb 2013 @ 09:39 PSTToolsReplyvery High CPU spent on [CheckPoint Loading]Most of CPU in Our system Spent there, i'm thinking of using NOPI which May help to decrease CPU spent there (which is our main concern) ; any other recommendation ?   Regards   &...
2803 Feb 2013 @ 06:24 PSTToolsTopicvery High CPU spent on [CheckPoint Loading]dears, While Monitoring CPU usage from DBQL for each user, grouped by day/hour/statement type. we find that  [CheckPoint Loading] statement type consumes Most of CPU for any user uses utilit...
2720 Jan 2013 @ 09:58 PSTDatabaseTopicFastLoad job gets system performance downwe have a Fastload job fired from Informatics which parses XML and insterts into 12 tables in a single Job, total number of XML files is arround 70K files in 5 Gb. The problem is as soon as the jo...
2603 Jan 2013 @ 01:50 PSTDatabaseReplyTime Data Typei recall Dieter had replied same querion before: let me recall his point: - you are using SQLA, odbc connection method - what you need to change is the DateTime format in the ODBC options from I...
2501 Nov 2012 @ 06:51 PDTToolsTopicDisable Pmon LogonsAre There anyway we can disable logons for PMON clients and Teradata Manager. Our Primary concerns is to allow user to abort their own queries from Viewpoint [My Queries] tab which requires the us...
2430 Oct 2012 @ 04:27 PDTViewpointTopiccontrol mapping of teradata accounts in Profile tab  This is Rergarding Profile/Teradata accounts sub-tab (VP 14.0) where a Vewpoint user can map database accounts to their viewpoint user which affect queries displayed in 'My Queries&#...
2330 Jul 2012 @ 05:22 PDTDatabaseTopicTVS: tables resides on ssd or hdd we are using TVS on td 13.10. TVAM management tool for TVS only allow reports at cylinder/amp  level which is on the physical level we need to relate this data to a more logica...
2215 Jul 2012 @ 08:21 PDTDatabaseReplyHuge Cardinality estimates for TIMESTAMP COLUMNS NO it;s not sampled. with wider range ( the whole month)  the ratio changed from 1:10   SELECT Subscription_id FROM  tdb.subscription_offering_hist c WHERE c.subscri...
2115 Jul 2012 @ 06:27 PDTDatabaseReplyHuge Cardinality estimates for TIMESTAMP COLUMNS i thought high confidence means stats are good  current !   we are running 13.10    Date Time          ...
2015 Jul 2012 @ 04:16 PDTDatabaseReplyHuge Cardinality estimates for TIMESTAMP COLUMNS Thank You Dieter for the important information: However: SELECT Subscription_Id FROM devdb.soh WHERE CAST( CAST( '2012-05-31' AS DATE ) AS TIMESTAMP(0)) + ((TIME '23:59:5...
1912 Jul 2012 @ 09:26 PDTDatabaseTopicHuge Cardinality estimates for TIMESTAMP COLUMNS estimated cardinality for the following predicate towards timestamp column is far too high vs date column 1) Table DDL: -------------------------------------- CREATE MULTISET TABLE t...

Pages