#DateForumTypeThreadPost
4714 Jul 2016 @ 09:00 PDTToolsReplyTPT deadlock Issue.Thanks Johannes. We are in the process of familiarizing ourselves with the new features of 15.10. You're right. The PI changes could help. Hopefully the deadlocks reduce a bit after the upgrade...
4613 Jul 2016 @ 10:40 PDTToolsReplyTPT deadlock Issue.Hi Harsh, We haven't done the TPT upgrade yet. We're scheduled to go to Teradata version: 15.10 in next few days. It appears that when we upgraded our Test system to 15.10, the # of deadlo...
4520 May 2016 @ 01:46 PDTDatabaseReplyUDFCONCATThank you Dieter. -Suhail
4420 May 2016 @ 10:43 PDTDatabaseReplyUDFCONCATThe reason I ask for an effecient solution is because the input table has about 500 million records.
4320 May 2016 @ 10:41 PDTDatabaseReplyUDFCONCATBrilliant!! Thank you sir!  One additional question regarding this comment: "Of course there's no guarantee for correct sorting, it might work today and the next patch/version break...
4220 May 2016 @ 07:17 PDTDatabaseTopicUDFCONCATI'm looking into usage of function: tdstats.udfconcat. Is there any way to control the order of the values that this function concatenates? If I have a table: TABLE1 that looks like this: Col...
4118 May 2016 @ 10:40 PDTDatabaseReplydynamic index collect stats statementHi guys, Sorry for posting on an old thread. I'm looking into usage of udfconcat. Is there any way to control the order of the values that this function concatenates? -Suhail
4004 May 2016 @ 12:22 PDTToolsReplyTPT deadlock Issue.Thank you so much for your inputs Steve. We will work on upgrading to the latest patch. Just curious, can you advise on how the latest patch of TPT handles deadlocks better than the version we'...
3904 May 2016 @ 12:03 PDTToolsReplyTPT deadlock Issue.Hi Steve, Once we upgrade to the latest patch of 15.00, do you think these deadlocks will go away? -Suhail
3804 May 2016 @ 10:17 PDTToolsReplyTPT deadlock Issue.At line#147 in the tpt log I posted above, it does say it is retrying the request after receiving the initial deadlock error. Does it retry only once? Is there any setting (in DBS?) to specify ho...
3704 May 2016 @ 08:26 PDTToolsReplyTPT deadlock Issue.Here is the log file we have:   usr/tmp> cat xyz.log Teradata Parallel Transporter Version 15.00.00.00 Job log: /opt/teradata/client/15.00/tbuild/logs/20160502073945_85315420-5632.out...
3603 May 2016 @ 10:29 PDTToolsReplyTPT deadlock Issue.The TPT version we use is: 15.00.00.00. We're on Teradata database version: 15.0. Here is my platform info: usr/tmp> uname -a #1 SMP Tue Apr 7 09:13:12 PDT 2015 x86_64 x86_64 x86_64...
3503 May 2016 @ 03:06 PDTToolsReplyTPT deadlock Issue.Has anyone found a resolution to this? I would appreciate if someone can share their insights. We also receive deadlock errors with some of our TPT LOAD jobs while trying to insert into the log ta...
3431 Mar 2016 @ 07:49 PDTToolsReplyHow to extract the count for source & target records in TPTThank you for the info Feinholz. -Suhail
3329 Mar 2016 @ 04:10 PDTToolsReplyHow to extract the count for source & target records in TPTJust had one quick question regarding TPT. In order to read the tpt logs, the only way is to use the tlogview command right? Is there any setting in TPT that allows it to generate the job log in r...
3213 Oct 2014 @ 10:19 PDTDatabaseReplySQL STORED PROCEDURES SQL SECURITY INVOKER OPTIONThanks Tom, I have gone ahead and created an incident for this. -Suhail
3109 Oct 2014 @ 09:22 PDTDatabaseReplySQL STORED PROCEDURES SQL SECURITY INVOKER OPTIONCan anyone throw any light on this issue?
3006 Oct 2014 @ 10:38 PDTDatabaseReplySQL STORED PROCEDURES SQL SECURITY INVOKER OPTIONfyi...the correct link to the documentation is:  http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1144_111A/Create_Procedure-Syntax.023.21.html
2906 Oct 2014 @ 10:32 PDTDatabaseTopicSQL STORED PROCEDURES SQL SECURITY INVOKER OPTION Can someone elaborate on the SQL SECURITY INVOKER option in stored procedures? I need to create a stored procedure and ensure the privilege(i.e. the privilege on the underlying database objects ...
2818 Dec 2013 @ 10:13 PSTUDAReplywhy should we use SET table ?I apologize for being persistent on this. So you do confirm that the very first insert-select(where the insert is happening into a empty table with 0 records) will also be subjected to NUPI D...
2718 Dec 2013 @ 10:01 PSTUDAReplywhy should we use SET table ?I guess the ambiguity was that I missed to mention that the target table is empty(I apologize).  I wanted to know if nupi dup row check will be done if we're inserting...
2618 Dec 2013 @ 09:01 PSTUDAReplywhy should we use SET table ?quick question: Will this cause a nupi duplicate row check operation too? Insert into <A_4_COLUMN_set_table_with only NUPI ON IT> SELECT COL1, COL2,COL3,COL4 FROM <MULTISET SET STAGE T...
2506 Nov 2013 @ 09:14 PSTTrainingReplyTeradata 12 Qualifying Exam for V2R5 MastersHello Badithya, Did you give this exam? Do you have any material that you can share? I'm planning to write this exam too. Regards, Suhail
2431 Oct 2013 @ 10:08 PDTDatabaseReplyQuery band in Macrosok Thanks. Do you think it is reasonable to put in a ticket to Teradata regarding this? So that in some future release they start considering the whole SET QUERY BAND command either...
2330 Oct 2013 @ 10:39 PDTDatabaseReplyQuery band in MacrosDo you know why one is considered a DDL command and other a DML command? I know for a fact that the session query band updates the DBC.SessionTbl and the transaction query band does not. Is ...

Pages