27 Oct
by Sharib Hussain
Tags: HARDSTOP teradata, pdestate, shut down Teradata, Teradata, Teradata restart
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 […]
17 Oct
by Pankaj Chahar
Tags: DBQL, query logging, Teradata
There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log. So we save the space, resources,performance and etc etc. Note : DBQL can only […]
21 Sep
by Jaime Eduardo Carvajal Silva
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, 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 Saumya Maurya
Tags: hash function, Teradata
On day to day activity we often get situation when the database has a lot of space left but query fails with “2644: No more room in database“. If any table has severe skewing it can cause the database to run out of space. Here we will learn how to identify data causing skewness using […]
5 Sep
by Pankaj Chahar
Tags: Configuration, Java, Services, Teradata, Viewpoint
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 […]
28 Aug
by Pankaj Chahar
Tags: excel, odbc, Teradata
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 7 and version Excel 2013 was used. This is broken in to two parts, first is setting up the ODBC connection, then section is attaching the connection in Excel. Note: If the ODBC […]
27 Aug
by Pankaj Chahar
Tags: connector, datalake, hadoop, NoSQL, querygrid, Teradata
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
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
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 […]
