Blog

Blog
The best minds from Teradata, our partners, and customers blog about whatever takes their fancy.
971 Views
0 Comments

Teradata Workload Management comes in two versions: Teradata Integrated Workload Management (TIWM) which includes basic functionality, and Teradata Active System Management (TASM) which has a richer set of capabilities.  Both TIWM and TASM come with several system-defined workloads. This blog explains what these workloads are, why they are there, and whether you can ignore them or not.

Read more...

2030 Views
0 Comments

AMP worker tasks (AWT) are a critical resource in the Teradata Database.   In previous blog postings I’ve explained how the load and export utilities, as well as ARC backup and restore, use AMP worker tasks.  In this posting we’ll consider the replacement for ARC, Data Stream Architecture (DSA), and its use of AWTs.

 

 

Read more...

3191 Views
0 Comments

This is an update to an earlier posting in which data dictionary statistics recommendations in Teradata Database 14.0 were shared. This posting makes similar recommendations for data dictionary statistics from the 15.10 perspective.

Read more...

6837 Views
4 Comments

Both system-level and workload-level throttles can manage the concurrency of load utility jobs in the Teradata Database.   However, the point at which they release their respective throttle slots differs.  This article explains that difference.

Read more...

1743 Views
0 Comments

This posting discusses an unanticipated behavior within TASM/TIWM when it comes to selecting the workload to do the parsing engine (PE) execution activities.  

Read more...

  • Parsing
  • SessionWDID
  • TASM
7820 Views
2 Comments

This posting explains what Teradata workload management system throttle enforcement options are, and the consequences of using them.

Read more...

18080 Views
2 Comments

Teradata is a message passing system.  Messages are sent from parsing engines to AMPs, and from  AMPs to AMPs, and from AMPs to parsing engines.  That’s the key way that components in a shared nothing architecture pass data and work requests among themselves.When a message arrives Read more...

13375 Views
3 Comments

Tactical workload exceptions are in place to prevent tactical queries from consuming unreasonable amounts of resources.  It is important to have this protection because the super-priority and almost unlimited access to resources given to work running in the Tactical tier with SLES Read more...

38452 Views
12 Comments

Have you ever found yourself confused when setting up classification criteria for a new workload in Teradata?  You’re not alone.  This posting discusses the main principles at work when it comes to combining different classification criteria.  It also provides some general tips to Read more...

2112 Views
0 Comments

Every so often, the Teradata JDBC Driver Engineering team is asked about Teradata Database Error 5766 "The Locator is invalid because the response spool has been dropped." Why does it happen? How can it be avoided?

Read more...