#DateForumTypeThreadPost
2616 Aug 2016 @ 08:52 PDTDatabaseTopicSpool space error 2646 collecting statisticsThis is a new one for me.  When I run the command below, I get a spool error.  The table has about 620 million rows in it.  Can someone please suggest what I need to do in order to r...
2504 May 2016 @ 09:04 PDTDatabaseReplyPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertAfter working with Wherescape, we discovered the problem was in the priocedure.  The first step inserts one row, and then it runs an insert of close to 500 million rows.  It looks lik e l...
2428 Apr 2016 @ 09:48 PDTDatabaseTopicAll processes blocked by a process using DBC.DBQLRuleTblTeam, Last night, all of the processes on our Teradata server were blocked, and they were blocked by a process using DBC.DBQLRuleTbl.  What process locks this table, and how could it hang all...
2325 Mar 2016 @ 12:13 PDTDatabaseReplyPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertThis is generated by Wherescape, so anything in [] is replaced with the databasename.  I didn't see anything in it that would cause it to run slower, but this has been running for over 4 h...
2223 Mar 2016 @ 02:39 PDTDatabaseReplyPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertI should also clarify that the insert statement that is taking a long time is running via a stored procedure with parameters as values going into two of the columns
2123 Mar 2016 @ 02:35 PDTDatabaseReplyPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertThanks Dieter!  There are no rows in the table before the insert.  What's interesting is that I can take the SQL from Viewpoint and run it as myself and it runs in a matter of 2 minut...
2023 Mar 2016 @ 12:17 PDTDatabaseTopicPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertTeam,   We have an insert statement that is inserting around 92 million records into a table based on a select statement from another table.  The select piece runs fine, but the followi...
1922 Jul 2015 @ 10:58 PDTDatabaseReplyOrdered Analytical Function to get the MIN valueI have a very tricky situation that I'll try to explain.  I have a view that has the following data (data is under the text) in it.  Users hitting this data do not have SQL.  The...
1822 Jul 2015 @ 10:48 PDTDatabaseTopicOrdered Analytical Function to get the MIN value
1715 Apr 2015 @ 09:08 PDTToolsReplyTPT19134 - Only happens after the 7th run of the same file.Please ignore this question.  It turns out that we finally chased it down to the tool we were using having a duplicate id, which caused two columns to get randomly swapped when the TPT script ...
1613 Apr 2015 @ 04:50 PDTToolsTopicTPT19134 - Only happens after the 7th run of the same file.Hi All,   We're using TPT to load a flat file.  It loads the file just fine 6 times.  However, on the 7th run, we get the following error:  FILE_READER: TPT19134 !ERROR! F...
1509 Jan 2015 @ 03:10 PSTDatabaseTopicChange data captureHoping that someone can help with a situation I'm in.  We have a source table that we're pulling in from SQL Server where the source is 3 million rows, and the table has about 100 colu...
1414 Jul 2014 @ 10:59 PDTConnectivityTopicJava code with a JDBC connection to Teradata via Message BrokerI'm a bit of a novice in this arena, so I hope this doesn't seem like an odd question   We currently are using Message Broker to interface HL7 transactions from our mainframe system....
1326 Mar 2013 @ 01:21 PDTGeneralTopicUNION ALL resultsOK.  I'm stumped on this one.  I run a query in Teradata, and I get the following results:   Measure      Group  Count Measure 1   XXX ...
1206 Sep 2012 @ 08:25 PDTToolsTopicTPT script for Sybase Does anyone have a template script for TPT that extracts data from Sybase?
1119 Dec 2011 @ 08:56 PSTDatabaseTopicDynamic Query View I know I've asked this one before, but it's coming up again and I need to dig around a bit.  We currently get a feed from an online survey.  A customer can take a survey any nu...
1021 Oct 2011 @ 03:53 PDTGeneralReplyCast as timestamp That did the trick.  Thanks!
921 Oct 2011 @ 02:06 PDTGeneralTopicCast as timestamp We are receiving the following data from a source system in a varchar format Sep 11 2011  5:17:05:000AM Oct  9 2011  4:52:00:000AM We can't simply use cast(...as tim...
811 Jul 2011 @ 08:45 PDTDatabaseTopicDifferences between Teradata optimizer and actual SQL performanceWe have a situation where we have a query that the explain plan says should take .56 seconds. The actual query performance ranges from 40 seconds to a couple of minutes. Can anyone make a suggest...
705 Jul 2011 @ 12:00 PDTToolsReply<Internal Session> blocking users and causing deadlockWe are having a similar problem, but it's not related to arcmain locks. We have the situations described above: -If multiple drop/alter table commands are submitted deadlock can occur. -If the...
609 May 2011 @ 10:19 PDTToolsTopicMultiloadWe are working with implementing multiload as part of our ETL processes (we have traditionally just used fastload). When running multiload, what are the considerations and/or limitations associate...
522 Mar 2011 @ 05:14 PDTDatabaseReplyLooking for View Definition in DBC tableWhat is the difference between requesttext and createtext?
417 Mar 2011 @ 04:38 PDTAnalyticsReplyDynamic viewsI'm finally getting back to this topic. Is there a way to do this with a Macro, volatile table, or global temporary table? The challenge is that the dates are passed in by Business Objects. So, ...
307 Jan 2011 @ 04:54 PSTDatabaseTopicTable TitlesDoes anyone know if you can add Titles to Teradata tables and views similar to how you can do it with columns? Thanks!
208 Nov 2010 @ 03:49 PSTAnalyticsTopicDynamic viewsWe have a query where the rows returned depend on a date range. Here is an example: SELECT a.* FROM TABLE1, INNER JOIN TABLE2 ON TABLE1.pty_id = TABLE2.pty_id AND T...

Pages