node.check Utility in Teradata

The “node.check” utility has been been around for a while with Teradata.  Recently I was working with Teradata’s Hardware Support team, and watched them use this utility to uncover a … Continue Reading →


Teradata – Convert Timestamp to the Month of the Year

This one also surprises me that someone has not already posted. The TD_Month_Of_Year function returns an integer value that need to converted to string value.  Careful when using this on … Continue Reading →


Teradata – Convert Timestamp to the Day of the Week

This surprises me that someone has not already posted this. The TD_Day_of_Week function returns an integer value that need to converted to string value.  Careful when using this on a … Continue Reading →


Collect Statistics Spool Space Error in Teradata

Recently I received an e-mail alert that my collect statistics job had a spool space error (“Failure 2646 No more spool space in…”) for one of the statements it ran … Continue Reading →


Unable to Connect to Teradata from Toad DataPoint with an Active Directory Account

A user was unable to connect to Teradata from Toad DataPoint using a Microsoft Active Directory account.  When I looked at the user account in Teradata, it was showing as … Continue Reading →


Stopping & Starting Teradata Viewpoint Services

Stopping & Starting the services for Teradata Viewpoint are the same in Teradata Express as they would be on an actual Teradata Viewpoint server.  Recently I needed to do this … Continue Reading →


TERADATA ERROR – DROP DATABASE Failed. 3552:

When attempting to drop a database that I created for temporary use, I received the following error when I ran the “DROP DATABASE < database name >” command: DROP DATABASE … Continue Reading →


How To Find All Access Rights In Teradata

The problem with the table DBC.AccessRights is that the data is not something easily readable.  Many of the columns use a 4-byte IDs. By joining a couple of tables to … Continue Reading →


Teradata Error: Cannot Find Terasso Library

Problem: Setting up a new computer with the 16.10 Teradata Tools And Utilities & other Teradata programs.  When I went to setup the ODBC Connection to the using the Teradata … Continue Reading →


Flash NIC Light on SUSE Linux – Teradata Server

Problem: I needed to know the ethernet device name of an unused port on a NIC (network interface card) on my Teradata server.  Using the “ethertool” utility, I was able … Continue Reading →