Welcome! Teradata Developer Exchange is a community-oriented tech website that connects Teradata engineers with developers and customers who are building and deploying solutions on our platforms. Think of it as a digital community of technical experts sharing ideas, code, best practices and lessons on solving problems. Sounds great doesn't it? So sign up and join the community now!

Expand All Subscribe to Teradata Developer Exchange - All content The Latest
Unity Director 14.00 - Routing Rules

Unity Director 14.00 provides user and query routing between multiple Teradata systems. This satisfies two requirements – routing users to a system that has data to satisfy their queries and re-routing users during planned or unplanned system outages. Hence, end users receive the ultimate benefit of continuous, transparent access to data. In addition, Unity Director provides high availability, disaster recovery, and data synchronization for multiple Teradata systems. For more information on Unity Director 14.00 please follow the links provided at the end of this article.

In this article, I will provide details of various routing rules that can be created using Unity Director 14.00. One can choose from various routing rule modes Auto, Preferred and Balanced. I will be explaining how reads and writes can be configured in these modes.

Article by vineeta.v 1 week ago
Recommended Dictionary Statistics to Collect in Teradata 14.0

Collecting statistics on data dictionary tables is an excellent way to tune long-running queries that access multi-table dictionary views.  Third party tools often access the data dictionary several times, primarily using the X views.  SAS, for example, accesses DBC views including IndicesX and TablesX for metadata discovery.  Without statistics, the optimizer may do a poor job in building plans for these complex views, some of which are composed of over 200 lines of code.

In an earlier blog posting I discussed the value of collecting statistics against data dictionary tables, and provided some suggestions about how you can use DBQL to determine which tables and which columns to include.  Go back and review that posting.  This posting is a more comprehensive list of DBC statistics that is updated to include those recommended with JDBC.

Blog entry by carrie 1 week ago
Teradata Studio Express

Teradata Studio Express is an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop.

Training by STarnow 1 week ago
TASM State Changes are Streamlined in Teradata 14.0

A state matrix is a construct that allows you to intersect your business processing windows with the health conditions of your system.  Why should you care about this abstraction?  The state matrix in TASM is the mechanism that supports an automated change in workload management setup as you move through your processing day, or should your system become degraded.  Not only is it automatic, but it's a significantly more efficient way to make a change in setup while work is running.

Blog entry by carrie 1 week ago
How to use the Teradata JDBC Driver with R

JDBC support has been added to teradataR version 1.0.1 which provides the ability of using the Teradata JDBC Driver through teradataR to connect to the Teradata database.  teradataR allows R users to easily connect to a Teradata database and use statistical functions directly against the Teradata system without having to extract memory into data.  For more information on teradataR, refer to the teradataR User Guide.

Article by jjordan 2 weeks ago
Aster Client Tools

This package contains the Aster client tools.

Release 5.10.00.00  -  30 May 2013
The Revenge of Brick and Mortar

Darryl McDonald, President of Teradata Applications, tweeted this link today:  a practical example of when many of the subjects discussed on this blog come together. 

Blog entry by jgraas 3 weeks ago
Calculation of Table Hash Values to Compare Table Content

At the Partners 2012 I presented the session “How to compare tables between TD systems in a dual active environment” - see attached slides for details if of interest for you.

Blog entry by ulrich 4 weeks ago
Statistics Collection in Teradata 14.0

Statistics about tables, columns and indexes are a critical component in producing good query plans.

Training by STarnow 17 May 2013
Using the Apache Derby ij tool with the Teradata JDBC Driver

Oracle (Sun) JDK 6.0 and JDK 7.0 include the Apache Derby database, which is implemented in 100% Java. 

This article is not about the Apache Derby database; instead, this is about a command-line interactive SQL tool that is included with Apache Derby. 

The Apache Derby "ij" interactive SQL tool is quite useful. It is a command-line SQL tool similar to BTEQ, and it works with any JDBC Driver and any database, not just the Apache Derby database. 

The following instructions show how to use the ij tool with the Teradata JDBC Driver. 

Blog entry by tomnolan 15 May 2013

Pages