Setting A Teradata Maintenance Window – Updated 2021
Teradata in a recent design change moved where to set the Maintenance Window with the roll out of their newer equipment. Note: The reason that you would want to set … Continue Reading →
Category: Teradata
Data Warehousing
Teradata – Most Currently Updated Stats
This is a quick query that I use to check if the on the stats job that ran over night. Much faster then running the “SHOW STATISTICS” for each table. … Continue Reading →
Teradata chk_node VS nodecheck
Teradata systems have a couple of command-line utilities to verify the health of a Teradata node. Both these command-line utilities are good to run when looking for something like hardware … Continue Reading →
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 →