There can be different scenario’s where Teradata database needs to be stopped and started by database administrator or the database restarted automatically. So there …
Read More »TERADATA
Why is so much data being written into DBQL?
There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …
Read More »DBQL rules – QUERY LOGGING
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-6703e5be2b220368016392/] Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be …
Read More »Hash Functions to Identify Skewed Data
On day to day activity we often get situation when the database has a lot of space left but query fails with “2644: No …
Read More »How To Configure Viewpoint Service In Teradata
To configure Viewpoint follow below steps: [crayon-6703e5be2b6e0593137656/] After running the above steps then do the below service restart: [crayon-6703e5be2b6e4388734455/] Teradata Alerts contains …
Read More »Creating an ODBC Connection to Teradata for Excel
Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example, the Operating System was Windows …
Read More »Teradata Query Grid : Connection with different systems ( Database , NoSQL , Hadoop )
Teradata 15.0 has come up with many new exciting features and enhanced capabilities . Teradata Query Grid is one of them. Teradata database now able …
Read More »Primary index concept in Teradata
Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …
Read More »Teradata – Secure Zones
Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides the following business value: Improves …
Read More »Teradata – Architecture
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET and Access Module Processors (AMPs). …
Read More »