How To Start and Stop Teradata Database
There can be different scenario’s where Teradata database needs to be stopped and started by database administrator or the
Category: 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
DBQL rules – QUERY LOGGING
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access
1 | select * from DBC.DBQLRuleTbl; |
Note: View DBC.DBQLRules
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
How To Configure Viewpoint Service In Teradata
To configure Viewpoint follow below steps:
1 2 3 4 5 | export JAVA_HOME=/usr/java/jdk1.6.0_16/jre cd /var/opt/teradata/<viewpoint-xx.xx.xx.xx>/bin ./catalina.sh start |
After running the above steps then do the below service restart:
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,
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
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
Teradata – Secure Zones
Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides
Teradata – Architecture
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET