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 […]
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 […]
10 Sep
by Saumya Maurya
Tags: DBQL, query logging
Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-5c3e654c0a3e1699290140/] 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: [crayon-5c3e654c0a3e6975007826/] Example: [crayon-5c3e654c0a3e9012146548/] […]
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 […]
5 Sep
by Pankaj Chahar
Tags: Configuration, Java, Services, Teradata, Viewpoint
To configure Viewpoint follow below steps: [crayon-5c3e654c0aa8b522866910/] After running the above steps then do the below service restart: [crayon-5c3e654c0aa90499793968/] Teradata Alerts contains the following services: • tdactivemq: Messaging service that allows message exchanges between the Teradata Alerts components For example, to start the messaging service: [crayon-5c3e654c0aa93492812100/] To stop the messaging service: [crayon-5c3e654c0aa95814507260/] To restart the messaging service: […]
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 […]
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 […]
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 […]
9 Aug
by Atul Singh
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET and Access Module Processors (AMPs). The following diagram shows the high level architecture of a Teradata Node. Components of Teradata The key components of Teradata are as follows − Node − It is the basic unit […]
