#DateForumTypeThreadPost
3611 Dec 2012 @ 10:01 PSTViewpointReplyError when starting Workload DesignerHi, I'm encountering the same error. Which data collector service did you start/stop? Thanks!
3511 Oct 2012 @ 08:44 PDTGeneralReplyDifference between Product Join and Cartesian Product JoinA bit curious on this..  I know the join strategy for both are same  I also think that Cartesian Product join is a type of Product join   but what is really their difference? ...
3410 Jul 2012 @ 10:59 PDTDatabaseTopicLogonTime and StartTime In DBQL – DBQLOGTBL, I’m seeing entries specifically for loading jobs where there is a huge time difference between the “LogonTime” and “StartTime”. Is this c...
3323 Feb 2012 @ 01:13 PSTDatabaseReplyBTEQ LOGON timeout Hi Carlos, Yes, we actually purposely make the DB offline so we can test the error-handling mechanisms of our BTEQ script. What I want to happen is when BTEQ tries to connect to a down D...
3222 Feb 2012 @ 11:02 PSTDatabaseTopicBTEQ LOGON timeout Hi guys, What are the workarounds for BTEQ to exit if the DB it's trying to log into is down. *** WARNING: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS In MLOAD or FLOA...
3121 Feb 2012 @ 02:56 PSTDatabaseTopicINSERT SELECT will it rollback? Hi guys, If I have an INSERT-SELECT statement. Is there a scenario (aside from SET or MULTISET DDL) where my source rows will not be the same with the actual inserted rows? Or ...
3024 Jan 2012 @ 04:13 PSTDatabaseTopicIncremental BackupHi guys, Has anyone here implemented an incremental backup strategy? I would like to know more about details such as: - BAR strategy (i.e. frequency of full backup) - incremental backup via...
2924 Jan 2012 @ 04:01 PSTDatabaseReplyLocks : Blocks and BlockingThanks much Dieter. Just wanted to know if the impact is something like DBQL or should it be generally less than that? Can this feature be part of day to day production or is it only being us...
2824 Jan 2012 @ 02:18 PSTDatabaseTopicBuild Data tables Hi guys, I encountered error: "DATABASENAME.TABLENAME is being restored" We just recently completed a data restoration to a new system. I already tried RELEASE LOCK b...
2723 Jan 2012 @ 05:00 PSTDatabaseReplyLocks : Blocks and Blocking How to enable this Locking Logger? Will it have a big impact on system resources (CPU, IO, memory) ?
2610 Jan 2012 @ 12:42 PSTDatabaseReplyWhen are join Indexes being used by the optimizer?   CREATE SET TABLE Test2 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( Col1 INTEGER ,col2 DATE FORMAT 'YYYY-MM-DD' , col3 ...
2529 Dec 2011 @ 12:51 PSTDatabaseTopicWhen are join Indexes being used by the optimizer? Hi gurus, Generally speaking, when are join indexes being used by the optimizer? i.e. SELECT COUNT(*) query with date filter.. SPARSE JOIN INDEX 3 columns and a date filter on the ba...
2421 Dec 2011 @ 06:35 PSTDatabaseReplyData Block Thanks Todd! Understood everything you said except when you mentioned offsets.. what do you mean by those offsets? Is it an offset bit that you're referring to?
2321 Dec 2011 @ 06:10 PSTDatabaseTopicData Block Hi guys, Question.. just need clarification on below statement .. after the data block has been read from the disk How does this work internally? Does reading a data block mean putti...
2221 Dec 2011 @ 01:26 PSTDatabaseReplyUniqueness Value Hi Dieter, Thanks guru! We're now satisified. So the statement: The system increments the uniqueness value by one for each successive table row having the same row hash. Once...
2120 Dec 2011 @ 07:30 PSTDatabaseReplyUniqueness Value Hi Dieter, Table1 has Col1 with 1 record value of 'Pat' (VARHCAR(5)) --- existing row Table2 has Col1 with 1 record value of 'Pat' (VARCHAR(5)) --- new row to be ad...
2020 Dec 2011 @ 03:46 PSTDatabaseTopicUniqueness Value Every table has its own set of data blocks. Rows of different tables never appear on the same data block. This minimizes the number of collisions to a trivial level.. Collisio...
1913 Dec 2011 @ 04:44 PSTUDAReplyImplementation of Incremental Backup Hi Roy, Would like to ask more details about the backup strategy you guys have implemented. Can I contact you separately? Thanks! Pat
1807 Dec 2011 @ 04:55 PSTDatabaseTopicNUPI and USI Hey guys, When you have a NUPI, it's good to have a USI because this can enforce uniqueness on your NUPI. Just wanted to ask for a particular scenario where you will have a combinat...
1727 Nov 2011 @ 11:22 PSTDatabaseReplyHow does Teradata store/retrieve Partition ID? Thanks for the quick reply Dieter. So I get one thing cleared out - Hash Map is used to distribute rows across AMPs, it doesn't do anything about the Partitions. As for the partitio...
1627 Nov 2011 @ 08:35 PSTDatabaseTopicHow does Teradata store/retrieve Partition ID? Hi gurus, How does Teradata store/retrieve Partition ID/number information? Consider the scenario where a query/insert statement specifies the PI and Partition information (PI cont...
1511 Nov 2011 @ 07:35 PSTDatabaseTopicQueue Tables in Database Express Hey guys, I'm trying to create a Queue table in a Teradata Database Express environment but unsuccessful to do so. CREATE TABLE T_Queue, QUEUE ( qits TIMESTAMP(6) NOT NULL DEFAUL...
1429 Sep 2010 @ 09:03 PDTDatabaseReplyInputs needed to determine primary indexChoosing the Primary Index is one of the most critical part in a Teradata system because it affects both QUERY PERFORMANCE and DATA STORAGE. In choosing a PI, one should consider 3 things: 1) D...
1308 Sep 2010 @ 07:23 PDTToolsTopicTPT Error CodesHi guys, What document can I find all the TPT error codes? Would be helpful if you can also list documents for the error codes of the other tools also Thanks!
1226 Aug 2010 @ 11:00 PDTGeneralReplyFailure 2646 No more spool space insome of the names haven't displayed properly, basically: testdb is my Primary database testuser is my Primary user created from testdb

Pages