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

TERADATA 15.10 DBSControl GENERAL Fields

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

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 ?

A node that is in the state DOWN/TDMAINT… Read More