ABBREVIATIONS IN TERADATA Hi Readers, This article contains all the abbreviations in Teradata. AccessRight Column Value Description AE ALTER EXTERNAL PROCEDURE AF ALTER FUNCTION AP ALTER PROCEDURE AS ABORT SESSION CA CREATE AUTHORIZATION CD CREATE DATABASE CE CREATE EXTERNAL PROCEDURE CF CREATE FUNCTION CG CREATE… Read More
Purpose of COALESCE expression Dear Readers, In this article you will get to know the Purpose of COALESCE expression It is used for NULL Handling. In the COALESCE expression, a list of arguments is passed. It is used to check if the arguments are NULL.… Read More
TBBLC ( Temperature based block level compression ) in TERADATA Dear Readers. In this article ,we will see TBBLC ( Temperature based block level compression ) in TERADATA About You can specify that data is automatically compressed if it is COLD (infrequently accessed) and automatically… Read More
TERADATA 16.20 DBSCONTROL COMPRESSION FIELDS Dear Readers, In this article you will get to know the TERADATA 16.20 DBSCONTROL COMPRESSION FIELDS DBS Control Record – Compression (Block Level) Fields: 1. BlockLevelCompression … Read More
How to create a new contiguous map which is subset of an existing contiguous map? Dear Readers, In this article you will get to know the How to create a new contiguous map which is subset of an existing contiguous map? Let us consider the… Read More
QUEUE TABLES Dear Readers, In this article you will get to know the QUEUE TABLES What is a Queue table ? It is a Teradata extension to ANSI SQL at the database/ table level. It is used to handle queue-oriented data, such as event processing and… Read More
Restricted Words In Teradata Dear Readers, In this article you will get to know the Restricted Words in Teradata. What are restricted words ? Teradata Database and ANSI/ISO SQL standards restrict the use of certain words as identifiers because thosewords may be incorrectly interpreted as… Read More
TERADATA 16.20 dbscontrol General fields Dear Readers, In this article you will get to know the TERADATA 16.20 dbscontrol General fields DBS Control Record – General Fields: 1 Version 11 2 SysInit TRUE(2020-05-14 1357) 3 DeadLockTimeout 240 (Seconds) 4 (Reserved for future use) 5 HashFuncDBC 6… Read More
TERADATA 16.20 DBSCONTROL CHECKSUM FIELDS Dear Readers, In this article you will get to know the TERADATA 16.20 DBSCONTROL CHECKSUM FIELDS DBS Control Record – Disk I/O Integrity Fields: System Tables … Read More
TERADATA 15.10 DBSControl GENERAL Fields Dear Readers, In this article you will get to know the TERADATA 15.10 DBSControl GENERAL Fields DBS Control Record – General Fields: 1. Version – This field is the version number of the DBS Control Record. It is incremented by 1… Read More
TERADATA 16.20 DBSCONTROL STATISTICS FIELDS Dear Readers, In this article you will get to know the TERADATA 16.20 DBSCONTROL STATISTICS FIELDS DBS Control Record – Optimizer Statistics Fields: DefaultTimeThreshold = 0 (Disabled;… Read More
Performance Fields in Teradata 15.10 Dear Readers, In this article you will get to know the Performance Fields in Teradata 15.10 DBS Control Record – Performance Fields: 1. DictionaryCacheSize – This field defines the size of the dictionary cache for each PE Vproc on the system.… Read More
PDE state – DOWN/TDMAINT Dear Readers, In this article you will get to know the PDE state : DOWN/TDMAINT When running the command “pdestate -a”, the node shows PDE state of DOWN/TDMAINT. What does it mean ? # pshpdestate -a byn001-8 byn001-9 byn001-10 byn002-8 byn002-9 byn002-10… Read More
Password Expiration in Teradata Dear Readers, In this article you will get to know the Password Expiration in Teradata In order to maintain the active users in the Database, Teradata DBA will set the password expiration interval like 90 days/120 days in the DBC tables. So,… Read More
Optimizer Statistics Fields IN TD 14.10 & 15.0 Dear Readers, In this article you will get to know the Optimizer Statistics Fields IN TD 14.10 & 15.0 DBS Control Record – Optimizer Statistics Fields: 1. DefaultTimeThreshold = 0 (Disabled; Default value) 2.DefaultUserChangeThreshold = 0 (Disabled;… Read More
Optimizer Statistics Fields IN 15.10, 16.0, 16.10 Dear Readers, In this article you will get to know the Optimizer Statistics Fields IN 15.10, 16.0, 16.10 Below are the optimizer statistics fields in DBSControl settings for the three Teradata Database versions. TERADATA 15.10, 16.0 & 16.10 Enter… Read More
NEW FEATURES INTRODUCED IN TERADATA DIFFERENT VERSIONS Dear Readers, In this article you will get to know the NEW FEATURES INTRODUCED IN TERADATA DIFFERENT VERSIONS New Features in Release 16.20 Bulk Qualification Enhancements CSV Storage Format for the DATASET Data Type Facility To Save Crashdump… Read More
LOB Functions Dear Readers, In this article you will get to know the LOB Functions LOB function deals with the below two functions 1.BLOB function for BLOB(Binary Large Object) data types 2.CLOB function for CLOB(Character Large Object) data types BLOB function : EMPTY_BLOB CLOB function… Read More
Information ON MAPS Dear Readers, In this article you will get to know the Information ON MAPS Let’s see few considerations to keep in mind when using /enabling MAPs. What will be the impact to the system? The Teradata MAPS feature introduces a new database… Read More
Get BLC compression ratio using SQL Dear Readers, In this article you will get to know the Get BLC compression ratio using SQL With the help of two macros introduced by Teradata Database 15.00, we can get similar functionality as that of Ferret SHOWBLOCKS feature… Read More
