Downloads

Version: 2012.02.13 - Created: 13 Feb 2012

Teradata 13.10 features Block Level Compression (BLC), which provides the capability to perform compression on whole data blocks at the file system level before the data blocks are actually written to storage. Like any compression features, BLC helps save space and reduce I/O. This BLC utility is for Teradata users to run against TD 13.10 system to select the list of BLC candidate tables and evaluate BLC impact on space and speed for each specific table in interest, to get information for selecting appropriate tables to apply BLC. To learn how to use the BLC Utility package, please see the article Block Level Compression evaluation with the BLC utility.   For community support for this package, please visit the Extensibility Forum.

Version: 14.00.00.00 - Created: 13 Jul 2011

ODBC Learning Examples are a suite of applications designed to provide an informative guide to developing ODBC applications as well as providing simple building blocks for ODBC applications. Please see the ODBC Learning Examples article for details on usage.

Version: 1.0.0.2 - Created: 12 Nov 2010

The ALC (ALgorithmic Compression) test package contains UDFs simulating TD13.10 built-in compression functions, test templates for Latin and Unicode character columns and step-by-step instructions. It is intended for TD users to run over specific data at column level to determine compression rates of TD 13.10 built-in compression algorithms. The test results provide information for selecting an appropriate algorithm for specific data. These tests use read-only operations and they can be executed on any release that supports UDFs (V2R6.2 & forward). It is recommended to run these tests off peak hours - they will use a significant amount of system resources (CPU bound). Usage To learn how to install and use the test package, please see Selecting an ALC compression algorithm. For community support for this package, please visit the Extensibility forum.

Version: 5.00 - Created: 26 Oct 2010

New Release!! TdBench V7.2 is now available for Linux at http://downloads.teradata.com/download/tools/tdbench7-2 TdBench 5.0 Description (MS DOS version from 2010) This package provides a framework for executing benchmarks driven by a Windows Server or PC and reporting on the results using DBQL. There are also tools for extracting a cohesive set of queries and tables from DBQL to define the benchmark. TdBench helps you compare performance within a data warehouse: before/after a new release of the DBMS before/after changes to the PDM (indexes, compression, etc) relative performance of a new database platform To get started, please read the Teradata Benchmark Query Driver reference. These tools are provided free of charge in the belief that good benchmarks are an accurate reflection of your real or planned production load. If Teradata customers and prospects can do a better job of executing such tests with the use of this software, they will be able to make better decisions on selection of tools, planning for rollout, and managing system growth. For community support, please visit the Tools forum.

Version: 1.0 - Created: 07 Jun 2010

Starting from TD 13.10, Teradata DIPUDT script creates the SQLRestrictedWords_TBF function and the SQLRestrictedWords view in the SYSLIB database that allow users and client products to query for Teradata SQL Restricted words. For previous releases, we provide this package online for you to download and install the same table function and create view for the specific release of your server. Please start by reading the README (also included in the download package). For community support for UDFs, please visit the Extensibility forum. README ****************** * * * Introduction * * * ****************** Starting from TD 13.10, Teradata Database has a new feature that allows users and client products to query Teradata Restricted words. It requires running DIPUDT or DIPALL to get the feature enabled, i.e., to get a table UDF SYSLIB.SQLRestrictedWords_TBF installed and a view SYSLIB.SQLRestrictedWords created, and to grant appropriate access rights to users. For previous releases, we provide this UDF package online for you to download and install the same table function and create view for the specific release of your DB server. The following instructions guide you to do so step by step. ================================================================================= Step 1 Install table function SYSLIB.SQLRestrictedWords_TBF() ============================================================================= Step 1.1 Open the package and extract all files to c:/temp in your client machine from which you will run bteq. ============================================================================= Step 1.2 Go to folder c:/temp/udfrestrictedwords/, you will see folders for different operating systems: linux, mpras, win32 and win64; go to the folder that is the same as your DB server OS, you will see the UDF object file: udfsqlrestrcitedwords.o. ============================================================================= Step 1.3 Start BTEQ from the above folder, logon as DBC and run the following REPLACE FUNCTION script to install the table UDF. REPLACE FUNCTION SYSLIB.SQLRestrictedWords_TBF () RETURNS TABLE ( restricted_word VARCHAR(30) CHARACTER SET LATIN, release_introduced CHAR(5) CHARACTER SET LATIN, release_dropped CHAR(5) CHARACTER SET LATIN, category CHAR(1) CHARACTER SET LATIN, ANSI_restricted CHAR(1) CHARACTER SET LATIN) LANGUAGE C NO SQL DETERMINISTIC PARAMETER STYLE SQL EXTERNAL NAME 'CO!udfsqlrestrictedwords!udfsqlrestrictedwords.o'; You can ignore: "*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT." ============================================================================= Step 1.4 Verify the table UDF is installed correctly. HELP FUNCTION SQLRestrictedWords_TBF (); sel count(*) from table (SQLRestrictedWords_TBF()) as t1; ================================================================================= Step 2 Create view SYSLIB.SQLRestrictedWords for specific release of your DB server over table function SYSLIB.SQLRestrictedWords_TBF() If your server is of TD 13.0 release, run: CREATE VIEW SYSLIB.SQLRestrictedWords AS SELECT restricted_word, category, ANSI_restricted FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '13.00' AND (release_dropped IS NULL OR release_dropped > '13.00'); If your server is of TD 12.0 release, run: CREATE VIEW SYSLIB.SQLRestrictedWords AS SELECT restricted_word, category, ANSI_restricted FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '12.00' AND (release_dropped IS NULL OR release_dropped > '12.00'); If your server is of TD 6.2 release, run: CREATE VIEW SYSLIB.SQLRestrictedWords AS SELECT restricted_word, category, ANSI_restricted FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '06.02' AND (release_dropped IS NULL OR release_dropped > '06.02'); ================================================================================= Step 3 Verify view SYSLIB.SQLRestrictedWords is created correctly. show view SYSLIB.SQLRestrictedWords; sel count(*) from SYSLIB.SQLRestrictedWords; ================================================================================= Step 4 Grant appropriate access rights to users grant execute function on syslib.SQLRestrictedWords_TBF to public; grant select on syslib.SQLRestrictedWords to public; ================================================================================= Step 5 Logon as a non-dbc user, verify non-dbc users can execute the table function and select from the view. HELP FUNCTION SQLRestrictedWords_TBF (); sel count(*) from table (SQLRestrictedWords_TBF()) as t1; show view SYSLIB.SQLRestrictedWords; sel count(*) from SYSLIB.SQLRestrictedWords; ****************** * * * Sample Usages * * * ****************** ================================================================================= 1 Get the Restricted Words list specific for the your DBS version Use the view directly: SELECT * FROM SYSLIB.SQLRestrictedWords; ================================================================================= 2 Get the Restricted Words list for specific versions using the table UDF Use the table UDF SQLRestrictedWords_TBF with conditions for the specific version in interest. For instances: ============================================================================== 2.1 Get all restricted words in TD 13.10: SELECT * FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '13.10' AND (release_dropped IS NULL OR release_dropped > '13.10'); ============================================================================== 2.2 Get all restricted words in TD 13.0: SELECT * FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '13.00' AND (release_dropped IS NULL OR release_dropped > '13.00'); ============================================================================== 2.3 Get all restricted words in TD 12.0: SELECT * FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '12.00' AND (release_dropped IS NULL OR release_dropped > '12.00'); ============================================================================== 2.4 Get all restricted words in TD 6.2: SELECT * FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '06.02' AND (release_dropped IS NULL OR release_dropped > '06.02'); ****************** * * * NOTES * * * ****************** ================================================================================= Note 1: If you want to remove the table UDF and the view, you can run the following from DBC: DROP FUNCTION SYSLIB.SQLRestrictedWords_TBF (); DROP view SYSLIB.SQLRestrictedWords; ================================================================================= Note 2: If you drop the table UDF after you complete all steps and then re-install it following Step 1, you will also need to complete all the steps 2 ~ 4 in order to get the view and the table UDF working properly for non-dbc users.