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
There can be different scenario’s where Teradata database needs to be stopped and started by database administrator or the
There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access
1 |
select * from DBC.DBQLRuleTbl; |
Note: View DBC.DBQLRules
On day to day activity we often get situation when the database has a lot of space left but
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:
Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example,
Teradata 15.0 has come up with many new exciting features and enhanced capabilities . Teradata Query Grid is one of
Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is
Secure Zones This feature supports grouping of users, databases, and database objects into Secure Zones. Business Value This feature provides
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET