Changing a Password in Teradata
There are a couple ways to change a user’s password in Teradata. Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using … Continue Reading →
Tag: Teradata
Viewing the DBS Control Records in Teradata
Problem: I was asked about the “MaxLoadTasks” setting in Teradata. There are a couple of ways to view this information. In this case I am going to show the command-line … Continue Reading →
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 →
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 →
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 →
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 →
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 →