TeradataViewLockedUserAccounts

Unlock a Teradata User Account

1. Determine if the account is locked by failed password attempts.  When the failed attempts equals the max logon attempts set in the user’s profile, the user will be displayed … Continue Reading →


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 →