Articles

ABBREVIATIONS IN TERADATA

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

QUEUE TABLES

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

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

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

Performance Fields in Teradata 15.10

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

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

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

LOB Functions in Teradata

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

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

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

More Latest News »