Category: TERADATA

27 Oct by Sharib Hussain Tags: , , , ,

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 database restarted automatically. So there are basically two types of restarts: Scheduled restarts : User may input command to bring the database down for maintenance or software patch upgrades and bring it up and running once […]
21 Sep by Jaime Eduardo Carvajal Silva

Introduction to Teradata

Teradata is one of the most trusted data warehousing (DWH) platforms with the best implementation in the world, it is characterized by its speed and stability in large volumes of data for this uses parallel architecture, distributing the data and balancing the workload so automatic The ease of use of Teradata, along with the power of its […]
10 Sep by Saumya Maurya Tags: ,

DBQL rules – QUERY LOGGING

Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access select * from DBC.DBQLRuleTbl; Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be used in above query.   To review existing DBQL rules you can either use “SHOW QUERY LOGGING” or use DBC tables/view mentioned earlier (e.g DBC.DBQLRuleTbl). Syntax: SHOW QUERY LOGGING […]
5 Sep by Pankaj Chahar Tags: , , , ,

How to configure viewpoint service in Teradata

To configure Viewpoint follow below steps: 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: service dcs start service postgresql start service viewpoint start Starting and Stopping Teradata Alerts Services Teradata Alerts contains the following services: • tdactivemq: Messaging service that allows message exchanges between the Teradata Alerts components […]
27 Aug by Pankaj Chahar Tags: , , , , ,

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 to connect Hadoop with this Query Grid so it’s called as Teradata Database-to-Hadoop also referred as  Teradata-to-Hadoop connector. Key Importance of Teradata Query Grid is to Put Data in the Data Lake […]
14 Aug by Vijay Tumunuri

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 might pick a different Primary Index then your Primary Key. They are (1) for Performance reasons and (2) known access paths. Primary Index Rules: Rule 1: One Primary Index per table. […]
13 Aug by Deepak Mahato

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 total cost of ownership for systems where data from multiple applications must be completely segregated. Addresses cloud/multi-tenancy security requirements for privileged user access and data segregation. Addresses regulatory compliance requirements […]