#DateForumTypeThreadPost
4313 Sep 2012 @ 10:22 PDTDatabaseTopicDBQL SQLTextInfo 3577: row size or sort key size overflow I am getting a 3577: row size or sort key size overflow when attempting to query dbqlsqltbl.sqltextinfo in sqla (yes it is a large query).  Does anyone have any workarounds.  ...
4214 Aug 2012 @ 10:52 PDTDatabaseTopicAdd comment when migrating a table I am in the process of developing a bteq script that captures ddl from dbc.tables for migration purposes.  I'm creating a series of 'show table' entries into a file that is then...
4108 Jun 2012 @ 08:32 PDTDatabaseReplyNeed help in tuning a query I would say it is just generally a good idea to do it anyway.  Whether it improves the query... who knows... pretty low hanging fruit though.
4006 Jun 2012 @ 02:49 PDTDatabaseReplyNeed help in tuning a query Looks like it could be a statistics problem to me (no confidence everywhere).  Collect the necessary stats, rerun the query, then see if your plan is much better.
3906 Jun 2012 @ 02:34 PDTDatabaseTopicETL Developer Sandbox in PROD I wanted to get some input from some of the DBAs on this forum.  I have some ETL developers that want me to grant them some perm space in their database in order to create a personal sandbo...
3825 May 2012 @ 07:31 PDTToolsReplyTPT10505 Error when fastloading with Data Services Thanks... I will forward this to our DataServices ETL developers.
3724 May 2012 @ 03:07 PDTToolsReplyTPT10505 Error when fastloading with Data Services Would this error then be informational only and not result in an abort?
3614 May 2012 @ 02:54 PDTToolsTopicTPT10505 Error when fastloading with Data Services Has anyone run into a TPT10505 fastload error before.  I found documentation on 10505 but not TPT10505 and am wondering if they are one and the same.  This is the output from the faile...
3509 May 2012 @ 10:18 PDTDatabaseReplyINSERT SELECT Performance mystery Check to see if you have any secondary indexes.  If so, might want to drop and then re-create.
3418 Apr 2012 @ 02:29 PDTToolsReplyCopy tables between two different systems There is a nifty little tool in the Atana Suite called SyncTool.  A DBA's dream!  Copies over everything including statistics.  It is very parameter driven in that if only the...
3318 Apr 2012 @ 11:59 PDTDatabaseReplyreset identity column after table move I think the minimum is 10000 but not sure...maybe someone else knows?  
3216 Apr 2012 @ 01:26 PDTDatabaseReplyDeleting data from DBQLogTbl? You might also check to see if you have some ETL processes that are loading a very large table via ODBC.  This would cause your DBQL tables to grow rapidly since every target table ins...
3116 Apr 2012 @ 01:20 PDTDatabaseReplyreset identity column after table move Blocks of identity values are assigned to amps in blocks.  It sounds like your system was set up to assign in blocks of 100000.  I believe this is a configurable parameter that can be ...
3026 Mar 2012 @ 01:37 PDTDatabaseReplyInformatica jobs failed with 'Teradata PT API Error' I don't know if this will correct your error, but we found that the TPT API will experience issues if it is not uninstalled and reinstalled during a patch.  You might want to try uninst...
2916 Feb 2012 @ 01:51 PSTGeneralReplyLoading data using ODBC drivers thorugh Informatica Your DBQL tables will get quite large recording single record inserts as a result of the row by row odbc connection processing within the Informatica engine.
2807 Feb 2012 @ 02:36 PSTDatabaseTopicExcessive row estimates I have been looking at an explain that is giving me some unbelievably high row estimates when joining two spool files.  This is the result of some ETL pushdown SQL generated by DataServices...
2707 Dec 2011 @ 11:56 PSTDatabaseReplyInserting a null into a not null column defined as NOT NULL DEFAULT=0 Thank you very much for your response Jigar!  I was under the assumption that null would be treated as a 'no value' candidate for the default replacement.  I guess it makes sen...
2607 Dec 2011 @ 10:27 PSTDatabaseTopicInserting a null into a not null column defined as NOT NULL DEFAULT=0 We are currently experiencing either a limitation or a bug attempting to insert a null value into a field defined as not null with a default=0.  I would think that if a null were encountere...
2521 Nov 2011 @ 10:59 PSTDatabaseTopicUTF8 to UTF16 Conversion Question Currently fastloading into an empty stage table from an SAP extractor.  One of the columns is defined as unicode in our stage table.  We are loading through Data Services specifying th...
2416 Nov 2011 @ 02:11 PSTDatabaseTopicNumeric sizing when using aggregation We are in the process of defining a fact table with a couple of fields defined as displayed below:   new_hire_cnt   Integer transfer_cnt  Integer   I...
2320 Oct 2011 @ 01:53 PDTDatabaseReplyHow to store and display a german umlaut? Thanks Dieter! The problem was actually a setting within Data Services.  Once the setting was changed to utf16, I believe it fixed the problem.  Thank you all very much for your re...
2218 Oct 2011 @ 09:16 PDTDatabaseReplyHow to store and display a german umlaut? Sorry Dieter... I hammered your last name... I meant Noth with an umlaut over the o.
2118 Oct 2011 @ 08:45 PDTDatabaseTopicHow to store and display a german umlaut? I thought Dieter might be able to jump in on this one since his last name is really Doter with an umlaut over the o. We are in the process of pulling data out of SAP ECC into a Teradata 13.1...
2025 Sep 2011 @ 06:54 PDTDatabaseTopicDynamic SQL to recreate existing USI I am in the process of scrubbing some timestamp fields in our prod environment.  What I want to do is (1) drop the USI, (2) scrub the data -- timestamp part of the usi, (3) re-create the us...
1923 May 2011 @ 12:31 PDTDatabaseReplyColumn order in table definition when collecting multi-column statisticsI received an official response from Teradata regarding my question concerning column order in a table and multi-column stats collection. For those that care, here is the response: "The system ...

Pages