Teradata Mainframe Client Utilities update

Article by steveg on 10 May 2012 0 comments

Tags:

Teradata has completed a major compiler conversion effort that should be completely transparent to customers, yet they are the main beneficiaries. This article:

Provides some historical background and context,
Discusses the reasons we switched compilers,
Identifies certain behavioral changes that were unavoidable,
And, finally, answers a few technical questions related to the overall process.

The venerable IBM mainframe was the original client platform developed for the Teradata RDBMS via channel-attached connections way back in the 1980s. Although we now support a wide range of client platforms using network-attached connections, a significant segment of our customer base continues to use mainframe clients.

You must sign in to leave a comment.

lasca.js, custom Unicode sorting for internationalized web applications

Blog entry by JasonStrimpel on 10 May 2012 0 comments

Tags:

A common problem with web applications is that sorting results are inconsistent between the front-end and back-end because the browser and server collation tables differ. These differences force a developer to do all sorting either in the front-end or back-end, which is not very good solution. An application should not have to pay a penalty of a network call just to sort and the server should not get pinged for every sort either. A developer should have the ability to select the best solution for a given problem.

You must sign in to leave a comment.

A reliable rebooting mechanism for Data Mover Services

Article by yeyuancn on 09 May 2012 1 comment

Tags:

Data Mover is a Teradata Application that allows users to copy databases or tables between Teradata systems. It is a JEE based application that is composed of three major code components: the Client (Command-line interface or Viewpoint portlet), the Daemon, and the Agent. The Daemon is the central piece of the application and the Agent is a worker unit that does the actual job of moving data. Both the Damon and the Agent are deployed in a Linux managed server.

The Life of a Teradata Query

09 May 2012 0 comments

Tags:

This presentation will follow a Teradata SQL query from its origin at the client...

Audience:

Data Warehouse Administrator, Data Warehouse Application Specialist,Data Warehouse Architect/Designer

Training details

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Course Number:

49876

Training URL:

http://www.teradata.com/t/ten/

Training Format:

Recorded webcast

Price:

$195

Credit Hours:

Using Aster Express: Act 3, On the Road to nPath

Article by Teradata Mike on 08 May 2012 1 comment

Tags:

aster
npath

The foundations of the Aster platform are a parallel database with all the features you'd expect from a SQL platform. However the power of the Aster platform really shines once you start using its library of SQL-MR analytic components. With these components, complex data analysis that is difficult to code in SQL becomes much, much easier. A clear example of this can be seen with Aster's nPath module.

.NET Data Provider Reference

Reference by devxadmin on 03 May 2012 0 comments

Tags:

The following reference documentation is available:

.NET Data Provider 14.00 Web Help - contains Developer's Guide and Developer's Reference

.NET Data Provider 13.11 Web Help - contains Developer's Guide and Developer's Reference

DBQL Scripts

Release 2012.02.10, 2012.05.03 - 03 May 2012

Tags:

DBQL TD 13.x to TD 14.0 Data Migration Script

Version:	2012.05.03
Released:	03 May 2012
Teradata:	14.0, 13.10, 13.0

DBQL_TD13x_to_TD14_Data_Migration_Scripts.zip

Teradata 14.0 DBQL Setup and Maintenance Guide

Version:	2012.05.03
Released:	03 May 2012
Teradata:	14.0

TD14_DBQL_setup_and_maintenance.pdf

Teradata 13.0 and 13.10 DBQL Setup and Maintenance Guide

Version:	2012.02.10
Released:	10 Feb 2012
Teradata:	13.10, 13.0

TD13_0_and_TD13_10_DBQL_logging_and_maintenance.pdf

DBQL TD 13.x to TD 14.0 Data Migration Script

Version:	2012.05.03
Released:	03 May 2012
Teradata:	14.0, 13.10, 13.0

DBQL_TD13x_to_TD14_Data_Migration_Scripts.zip

DBQL Setup and Maintenance Scripts for Teradata V2R6

Version:	2012.02.10
Released:	10 Feb 2012
Teradata:	V2R6.2, V2R6.1, V2R6.0

The DBQL setup and maintenance document provides scripts, as well as information on how to perform DBQL logging and maintenance, for Teradata Database V2R6.x.

V2R6_x_DBQL_logging_and_maintenance.pdf

Other Releases

Package	Version	Released	Teradata	Download
DBQL V2R6 to TD13.0 and TD13.10 Data Migration Script	2012.02.10	10 Feb 2012	13.10 13.0 V2R6.2 V2R6.1 V2R6.0	DBQL_V2R6_to_TD13_0_and_TD13_10_Migration_script.sql.zip
DBQL V2R6 to TD12 Data Migration Script	2012.02.10	10 Feb 2012	12.0 V2R6.2 V2R6.1 V2R6.0	DBQL_V2R6_to_TD12_Data_Migration_script.sql.zip
DBQL Setup and Maintenance Scripts for Teradata 12.0	2012.02.10	10 Feb 2012	12.0	TD12_DBQL_logging_and_maintenance.pdf
DBQL Setup and Maintenance Scripts for Teradata V2R6	2012.02.10	10 Feb 2012	V2R6.2 V2R6.1 V2R6.0	V2R6_x_DBQL_logging_and_maintenance.pdf

About this download

The DBQL setup and maintenance documents provides scripts, as well as information on how to perform DBQL logging, maintenance, and upgrade, now including Teradata 14.0.

Episode IV: A New Platform (Backbone.js + Require.js)

Blog entry by JasonStrimpel on 03 May 2012 0 comments

Tags:

This is the final installment of a four part series on modularizing the Backbone.js Todos application using Require.js. It examines porting the application to the Pokki platform.

You must sign in to leave a comment.

.NET Data Provider for Teradata

Release 14.00.00.00 - 01 May 2012

Tags:

.NET Data Provider 14.00.00.00

Version:	14.00.00.00
Released:	01 May 2012
TTU:	14.0
OS:	Windows i386 (32-bit), Windows x86-64 (64-bit)
Teradata:	14.0, 13.10, 13.0, 12.0, V2R6.2

tdnetdp__windows_indep.14.00.00.00.exe

README

WINDOWS HELP

Other Releases

Package	Version	Released	TTU	OS	Teradata	Download
.NET Data Provider 13.11.00.01	13.11.00.01	29 Jun 2011	13.10	Windows i386 (32-bit) Windows x86-64 (64-bit)	13.10 13.0 12.0 V2R6.2 V2R6.1	tdnetdp__windows_indep.13.11.00.01.exe README WINDOWS HELP
.NET Data Provider 13.01.00.04	13.01.00.04	20 Oct 2010	13.0	Windows i386 (32-bit) Windows x86-64 (64-bit)	13.0 12.0 V2R6.2 V2R6.1	tdnetdp__windows_indep.13.01.00.04.exe README Release Definition Windows Help
.NET Data Provider 12.00.01.01	12.00.01.01	13 Oct 2010	12.0	Windows i386 (32-bit) Windows x86-64 (64-bit)	13.0 12.0 V2R6.2 V2R6.1 V2R6.0	tdnetdp__windows_indep.12.00.01.01.exe README Release Definition

About this download

The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET specification. It provides direct access to the Teradata Database and integrates with the DataSet. .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.

9.2 Quintillion? What's that all about?

Blog entry by PaulSinclair on 29 Apr 2012 0 comments

Tags:

A quintillion is 10 raised to the power of 18 (that is, 1 followed by 18 zeros). 9.2 quintillion (or more precisely, 9,223,372,036,854,775,807) is the new limit in Teradata Database 14.0 for the number of combined partitions. Note that this is the same as the maximum BIGINT value (which is a signed 8-byte integer). While tables that are defined with 65535 or less combined partitions still use 2-byte partitioning, if the number of defined combined partitions exceeds 65535 for a table, the table is created with 8-byte partitioning.

You must sign in to leave a comment.