Teradata BYNET driver information
Note: this is being shown on Teradata Express. Working with Teradata support, I was asked for the version of the BYNET drivers. This is done with a utility called: bam … Continue Reading →
Category: Teradata
Data Warehousing
The Teradata Ferret Utility Says It Exited, But It Is Still Running
Problem: I thought that I had quit the Teradata Ferret utility when I typed “quit”, because the screen displayed “Ferret Exited”. My problem was I exited the utility with out … Continue Reading →
Modify Profile Problem in Teradata
Problem: A profile was created with the wrong account ID which can be view in the DefaultAccount column in the dbc.profileinfo view. This was causing a problem with viewing the … Continue Reading →
How to Turn Off the Logging Online Archive in Arcmain
The issue was a job failed that left Logging Online Archive on a number of tables on one of the Teradata databases. First step was to identify the tables affected, … Continue Reading →
How to Use the Teradata CheckTable Utility
In this example I am using the Teradata Express. Logon on to the Teradata system, using Putty is just a preference. Start the cnsterm supervisor screen (or window): cnsterm 6 … Continue Reading →
Creating an ODBC Connection to Teradata for Excel
Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example, the Operating System was Windows 7 and version Excel 2013 … Continue Reading →
How to run Showblocks with the Ferret Utility
Teradata support asked me for information from the “showblocks” command for a problem table in the Ferret Utility. Below is an example of how I retrieved the information. In my … Continue Reading →
Generate DDL for a Role in a Teradata Database
There are times I would like to copy the permissions for a role with a Teradata database to use on another database. Below is a nice query to give me … Continue Reading →
Query to Check the Last Time a Teradata View was Rebuilt or Altered
Recently I was asked to update a couple of views on a Teradata database. This script was an easy way to verify that the Teradata views’ timestamp for the DDL … Continue Reading →
Increasing the Font in Teradata SQL Assistant on the Fly
One of my frustrations with the Teradata SQL Assistant is when the application starts, the font in the query window is very small. Recently, I have learned a neat trick … Continue Reading →