DIP_Menu

Running A DIP Script in Teradata

Note: The following was run on a Teradata Express 15.10 VM. Problem: Teradata Support’s response to correcting a problem we were having with calendar functions was “running DIPCAL should successfully … Continue Reading →


RolesWithCreateUID

Teradata Finding Which User is the CreateUID

Problem: Looking at the dbc.roles table, I want to find which user created a role.  There is the 4-byte column in the table called CreateUID, which identifies the user that … Continue Reading →


TruncateInTeradata

Truncate Table in Teradata

Coming from SQL Server & Oracle, I wanted a quick way in Teradata to truncate all the records from a table.  The issue is the word TRUNCATE is not a … Continue Reading →


logonevent

Teradata Viewing Failed Logon Information

In Teradata, there is a way to view the reason that a username is not authenticating.  Teradata is good about collecting information at the time of authentication.  It can be … Continue Reading →


teradata_password_change02

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 →


dbscontrol_display

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 →


BynetDriverInformation

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 →


FerretExited

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 →


ModifyProfile

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 →


DBC.ArchiveLoggingObjsV

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 →