Wednesday, 6 February 2019

Teradata 16 New Features


Brief overview of some of the new features added in Teradata 16 version.
➠ Two new string functions were added
  • PIVOT ~ Transpose Rows to Columns
  • UNPIVOT ~ Transpose Columns to Rows
  Visit PIVOT page and UNPIVOT page to check syntax and examples for above functions.


Tuesday, 15 January 2019

Why is so much data being written into DBQL?

 

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 be improvised but can’t be ignored.Its a pillar for Admins as well,helps in disasters ðŸ˜€
But,if space and other issues are concerened, below tips can help you some:

How to speed up Teradata Fastexport

About Teradata Fastexport
Teradata Fastexport is a nice, powerful tool to export mass volume of data to file. Its default execution flow is the following:
1.   Apply locks on the affected tables
2.   Execute the SELECT statement
3.   Places the result in a SPOOL
4.   Releases locks
5.   Exports data from the SPOOL

Monday, 10 September 2018

Hash Functions to identify skewed data

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 hash functions.
Following query identifies the database space:

Wednesday, 5 September 2018

Easy way to get Syntax for a command in Teradata


A MACRO can help you getting the Syntax help if you are new to Teradata or new to any syntax.
A MACRO is a Teradata extension to ANSI SQL that contains prewritten SQL statements.
The actual text of the macro is stored in a global repository called the Data Dictionary (DD).
A macro allows us to name a set of one or more statements. When we need to execute those statements, simply execute the named macro. Macros provide a convenient shortcut for executing groups of frequently-run SQL statements.

Below is complete list of commands to manipulate macros.

Tuesday, 28 August 2018

ABORTING STATE : ReCoVery Manager or RCV Manager/RMAN


The ABORTING state indicates that the session is aborting its latest request.

“Do you want to get rid of the aborting session in the system from long time, to clean up such sessions quickly?”
1.       Use RCVManager to list/abort the Rollback process   OR
2.       Use Gateway Global to abort user session   OR
3.       Use Function to abort the session
4.       Hopeless ?  Then do TPA reset.(Teradata Database Bounce)

Monday, 13 August 2018

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 to separate administration duties from access control.
  • Provides companies that are multi-national the ability to prevent data from crossing boundaries (geographical, national, divisional, etc.).

Tuesday, 10 July 2018

Read more blogs on Teradata & Netezza over LinkedIn Articles

https://www.linkedin.com/today/author/pchahar?trk=pprof-feedhttps://www.linkedin.com/today/author/pchahar?trk=pprof-feed
↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑

A --> Z of Teradata Query Performance Tuning

A) Explain the EXPLAIN: Check for EXPLAIN plan to see how exactly Teradata will be executing the query. Try to understand basic keywords in Explain Plan like confidence level, join strategy used, re-distribution happening or not.

B) Collect STATS: The stats of the columns used join conditions should updated. Secondary Indexes without proper STATS can be of little or no help. Check for STATS status of the table.

Friday, 25 May 2018

Turn off FallBackSetting in Teradata

Below are the steps to turn off FallBackSettings “ALWAYS FALLBACK” in Teradata Server on-Prem or cloud (AWS EC2 or Azure)

Login to Teradata NodeLogin to Teradata Node and run sudo su –

Run command dbscontrol from command prompt

In DBSControl window

Run “mod systemfe=T” (without double qoutes) and enter Y on prompt

Friday, 27 April 2018

TERADATA IMPORTANT DIAGNOSTIC COMMANDS !!!!

TERADATA IMPORTANT DIAGNOSTIC

DIAGNOSTIC HELPSTATS ON FOR SESSION;
DIAGNOSTIC COSTPRINT ON FOR SESSION;
DIAGNOSTIC OLDREWRITES ON FOR SESSION;
DIAGNOSTIC DUMP COSTS ON FOR SESSION;
DIAGNOSTIC HELP COSTS ON FOR SESSION;

Monday, 1 May 2017

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 FAST across foreign servers.

What is Query Grid?

Query Grid works to connect a Teradata and Hadoop system to massive scale, with no effort, and at speeds of 10TB/second.
·         It provides a SQL interface for transferring data between Teradata Database and remote Hadoop hosts.

Thursday, 26 January 2017

Teradata NPARC (Named Pipe ARChive)

Brief Introduction to Teradata:
Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations. 

The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.

What happens when business data grows?

Sometimes, working in IT we need to upgrade entire configurations of our systems or servers to get in sync with business requirements. As a growing IT, data is also growing and for that we may need to get rid of old configuration systems or servers and for that we need to migrate the existing business data.

Thursday, 1 December 2016

Understanding Teradata Wallet (tdwallet)

Understanding Teradata Wallet (tdwallet)
Teradata Wallet is a facility for storage of  sensitive/secret information, such as Teradata Database user passwords. Users save and retrieve items by using the facility. 
Wallet or tdwallet is the latest piece or pack of Terdata software, introduced  in latest Teradata Tools and Utilities packages those are version 14.00/15.00 and later, where the customers can store passwords/credentials (or other confidential information)  securely and safely on client computers or application servers. This stored information is used while signing in to the Teradata Database using any utility or piece of software that uses Teradata .

Monday, 28 November 2016

Teradata Intelligent Memory (TIM)- Running at the speed of Business

Teradata Intelligent Memory (TIM)- Running at the speed of Business

Overview of Teradata
Teradata is a RDBMS (Relational Database Management System). This system is solely based on off-the-shelf (readymade) symmetric multiprocessing (SMP) technology combined with communication networking, connecting SMP systems to form large Massively parallel processing systems (MPP). It is wholly used to manage large data warehousing operations. Teradata acts as a single data store that can accept large number of concurrent requests from multiple client applications.
Parallelism along with load distribution shared among several users, Execution of complex queries with a maximum of 256 joins, Parallel efficiency, Complete scalability , Teradata Intelligent Memory are some of Teradata’s widely shown Features.

Saturday, 26 November 2016

Teradata Disk Space Queries

Teradata Disk Space Queries
1) To find AMP usage and CPU utilization on TD server.

  You could query DBC.Tablesize, DBC.ProfileInfo, DBC.AllRoleRights, and  
  DBC.RoleInfo and others. The query should return on the AMP Usage and CPU  
  Utilization The following query is dbc.ampusage                 

  Select Account Name, UserName, sum(diskio),sum(cputime)
from    dbc.ampusage
  Group by 1,2;

Monday, 21 November 2016

Netezza Advanced Security

Netezza Advanced Security

1.System Security
SYSTEM(ADMIN)=> CREATE USER dso;
CREATE USER
SYSTEM(ADMIN)=> GRANT MANAGE SECURITY TO dso;
GRANT
SYSTEM(ADMIN)=> GRANT USER TO dso;
GRANT
2.User Login Control

Tuesday, 15 November 2016

Client Communication with Teradata

Client applications can connect to Teradata Database using one of the following methods:
• Network-attached through a Local Area Network (LAN)- Workstation Attachment Methods
• Channel-attached through an IBM mainframe- Mainframe Attachment Method

Workstation Attachment Methods
Workstation-attached methods include:
• .NET Data Provider for Teradata
• Java Database Connectivity (JDBC)
• OLE DB Provider for Teradata
• Open Database Connectivity (ODBC)
• Teradata CLIv2 for workstation-attached systems

Wednesday, 27 January 2016

Introduction to Netezza


Introduction
Success in any enterprise depends on having the best available information in time to make sound decisions. Anything less wastes opportunities, costs time and resources and can even put the organization at risk. But finding crucial information to guide the best possible actions can mean analyzing billions of data points and petabytes of data, whether to predict an outcome, identify a trend or chart the best course through a sea of ambiguity. Companies that can get this type of intelligence on demand are able to react faster and make better decisions than their competitors.