TERADATA

  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 …

  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 …

  Following query will verify if any DBQL rule exists: locking table DBC.DBQLRuleTbl for access [crayon-5f6d2a7f90652034478625/]   Note: View DBC.DBQLRules OR DBC.DBQLRulesV can also be used in above query.   …

  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 …

  To configure Viewpoint follow below steps: [crayon-5f6d2a7f90d35298844659/]   After running the above steps then do the below service restart: [crayon-5f6d2a7f90d3a031325817/]   Teradata Alerts contains the following services: • tdactivemq: Messaging service …

  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 …

  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 …

  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 …

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 …

  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 …