Downloads

Version: 16.10.00.05 - Created: 09 Sep 2019

Teradata Call-Level Interface Version 2 is a collection of callable service routines that provide the interface between applications and the Teradata Gateway. Gateway is the interface between CLI and the Teradata Database. This download package is for the HP-UX platform.

Version: tdbench-8.01.04 - Created: 06 Sep 2019

  TdBench is a tool designed to simulate realistic database workloads for applications and platforms.This tool can be used with any DBMS supporting JDBC to:Measure performance before vs after a change to add indexes, partitioning, compression, etcMeasure the impact to your DBMS of changes to settings, a patch, or a new software releaseSimulate a workload for a new application or a proof of conceptCompare the performance of one platform to anotherCompare performance of different data base vendor’s productsGetting Software and Help for TdBench:You can download the latest package of the TdBench jar file and setup information with scripts for Teradata and non-Teradata DBMSs from this page and unzip it in a directory on a server of PC with connectivity to your DBMSTerdata's JDBC driver is included.  Search the web for other vendor's JDBC drivers and save them on your server or PCAdditional DBMS setup scripts and information may be found at https://github.com/Teradata/tdbenchYou can submit issues, questions or contribute DBMS setup information at https://github.com/Teradata/tdbench/discussionsManuals, white papers and videos are reference at the bottom of this page. What does TdBench do?TdBench simulates realistic production systems by allowing definition of the different types of work and adjusting the number of concurrent executions for each type of work;It captures the results each query execution in its internal database.It facilitates analysis host DBMS resource consumption by maintaining test metadata on the host DBMS to join with its query logs.Tests are defined with:queues of SQL queries and scripts or OS commandsvariable number of execution threads (workers) per queuecommands to pace queries by time or percentageparameterized queries to simulate different usersoptional query prepare reducing DBMS parsingscheduled start of processes or individual queriesFixed work or fixed period execution modelsScripting language to automate multiple testsTests can be defined as simply as 4 statements. Analysis capabilities have been used to track individual query performance over hundreds of runs during projects with constraints like:WHERE RunID in (79, 81, 105)Example:  Basic test of all queries in 1 worker session:define serial Test of queries executed seriallyqueue thequeries scripts/queries/*.sqlworker thequeries mydbmsrunExample:  Fixed period test of 10 minutes with 2 queues and a total of 5 worker sessions:define workload5 Test of 1 heavy and 4 reporting worker sessionsqueue hvy scripts/queries/hvy*.sqlworker hvy mydbms 1queue rpt scripts/queries/rpt*.sql;worker rpt mydbms 4run 10mThere are nearly 60 commands for defining and scripting multiple tests.  You could use:the PACE command with an interval reference command to control arrival of queries on a queue, orPACE with a percentage  to limit the percentage of total queries executed from one queue, orAT command to schedule events, or QUERY LIST to replay query starting as the executed in production There are built-in variables, user variables, IF and GOTO statements.There are 69 built-in help files and a TdBench 8.01 User Guide to help you get started.TdBench Documentation:TdBench 8.01 User GuideTdbench 8.01 Tri-Fold Command ReferenceWhite Papers:1-Page Essential Guide to Benchmarks for ExecutivesEssential Guide to Benchmarks for DBAsBenchmark DeceptionBenchmark Deception And How to Avoid Benchmark TricksVideos:TdBench Overview  - Why it was created and what it does (0:10:09)TdBench Command Language - Shows how to construct tests using the TdBench command language (0:14:19)Design of a Good Platform Benchmark - Training session on constructing a benchmark or POC that models realistic database workloads to compare platforms (0:41:33)

Version: 16.10.00.10 - Created: 28 Jan 2019

The ODBC Driver for HP-UX allows you to connect to the Teradata database from HP-UX applications. To get started, see the README files. You can get community support for this download in the Connectivity forum.

Version: 07.00.03.00 - Created: 16 Jan 2019

This package contains the Aster Analytics POC Functions

Version: 07.00.03.00 - Created: 16 Jan 2019