119 | 27 Aug 2012 @ 12:48 PDT | Cloud Computing | Topic | Installing TDWM on Teradata VM | In 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... |
118 | 05 Jun 2012 @ 02:07 PDT | General | Reply | Teradata 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.
|
117 | 12 May 2011 @ 07:33 PDT | Database | Topic | Question on spool space | Spool 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... |
116 | 25 Sep 2010 @ 06:33 PDT | Database | Reply | UNIQUE vs DISTINCT | Here you go: http://carlosal.wordpress.com/2009/06/02/distinct-vs-group-by-en-teradata/ |
115 | 31 Aug 2010 @ 05:42 PDT | UDA | Reply | TASM Behaviour | As 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... |
114 | 31 Aug 2010 @ 05:08 PDT | Database | Reply | Spool treatment for DISTINCT versus GROUP BY | Nice 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. |
113 | 30 Aug 2010 @ 05:08 PDT | Database | Reply | Need 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... |
112 | 30 Aug 2010 @ 05:02 PDT | Database | Reply | Need 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) |
111 | 30 Aug 2010 @ 03:45 PDT | UDA | Reply | TASM Behaviour | Sorry 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... |
110 | 26 Aug 2010 @ 06:11 PDT | UDA | Reply | TASM Behaviour | It'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... |
109 | 26 Aug 2010 @ 05:25 PDT | Database | Reply | Handling the EMPTY/NULL value in the select query | one 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... |
108 | 18 Aug 2010 @ 06:38 PDT | Database | Reply | Daylight Saving Time (DST) and Time Zone | We 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... |
107 | 15 Aug 2010 @ 11:15 PDT | UDA | Reply | Converting Hot Standby Node to Active Node | I'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?? |
106 | 09 Aug 2010 @ 12:47 PDT | Database | Reply | How 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... |
105 | 02 Aug 2010 @ 04:36 PDT | Database | Reply | SQL History | Just 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 ... |
104 | 28 Jul 2010 @ 05:34 PDT | Database | Reply | Spool treatment for DISTINCT versus GROUP BY | Thanks 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... |
103 | 23 Jul 2010 @ 10:27 PDT | Database | Reply | Spool treatment for DISTINCT versus GROUP BY | Carlos, 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? |
102 | 23 Jul 2010 @ 09:44 PDT | General | Reply | How to know AMPs and Nodes list from teradata database from working application | Hi 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... |
101 | 23 Jul 2010 @ 12:49 PDT | Connectivity | Reply | Query banding within a single transaction | Thanks 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... |
100 | 21 Jul 2010 @ 11:15 PDT | Connectivity | Topic | Query banding within a single transaction | I 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 ... |
99 | 16 Jul 2010 @ 05:18 PDT | Database | Reply | synonyms | There's no synonym or alias equivalent in Teradata |
98 | 12 Jul 2010 @ 05:14 PDT | Marketing & CRM | Reply | C++ compiler | ramubindu, 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,... |
97 | 30 Jun 2010 @ 02:33 PDT | Database | Reply | DBC.ACCTG | CpuTimeNorm 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... |
96 | 30 Jun 2010 @ 03:17 PDT | General | Reply | T@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... |
95 | 22 Jun 2010 @ 08:37 PDT | Database | Reply | How to select values based on variable name and primary key using SQL | Try 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. |