Book Image

Teradata Cookbook

By : Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati
Book Image

Teradata Cookbook

By: Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati

Overview of this book

Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata. The book begins with recipes on quickly setting up a development environment so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you’ll master various administrative tasks such as user and security management, workload management, high availability, performance tuning, and monitoring. This book is designed to take you through the best practices of performing the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.
Table of Contents (19 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Managing DBC space


A system user named DBC (database computer) is the owner of all disk space on a system. When the system is initially set up, spaces for child databases are derived from DBC itself. DBC's space includes dictionary tables, databases, views, and all the child databases:

**DBC database space**
   Select sum(MaxPerm) from DBC.DiskSpace where DatabaseName = 'DBC';

It is very important to understand space in DBC itself. Why is it important and what it is used for?

Once you allocate space from DBC to other databases, it is important that you keep adequate space in the DBC database to accommodate the growth of system tables and logs, and the transient journal. Also, if you are not using a separate database for the spool, space in DBC can also be used for spool purposes (all the empty space in the system is used as the spool).

The main reason to keep an eye on DBC is because of TJ (transient journal). It maintains snapshots of rows that are going to be processed or are getting processed...