47 | 14 Jul 2016 @ 09:00 PDT | Tools | Reply | TPT 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... |
46 | 13 Jul 2016 @ 10:40 PDT | Tools | Reply | TPT 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... |
45 | 20 May 2016 @ 01:46 PDT | Database | Reply | UDFCONCAT | Thank you Dieter.
-Suhail
|
44 | 20 May 2016 @ 10:43 PDT | Database | Reply | UDFCONCAT | The reason I ask for an effecient solution is because the input table has about 500 million records.
|
43 | 20 May 2016 @ 10:41 PDT | Database | Reply | UDFCONCAT | Brilliant!! 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... |
42 | 20 May 2016 @ 07:17 PDT | Database | Topic | UDFCONCAT | I'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... |
41 | 18 May 2016 @ 10:40 PDT | Database | Reply | dynamic index collect stats statement | Hi 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
|
40 | 04 May 2016 @ 12:22 PDT | Tools | Reply | TPT 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'... |
39 | 04 May 2016 @ 12:03 PDT | Tools | Reply | TPT deadlock Issue. | Hi Steve,
Once we upgrade to the latest patch of 15.00, do you think these deadlocks will go away?
-Suhail
|
38 | 04 May 2016 @ 10:17 PDT | Tools | Reply | TPT 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... |
37 | 04 May 2016 @ 08:26 PDT | Tools | Reply | TPT 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... |
36 | 03 May 2016 @ 10:29 PDT | Tools | Reply | TPT 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... |
35 | 03 May 2016 @ 03:06 PDT | Tools | Reply | TPT 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... |
34 | 31 Mar 2016 @ 07:49 PDT | Tools | Reply | How to extract the count for source & target records in TPT | Thank you for the info Feinholz.
-Suhail
|
33 | 29 Mar 2016 @ 04:10 PDT | Tools | Reply | How to extract the count for source & target records in TPT | Just 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... |
32 | 13 Oct 2014 @ 10:19 PDT | Database | Reply | SQL STORED PROCEDURES SQL SECURITY INVOKER OPTION | Thanks Tom,
I have gone ahead and created an incident for this.
-Suhail
|
31 | 09 Oct 2014 @ 09:22 PDT | Database | Reply | SQL STORED PROCEDURES SQL SECURITY INVOKER OPTION | Can anyone throw any light on this issue?
|
30 | 06 Oct 2014 @ 10:38 PDT | Database | Reply | SQL STORED PROCEDURES SQL SECURITY INVOKER OPTION | fyi...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
|
29 | 06 Oct 2014 @ 10:32 PDT | Database | Topic | SQL 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 ... |
28 | 18 Dec 2013 @ 10:13 PST | UDA | Reply | why 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... |
27 | 18 Dec 2013 @ 10:01 PST | UDA | Reply | why 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... |
26 | 18 Dec 2013 @ 09:01 PST | UDA | Reply | why 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... |
25 | 06 Nov 2013 @ 09:14 PST | Training | Reply | Teradata 12 Qualifying Exam for V2R5 Masters | Hello 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
|
24 | 31 Oct 2013 @ 10:08 PDT | Database | Reply | Query band in Macros | ok 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... |
23 | 30 Oct 2013 @ 10:39 PDT | Database | Reply | Query band in Macros | Do 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 ... |