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;

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.

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.

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 .

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.

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;

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

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

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.

Teradata Tutorial Videos

Teradata Introduction

Netezza Common SQL commands

Nzsql commands 

ALTER DATABASE

 To change the default 8-bit character set in the emp database, enter:

system(admin)=> ALTER DATABASE emp set default character set

latin9;

 To rename the emp database, enter:

system(admin)=> ALTER DATABASE emp RENAME TO employees;

 To change the owner of the emp database, enter:

system(admin)=> ALTER DATABASE emp OWNER TO admin3;

Teradata Database security

Teradata Database security is based on the following concepts.

Security Element	Description
User	An individual or group of individuals represented by a single user identity.
Privileges	The database privileges explicitly or automatically granted to a user or database.
Logon	The process of submitting user credentials when requesting access to the database.
Authentication	The process by which the user identified in the logon is verified.
Authorization	The process that determines the database privileges available to the user.
Security Mechanism	A method that provides specific authentication, confidentiality, and integrity services for a database session.
Network Traffic Protection	The process for protecting message traffic between Teradata Database and network-attached clients against interception, theft, or other form of attack.
Message Integrity	Checks data sent across the network against what was received to ensure no data was lost or changed.
Access Logs	Logs that provide the history of users accessing the database and the database objects accessed.

Users

Users that access Teradata Database must be defined in the database or a supported directory.

Introduction to teradata utilities -BTEQ

Introduction to teradata utilities : BTEQ

BTEQ is a Teradata native query tool for DBA and programmers. BTEQ (Basic TEradata Query) is a command-driven utility used to 1) access and manipulate data, and 2) format reports for both print and screen output.

All database requests in BTEQ are expressed in Teradata Structured Query Language (Teradata SQL). You can use Teradata SQL statements in BTEQ to:

    * Define data — create and modify data structures;
    * Select  data — query a database;
    * Manipulate data — insert, delete, and update data;
    * Control data — define databases and users, establish access rights, and secure data;
    * Create Teradata SQL macros — store and execute sequences of Teradata SQL statements as a single operation.