Advanced SQL Engine 17.10 | Utilities| Changes & Additions | Teradata Vantage - Changes and Additions - Advanced SQL Engine

Advanced SQL Engine 17.10 | Utilities| Changes & Additions | Teradata Vantage - Changes and Additions - Advanced SQL Engine - Teradata Database

Database Utilities

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

xha1591998860283.ditamap

dita:ditavalPath

xha1591998860283.ditaval

dita:id

B035-1102

lifecycle

Product Category

Teradata Vantage™

Date	Description
July 2021	New DBS Control General fields FastAlterDefault and FastAlterEnable. New DBS Control Native Object Store fields ForeignTableErrorsData and ForeignTableErrorsLimit. New MAXSESSIONS, SCOPE { DICTIONARY \| USER \| ALL } options for CheckTable (checktable) New LOCAL option for SHOWCYLALLOC and SHOWWHERE. Updated syntax description of the IN PARALLEL option for REBUILD AMP and REBUILD AMP FALLBACK TABLES to show the increased number of parallel streams and to say that multiple tables can be rebuilt in parallel. These utilities can be run from the Linux command line: Abort Host (aborthost) Query Configuration (qryconfig) Query Session (qrysessn) Recovery Manager (rcvmanager) Show Locks (showlocks) Update DBC (updatedbc) Update Space (updatespace) TLSv1.2 is now supported between clients and the database server. New options are added to gtwglobal to update the TLS configuration from the gateway TLS configuration. See Gateway Global (gtwglobal). New option (--TLS) is added to gtwcontrol to enable or disable TLSv1.2 and trace the protocol. See Gateway Control (gtwcontrol). Fallback subtables are no longer compressed by default.
June 2020	DBS Control: New Performance field, DBQL_AWTDPS_CacheMaximum. New Optimizer Stats field, BLCStatsForCDS Ferret: New PERVPROC option for Ferret SHOWBLOCKS command.

Date

Description

July 2021

New DBS Control General fields FastAlterDefault and FastAlterEnable.
New DBS Control Native Object Store fields ForeignTableErrorsData and ForeignTableErrorsLimit.
New MAXSESSIONS, SCOPE { DICTIONARY | USER | ALL } options for CheckTable (checktable)
New LOCAL option for SHOWCYLALLOC and SHOWWHERE.
Updated syntax description of the IN PARALLEL option for REBUILD AMP and REBUILD AMP FALLBACK TABLES to show the increased number of parallel streams and to say that multiple tables can be rebuilt in parallel.
These utilities can be run from the Linux command line:
TLSv1.2 is now supported between clients and the database server.
- New options are added to gtwglobal to update the TLS configuration from the gateway TLS configuration. See Gateway Global (gtwglobal).
- New option (--TLS) is added to gtwcontrol to enable or disable TLSv1.2 and trace the protocol. See Gateway Control (gtwcontrol).
Fallback subtables are no longer compressed by default.

June 2020

DBS Control:
- New Performance field, DBQL_AWTDPS_CacheMaximum.
- New Optimizer Stats field, BLCStatsForCDS
Ferret:
- New PERVPROC option for Ferret SHOWBLOCKS command.