Teradata Database Administration – TASM and Viewpoint

Tom Coffing, Carling Nolan

• Publisher: Coffing Publishing
• Year: 2013
• eBook ISBN: 9781940540177
• Topic: Computer Science
• Subtopic: Data Warehousing
• Index: Computer Science

'This book will take you through Viewpoint, TASM, and actually setting up workloads. They are some of the most difficult to understand of the Teradata technologies but also the most important. It is a step by step guide that will make these very challenging subjects easy to master. The step by step process, similar to a cookbook, ensures that readers will not be confused. You will see material that you thought was impossible to learn, and you will master it.

Chapter 1 - Viewpoint

“The most dangerous strategy is to jump a chasm in two leaps.”

- Benjamin Disraeli

Database Administration (DBA) on Teradata

1. Data Dictionary tables and views
2. System hierarchy and Space management
3. Users, Databases, Access Rights, Roles, and Profiles
4. Administrator and System Utilities
5. Teradata Administrator, Viewpoint, DBSControl
6. How to use the archive facility to do Archive, Restore, and Recovery procedures
7. Protection Features
8. Work with user community to help with adding new applications

The Teradata DBA has long been celebrated as one of the most important individuals in a Teradata data warehouse. An experienced DBA is a respected asset who is much needed in a large data warehouse. These professionals can make a huge difference in how smoothly systems run and are vital when problems arise.

Viewpoint

Logging into Viewpoint

Logging on to the Viewpoint portal begins your session and therefore you can now begin working with the Teradata Viewpoint portal.

1. Open a browser.
2. Enter the address for your Teradata Viewpoint portal.
3. Log on to the Teradata Viewpoint portal.

Put in your Username and Password to login to the Viewpoint Portal. You can set up your Viewpoint for auto-provisioning which means, if your system is set up to create a user profile automatically, the username and password you enter are authenticated against your Teradata username and password the first time you log on to Viewpoint.

The First Time you Login to Viewpoint

Above, is the screen you will see the first time you login to Viewpoint. There is almost nothing there but an Add Content menu and the Home tab. You will Add Content on the Home Page, or you will hit the + sign to add a new page.

The Add Content Menu for Monitoring

The drop down menu next to Add Content will provide a menu of content that you can select, and it will add that content to the desired page. The above shows the Monitoring content menu. You can Add Content on the Home Page or you will hit the + sign to add a new page where you can then Add Content. The Add Content menu allows you to place content on the pages and arrange them in a design customized for you.

The Add Content Menu for TASM

The drop down menu next to Add Content will provide a menu of content that you can select, and it will add that content to the desired page. The above shows the Monitoring content menu. You can Add Content on the Home Page, or you can add a new page where you can then Add Content. The Add Content menu allows you to place content on the pages and arrange them in a design customized for you.

The Add Content Menu for Tools

The drop down menu next to Add Content will provide a menu of content that you can select, and it will add that content to the desired page. The above shows the Tools content menu. You can Add Content on the Home Page or you will hit the + sign to add a new page where you can then Add Content. The Add Content menu allows you to place content on the pages and arrange them in a design customized for you.

The Add Content Menu for Trend Reporting

The drop down menu next to Add Content will provide a menu of content that you can select, and it will add that content to the desired page. The above shows the Trend Reporting content menu. You can Add Content on the Home Page or you will hit the + sign to add a new page where you can then Add Content. The Add Content menu allows you to place content on the pages and arrange them in a customized design.

Adding your first Content

The drop down menu next to Add Content will provide a menu of content that you can select, and it will add that content to the desired page. The above shows the Monitoring content menu. In this example, we have chosen Canary Response Times, which means this will be placed on the page. Check out the next page and see what just happened!

How the Page looks after you add your first Content

We just added the Canary Response Times content from the Add Content menu. Now, the content is active on our page. We can easily move the content where we want on the page. We can also move it to another page or delete it.

Adding Additional Pages

Viewpoint allows you to add pages and name the pages in the tab. Multiple tabs (pages) can have the same name. This allows you to organize Viewpoint in any way you want. This is your view point of the system, so customize the way you want....

Table of contents

• Cover Page
• Title Page
• Copyright Page
• About Tom Coffing
• About Carling Nolan
• Contents
• Chapter 1 - Viewpoint
• Chapter 2 - TASM
• Chapter 3 – Designing and Implementing Workloads
• Chapter 4 – Top SQL Commands Cheat Sheet
• Back Cover