#DateForumTypeThreadPost
2412 Mar 2013 @ 08:13 PDTDatabaseReplyEnabling ALC, Pros and consDBSControlParameter No13dot0Backdown should be enabled (TRUE).
2323 Dec 2011 @ 10:18 PSTDatabaseReplyFind Sampled Statsdbc.***statistics tables do have this information about sampling and the sample size.
2206 Dec 2011 @ 08:54 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATAFor consistent read, you could use the READ lock view with the MERGE statement and that should solve the problem. MERGE = Teradata mode = rowhash lock for write & READ view= committed data.
2106 Dec 2011 @ 08:45 PSTDatabaseReplyParsing Engine is taking long time to parse a query !!!check the TASM configuration, if you have throttles subjected to the session then that might be a place for further investigation.
2028 Nov 2011 @ 06:10 PSTViewpointReplyBulk Load for Viewpoint usersI'd suggest LDAP is the way to go. We were in this situation with limited resources to manage the system and taking on the user maintenance was just too much. Password reset requests everyday!! Onc...
1928 Nov 2011 @ 05:19 PSTViewpointReplyHow to create an alert on spool usageWhat are the options for the appliance platform?
1823 Oct 2011 @ 09:43 PDTDatabaseReply3806: Table/view/trigger name is ambiguousCheck your default database, there might be an object with the same name.
1711 Oct 2011 @ 09:55 PDTDatabaseReplyMerge Vs Delete/InsertMerge statements are definitely faster by atleast 30%, from my experience, but the most important benefit is error handling. One thing to watchout for is for tables with PPI, it could get tricky w...
1611 Oct 2011 @ 11:33 PDTDatabaseReplyParsing Help Statistics Output This is awesome, thanks for the code. Now I can do all the instrumentation from within the database !!
1528 Sep 2011 @ 10:26 PDTDatabaseReplynamed subqueries in Teradata?With Derivedtablename As( Sel.....) Sel ... from derivedtablename is a valid syntax on Teradata. Check out the SQL documentation for further details on the WITH statement.
1428 Sep 2011 @ 10:16 PDTDatabaseReplyParsing Help Statistics OutputThanks for the clear documentation on this. I'm using this information/SQL to find out what is stored in the dictionary. But, when I want get the current row count, I'm not doing the traditional ro...
1328 Sep 2011 @ 10:04 PDTDatabaseReplyidentify total rows changes to identify tables with Stale statisticsDetecting chqnge demographic is equally expensive as collecting stats, relying on row count fluctuations is a known good practice. You can obtain this information from the DBC table. Depending on t...
1228 Sep 2011 @ 09:58 PDTDatabaseReplyMails from stored procedure Depending on whether you use Teradata Manager or Viewpoint, if you have Smtp configured to send emails then you could leverage the AlertRequest table to submit the notifications that you want to be...
1126 Sep 2011 @ 09:00 PDTDatabaseReplyDifference of rows in SELECT COUNT(*) and SELECT * If you can attach the explain, it might be helpful. Also, check if you have any Soft Referential integrity constraints on the objects invovled.
1026 Sep 2011 @ 08:55 PDTDatabaseTopicParsing Help Statistics Output What is the best way to extract the output of the 'Help statistics DbName.TblName column Partition;", for the purpose of extracting the value of the column 'Number of Rows'....
920 Jun 2011 @ 11:51 PDTGeneralReplyUpdate MERGE when matched is referenced on non - PI value Merge has two basic requirements , which cannot be avoided. 1. PI has to be involved in the ON clause 2. If the table has PPI , then the PPI columns have to be involved in the ON clause. This ...
801 Jun 2011 @ 11:27 PDTViewpointReplyDeleted VP-System keeps on coming back in 'Teradata Systems' admin portletLooks like you have an TMSM environment. If this assumption is correct, then your 'deleted' system is still sending events through the TMSM Client. Unless you turn off the TMSM Client on this syste...
727 Dec 2010 @ 01:07 PSTTrainingReplyTeradata 12 CertificationNot sure how you managed to get this posting through, but please help preserve the value of Teradata Certification.
603 Dec 2010 @ 11:10 PSTThird Party SoftwareReplyBacking up Teradata using Tivoli Storage Manager (TSM)We have TSM at our site and I'm using it. Raise your questions, will try to find the answers..
526 Aug 2010 @ 11:55 PDTDatabaseReplyHow to setup and run Higa macrosDo you know if the charting tool that is available in this pacakge is compatible with Excel 2007, if it is not, is there a place to get this tool for use with Excel 2007
426 Jul 2010 @ 05:48 PDTDatabaseReplyProblem with DBQLogTbl dataAMPCPUTime is the constant across any system if you need to gauge a SQL, the firstresptime - firststeptime will provide you with the elapsed time, the end user would experience as a response time a...
314 Apr 2010 @ 08:05 PDTToolsReplyTPT Stream Operator Bug?We've run into a similar issue and the COE for Informatica/TPT at Teradata should be able to provide guidance. From the last time I checked, the TPT API stream operator builds its own UPDATE strate...
214 Apr 2010 @ 07:13 PDTViewpointReplyWhat Teradata products would you like to see in Viewpoint?Currently there is a limitation within Teradata Manager when we put a user in the exception list and this list is 'Global' and any/all alert for this exception list is ignored. Would ViewPoint so...
114 Apr 2010 @ 07:09 PDTDatabaseReplyKilling IDLE sessions Automatically in teradata...Through Teradata Manager 'Sessions' Tab, you could configure the 'IDLE For(Minutes)' Rule based on number of minutes the session is IDLE.