#DateForumTypeThreadPost
5107 Aug 2016 @ 06:09 PDTDatabaseReplyMy data mover job sometimes work and sometimes hangHello Neeraj,   Investigation of Hanging DM Jobs requires TD Support assistance. You should submit an Incident with T@Ys.   Thanks, Smarak
5007 Aug 2016 @ 06:06 PDTDatabaseReplyMove data from one Teradata DB(Prod Server)to another Teradata DB (dev Server)Hello Kartaj, DM can moves 40 tables in a single DM Job {It can move multiple databases in 01 Job as well}. You just need to create the DM Job once & run it as per your requirement. Depending ...
4904 Apr 2016 @ 10:16 PDTViewpointReplyTDWM Filter logic question Hello Etienne/Eric, Assuming you have 02 Databases DB_1, which contains all the Tables & DB_2 containing all the Views. You wish to forbid any joining operation between any database with e...
4826 May 2015 @ 03:33 PDTDatabaseReplyVIEW CREATION QUERY Hello John,   The Resolver of the Parsing Engine resolves all the statements to their underlying tables. If you create a view from a view, the Resolver will resolves the same to its...
4716 Apr 2015 @ 08:59 PDTViewpointReplyImpact CPUHello Steve, We are observing CPU Utilization under "System" to be more than 60% for 15-20 minute period. We would like to know what exactly is running under the "System" categ...
4619 Mar 2015 @ 11:28 PDTDatabaseReplySET Vs MULTISETHello Kamin, SET Table with NUPI has the overhead of checking for Duplicate Rows. With a UPI or USI, this overhead is removed as the Uniqueness Check is restricted to the UPI/USI Column(s). In ...
4517 Mar 2015 @ 03:39 PDTDatabaseReplyTERADATA DBAMadhu, Refer the Database Administration PDF from Teradata Info. You will find the usage for all these User/Database.   -Smarak
4417 Mar 2015 @ 03:31 PDTDatabaseReplyNon duplicate row selection query Hello John,   You can try the below approach also & see if the Performance Gain is positive:   INSERT Into <Target Table> Select Max(DIRECT_ID), <All C...
4317 Mar 2015 @ 02:18 PDTDatabaseTopicConnections & Host FileHello All,   I have seen the question concerning Virtual Circuits across multiple posts. One question which many Customer asks is "I have 10 PEs & theoretically, I should have 120*1...
4209 Mar 2015 @ 11:34 PDTDatabaseReplySummary StatisticsHello Moutusi, After Summary Stats has been collected for the 1st time, then collecting any column level statistics will refresh the Summary Stats implicitly. The vice versa isn't true meaning...
4130 Nov 2014 @ 09:07 PSTDatabaseReplyJOIN INDEXES WITH PRIMARY INDEXHello Jugal, You can create Join Index with UPI/NUPI. The only restriction in terms of Indexes is the inability to create USI on JI Columns. All these details available in the Database Design PDF....
4025 Nov 2014 @ 01:23 PSTDatabaseReplyQueries with CPU timeouthttp://www.info.teradata.com/Datawarehouse/eBrowseBy.cfm?page=TeradataDatabase In the right side, you can find "Messages" PDF. Thanks, Smarak  
3924 Nov 2014 @ 08:58 PSTDatabaseReplyCurrentperm more than Maxperm on one AMP for databaseHello Sandeep, Possibly, the below link can help you: https://forums.teradata.com/forum/database/sumcurrentperm-summaxperm-for-one-of-the-vprocs Thanks, Smarak
3824 Nov 2014 @ 08:53 PSTDatabaseReplysliding window merge joinHello Meenakshi, The following link contains a forum post concerning optimization involving Sliding Window Merge Join: http://forums.teradata.com/forum/database/help-on-tuning-a-query#comment-1...
3724 Nov 2014 @ 04:15 PSTDatabaseReplyhelp on tuning a query Hello Srilakshmi, As per your Explain, the Query is using Sliding Window Merge Join, which is PPI aware. The process followed by the Sliding Window Merge Join ensures Product Join between th...
3624 Nov 2014 @ 03:43 PSTDatabaseReplyJoins involving Partitioned PIs Hello Gian,   For joining between 02 tables using PPI-Non PPI Column, if Teradata use Dynamic Partition Elimination, it will be an indication that the presence of PPI column is bein...
3524 Nov 2014 @ 03:13 PSTDatabaseReplyIdentify the queries Hello Gian, There is an option which needs to be enabled/disabled to ensure that comments are also getting logged into DBQL as part of SQL Text. The exact option cannot be recalled by me now...
3424 Nov 2014 @ 03:03 PSTDatabaseReplyQueries with CPU timeout Hello Gian, For all errors reported by Teradata, use the Error Messages PDF to understand the error, possible explanations & recommeded solutions.  Thanks, Smarak
3324 Nov 2014 @ 02:57 PSTDatabaseReplyOptimization with JOIN condition Hello Marios,   For any queries concerning Optimization, it is advisable to post the Explain Plan also. Having said that, you mentioned that you created PI on the Joining Columns (D...
3208 Sep 2014 @ 04:05 PDTGeneralReplyHow to start teradata service in suse linux vmware image (teradata express 13.0)Hello Purushotham, Once you setup the Server via VMware porperly, you can install the Teradata Tools & utilities in your machine. Then, using the IP of the Server, you can connect via BTE...
3105 Jun 2014 @ 01:36 PDTDatabaseTopicPartially Qualifying Join IndexHello All,   While covering the Join Index in Database Design PDF, I came across this section explaining the conditions for partially covering join index to prevail: (a) RowID of the underl...
3005 Jun 2014 @ 12:18 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10Thanks Jim & Rupert.   I came to this forum post reading the same Page 611 and I found the answers also... Wonderful to be part of such a forum.
2905 Jun 2014 @ 09:17 PDTDatabaseReplyIdentifying HOTAMP / COLD AMPHello Todd,   In our production environment, we refer HOT AMP as:   For any query which is skewed by definition, there are some AMPs which are over-burdened by work. As such, the AMP ...
2805 Jun 2014 @ 08:54 PDTDatabaseReplyPerformance of Correlated Subquery!!!Thanks Santanu for the examples. I wanted to understand why the presence of duplicates will cause an error. I did a similar testing as you elaborated. Now, it's clear to me. Pasting the code sn...
2704 Jun 2014 @ 01:09 PDTDatabaseReplyPerformance of Correlated Subquery!!!Hello Joel,   Really nice explanation above.    When you say "SELECT E.*FROM EMPLOYEE EWHERE E.DEPTNO = (SELECT D.DEPTNO FROM DEPT D WHERE D.DEPTNO = E.DEPTNO);" error ...

Pages