There are some important considerations to keep in mind when upgrading to Teradata 16.20. After upgrading to Teradata 16.20, we noticed that certain reporting queries produced inconsistent result sets upon each execution. Occasionally, the results were accurate, while at other times they were inaccurate. Upon analysis, I found a correlation between Incremental Planning and Execution …
Learn about Teradata’s priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.
As any experienced Teradata DBA will tell you, some tables in the Teradata dictionary (DBC) need housekeeping. But some customer sites that I have worked with ignore table DBC.AccessRights. If you have ever analyzed this table on a Teradata system, you will almost certainly spot two things quickly. Since this is a system table, altering …
Turning on the Teradata Locking Loggerby Vasudeva Rao To activate the locking logger, access the DBS console window or cnsterm subsystem and ensure it is enabled. Note that the change will only take effect once the database has been restarted. Below is the dbscontrol help output for the flag that governs the locking logger: 9. LockLogger …
Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.
Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.
Teradata administrators worldwide face similar challenges. I propose creating a worldwide database containing the characteristics of Teradata systems. This will allow for easy comparison and analysis of performance issues between different systems. My initial report displays the CPU idle time and the number of disk I/O waits for every hour throughout the day. To contribute …
A hot standby node belongs to a clique of nodes and does not host virtual processes such as AMPs or Parsing Engines. The standby node remains idle until a member of its clique crashes or fails. At this point, the standby node is activated to take over the failed node’s responsibilities. The AMPs from the …
Learn how Teradata Integrated Workload Management assigns workloads to queries and offers features like filters and throttles to improve system performance.
Teradata 16.10 introduces Sparse Maps, a feature to place small table rows on one AMP. Learn more about how it can optimize your system here.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.