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 →


Emailed DBCC CHECKDB Output

Email the results of DBCC CHECKDB

Situation: We had a very busy SQL Server, that could not have “DBCC CHECKDB” run during business hours with out impacting others.  I was being asking for the output from … 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 →


SSMSinstallComplete

Install SQL Server Management Studio (SSMS) 2016 Without Internet Access

One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation.  It is now has its … 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 →


StartChecktable

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 →


07_ExcelSetupConnection

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 →