Archives of the TeradataForum

Message Posted: Thu, 20 Sep 2007 @ 13:00:03 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: List of V2R6 Features

From:		Sanchez, Idrike

We are in the process of upgrading to V2R6. I have not been able to get my hands on any documentation regarding V2R6 features or differences between V2R5 and V2R6. I don't think the Teradata documentation site has anything either. Does anyone have any such documents that they can share?.

I ended up creating my own..

On our website I put a document with the text below. We went from V2R5.1 to V2R6.2. I did not find a document that listed the differences. However on advice from one of the technical writer for Teradata I reviewed the list of SQL features summary (Appendix E of the SQL Reference fundamentals manual) comparing the V2R6.0 which includes what is available in 5.1 vs the latest 6.2 version. The SQL difference part below is what I found.

I also to our internal website two 2006 partners presentations that talked about V2R6.2 (V2r62Warehouse82_technology_2006Partners_Walter_S6_Tue_930am.pdf & V2r60DatabaseOverview_2006Partners_Charucki_S12_Tue_800am.pdf)

----------------------------------------------

Key Features in Teradata Database V2R6.2 and Teradata Tools and Utilities 8.2

Performance

* Optimize USI Maintenance & Rollback Performance

* Optimize NUSI Rollback Performance

* PPI for Non-Compressed Join Index

* Simple Update Optimization

Active Enabled

* Improved Scandisk Performance

* Lift Combined In-List Value Limits

* Allow Triggers and Join Indexes on same table

Enterprise Fit

* Larger Decimal Support

* Big Integer Support

* Restrict logons to pre-defined IP addresses

* Auto generated key retrieval

* Improve Spool Space Accounting

* Implement New Password Encryption Algorithm

* Linux - Teradata based replication

* WS03 64-Bit Teradata Ready for EM64T

Ease of Use

* Create Table as... with statistics

* Enhance Alter Table to allow column compression

* DBQL - Log SQL Statement Type

* DBQL - Log Utility Objects

* DBQL - Log Failed SQL Query Text

* DBQL - Log Object Support for Macros, Views, Triggers, Stored

Procedures and UDF's

* UDF Packaging

* Support SQL Default Function

* Set Session Account Priority

Quality & Supportability

* Dispatcher Fault Isolation

* Write Ahead Logging (WAL)

SQL Differences from prior V2R5.1 version:

- ALTER METHOD

- ALTER PROCEUDRE (external form)

- ALTER REPLICATION GROUP

- ALTER TYPE

- BEGIN LOGGING ON TYPE

- COLLECT STAT (QCD form) SET QUERY, SAMPLEID, UPDATE MODIFIED options

- COLLECT STATS PARTITION column (Allows you to collect stats on partitions)

- COMMENT on GROUP, on METHOD

- CREATE AUTHORIZATION

- CREATE CAST

- CREATE FUNCTION language CPP

- CREATE FUNCTION RETURNS TABLE

- CREATE METHOD

- CREATE ORDERING

- CREATE PROCEDURE (external stored procedure form)

- CREATE REPLICATION GROUP

- CREATE TABLE QUEUE

- CREATE TRANSFORM

- CREATE TYPE (User defined types)

- CREATE RECURSIVE VIEW

- DUMP EXPLAIN CHECK STATISTICS

- GRANT REPLCONTROL

- GRANT UDTMETHOD\UDTTYPE\UDTUSAGE

- INSERT EXPLAIN USING SAMPLE PERCENT

- SELECT TOP

- SELECT .. FROM TABLE (function())

- SELECT AND CONSUME TOP 1 (Queues)

- SET ROLE EXTERNAL

- SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL

- SET SESSION OVERRIDE REPLICATION

- LOCK WITH RECURSIVE clause

- BIGINT data type

Kiki Sanchez
Data Warehouse Group
Technology Division
Continental Airlines


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference