Utilities & Loading
A collection of 89 issues
Teradata Multivalue Compression and Presence Bytes for NULL Values
Multivalue compression and null indication serve distinct purposes yet share a common objective of storing information about the values of each row's columns. To conserve space, Teradata utilizes presence bytes to retain information on multivalue compression and nullability.
Readers familiar with earlier releases will recognize that the name
Why You Need a Performance Specialist for Your Data Warehouse Project
Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table
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.
1.
Teradata DDL Best Practice: Use DELETE Instead of DROP for Efficiency and Resource Management
Learn why you should opt for DELETE instead of DROP when it comes to Teradata DDL. Avoid locking dictionary tables and conserve resources.
Benefits of Organizing Stored Procedures into Chapters and Steps
I made organizing Stored Procedures into Chapters and Steps a principle.
These separation points are marked by comments and variables used in performance and result logging.
A step refers to a technical or conceptual task that cannot be further divided without losing the abstraction of Stored Procedures or the main
Teradata Locking Logger: How to Enable and Analyze Lock Activity
Turning on the Teradata Locking Logger
by 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
Introduction to Teradata Big Data Blocks: Advantages and Disadvantages
Teradata Big Data Blocks - Introduction
Teradata 13.10 introduced larger file systems components, such as cylinders and data blocks. The cylinder size was increased from 1.9 MB to 11.3 MB, while the data block size limit was raised from 127.5 KB to 1 MB in Teradata
Teradata Utility Workload Management: Overview and Protocols
Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.
Understanding Teradata Workload: Definition, Advantages, and Characteristics
Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.