#DateForumTypeThreadPost
11927 Aug 2012 @ 12:48 PDTCloud ComputingTopicInstalling TDWM on Teradata VMIn non-VM Teradata we used to have the 'Teradata Dynamic Workload Manager' setup in the 'Teradata Tools and Utilities' media. The Teradata VM for Linux consists of a prepackaged Te...
11805 Jun 2012 @ 02:07 PDTGeneralReplyTeradata 14 VMWare Image availability Any idea if there is going to be a package available for EC2 for Teradata 14? As far as I know the latest one available for Amazon EC2 is the Teradata 13.10.
11712 May 2011 @ 07:33 PDTDatabaseTopicQuestion on spool spaceSpool space is used in different steps of a query. If we run an explain on a query there maybe multiple steps and spools used in them. Question is that the maximum spool used by the query is com...
11625 Sep 2010 @ 06:33 PDTDatabaseReplyUNIQUE vs DISTINCTHere you go: http://carlosal.wordpress.com/2009/06/02/distinct-vs-group-by-en-teradata/
11531 Aug 2010 @ 05:42 PDTUDAReplyTASM BehaviourAs far as I know there are no ageing settings for your purpose. There are settings for logging, event intervals though but they don't effect your situation. Could it be that the SysCon/OpEnv chang...
11431 Aug 2010 @ 05:08 PDTDatabaseReplySpool treatment for DISTINCT versus GROUP BYNice findings Karam. It could've been introduced in Teradata 13 as the awards were held in 2009. Maybe the engineer himself could shed some light on the topic.
11330 Aug 2010 @ 05:08 PDTDatabaseReplyNeed a standard approach for deleting DBQLSQLTBL records...This should help for Teradata V2R6 and 12 respectively: http://downloads.teradata.com/download/database/dbql-setup-and-maintenance-scripts-for-teradata-database-v2r6-x http://downloads.teradata.c...
11230 Aug 2010 @ 05:02 PDTDatabaseReplyNeed a standard approach for deleting DBQLSQLTBL records...You can have a look under the topic 'DBQL Setup and Maintenance' in Chapter 4 of 'Performance Management' (1097)
11130 Aug 2010 @ 03:45 PDTUDAReplyTASM BehaviourSorry Umer but I could not understand your query clearly. Could you please elaborate what you are referring to as a job? and what do you mean by 'I want TASM to check settings every 10 secs.'? whic...
11026 Aug 2010 @ 06:11 PDTUDAReplyTASM BehaviourIt's a very internal question I guess and depends a lot on TASM internals and many factors: your TASM rules, filters, limits/thresholds for the load running on your system. Other than that are y...
10926 Aug 2010 @ 05:25 PDTDatabaseReplyHandling the EMPTY/NULL value in the select queryone ugly approach is to use UNION to select a hardcoded value which you won't expect in your normal results e.g. -1, then use your case approach. e.g. SELECT CASE WHEN u.val = -1 then 0 else val...
10818 Aug 2010 @ 06:38 PDTDatabaseReplyDaylight Saving Time (DST) and Time ZoneWe queried Teradata on this issue as well but there was no elegant way while using the DB. One way that they suggested was to use the BTEQ to print out the timezone information on the system (in so...
10715 Aug 2010 @ 11:15 PDTUDAReplyConverting Hot Standby Node to Active NodeI've worked with HSN on clients but don't know the answer to your question. I am also interested in the answer to it. Forum members??
10609 Aug 2010 @ 12:47 PDTDatabaseReplyHow to enable TDWM on Teradata Express 13 (Windows 32 bit)When you ran the Database setup using the TD Manager, did you receive any errors? If yes, then its likely that your TDWM isn't setup properly. See the error logs for TD manager or rerun it. Most co...
10502 Aug 2010 @ 04:36 PDTDatabaseReplySQL HistoryJust to add a bit to Dieter's answer: - Is my view QryLog instantly refreshed ? >The data is collectec in buffers which are flushed regularly (not later than 10 minutes by default) It depends ...
10428 Jul 2010 @ 05:34 PDTDatabaseReplySpool treatment for DISTINCT versus GROUP BYThanks for the very detailed information Dieter. Can you guys shed some light on how you determine these in-depth version changes e.g. in this case, the TD13 optimizer automatically deciding on GRO...
10323 Jul 2010 @ 10:27 PDTDatabaseReplySpool treatment for DISTINCT versus GROUP BYCarlos, thanks for sharing this very good blog post. I have one question: why do you say "at least until 12"? Have things changed in Teradata architecture to improve this performance difference?
10223 Jul 2010 @ 09:44 PDTGeneralReplyHow to know AMPs and Nodes list from teradata database from working applicationHi Chandu, welcome to the Teradata forums. To find out the node list: sel distinct NodeId from DBC.ResUsageSpma; To find out AMP count in the whole Teradata system: sel hashamp()+1; To l...
10123 Jul 2010 @ 12:49 PDTConnectivityReplyQuery banding within a single transactionThanks a lot Tom, I highly appreciate your descriptive explanation and looking into the matter. I, on the other hand cannot call the transaction commit right after executing the query band SQL b...
10021 Jul 2010 @ 11:15 PDTConnectivityTopicQuery banding within a single transactionI tried to issue the query banding statement along with my SQL query in a single transaction, like: SET QUERY_BAND='AppName=B;'FOR Session;SELECT .... This ran successfully in the Teradata SQL ...
9916 Jul 2010 @ 05:18 PDTDatabaseReplysynonymsThere's no synonym or alias equivalent in Teradata
9812 Jul 2010 @ 05:14 PDTMarketing & CRMReplyC++ compilerramubindu, are you asking your question in context of this topic (C++ Compiler)? or is it a general query about Teradata housekeeping? If it's the latter then look into regular purging of ResUsage,...
9730 Jun 2010 @ 02:33 PDTDatabaseReplyDBC.ACCTGCpuTimeNorm is the normalized time of the CPU which considers the NNF of the Node of your Teradata system. CpuTime is approximately equal to CpuTimeNorm / (ResUsage.NodeNormFactor/100) Units in...
9630 Jun 2010 @ 03:17 PDTGeneralReplyT@YS new design?Yesterday I created a new incident for the first time since the new outlook of the T@YS. They have now broken the incident details steps into different pages and it is cumbersome to go through mult...
9522 Jun 2010 @ 08:37 PDTDatabaseReplyHow to select values based on variable name and primary key using SQLTry using the CASE expression when joining both the tables. Of course it won't be a feasible solution if you have too many columns in table 1.

Pages