Teradata

SQL

How to Check Database and PDE version in Teradata

Check Number of VPROC, AMP and PE in Teradata

How to find PPI (Partition Primary Index) tables in Teradata

Views for Checking User And Database Privileges in Teradata

Generate DDL for privilege for Database or Role in Teradata

Find out currently running queries in teradata using SQL instead of viewpoint

Teradata SQL to check whether ONLINE ARCHIVE was enabled or not

Query to find Actual space, Effective Space, Wasted Space and skew factor in Database Tables in Teradata

Check table size across all AMPs in Teradata

Teradata Check Total Used Space, Total Maximum Space, Total Percent Used Space and Total Remaining Space

Check blocking session in Teradata

List all Teradata Access Right for user granted on system using Macros

How Find out current Partition Range in Dynamic Partition Table in Teradata

Copy Table Structure With data and Without Data in Teradata

Truncate or Empty Table in Teradata

Check Data or Primary Index Distribution in Table in Teradata

Find Skew Factor in Tables in Teradata

How to Change Session Date in Teradata

How to Cast Blob or Clob to varchar in Teradata

Get query information from DBQLogTBL in Teradata

Check Failed Logon Information in Teradata

How to Change User Password in Teradata

How to Check in Session Transaction in Teradata is TERA or ANSI mode

How to Set default database in Teradata

How find last collect statistics submission time, collection time and skip count in Teradata

Check a Table is locked or not in Teradata

Queries to identify sessions having high AMP CPU and IO Skew in Teradata

Create Volatile Table in Teradata

BTEQ

BTEQ: How to remove column header from the BTEQ output while exporting the output to flat file

BTEQ: Export to override existing file

BTEQ: Set number of Session in Teradata

BTEQ: SET SESSION TRANSACTION in Teradata

BTEQ: Displays all the BTEQ control command options currently configured

BTEQ – Changing the screen width in Teradata

Error/Issue:

5510 Invalid session mode for procedure execution

3684 The password submitted contains too few characters

9804 Response Row size or Constant Row size overflow

3524 The User does not have CREATE DATABASE access to database XXXXXX

5602 Error creating UDF/XSP/UDM/UDT/JAR: problem accessing the external file %VSTR

3541 The request to assign new PERMANENT space is invalid

42000 An owner referenced by user does not have EXECUTE PROCEDURE access to XXXXXX

2644: No more room in database <DataaseName> while there is space available

2646 No more spool space in %DBID in Teradata

2646 No more spool space for Phantom Spool space

2667 Left-over spool table found

10060 WSA E Timedout: No response received when attempting to connect

7445 Mload table XXXXX cannot be released be release because fallback exists

9247 One or more objects reconciled to an earlier or same date or timestamp

1171 Object <DATABASE_NAME>.<OBJECT_NAME> is not archived because of unresolved RI

5495 Stored Procedure 'DBC.SysExecSQL' does not exist

5313 Referential integrity violation: cannot drop a referenced (Parent) table

8024: All virtual circuits are currently in use

9000 Operation not allowed: the target table is being online archived

7517: Data count does not match the LOB count

3754 Precision error in FLOAT type constant or during implicit conversions

3523 XXXXX:An owner referenced by user does not have XXXX access to XXXX.XXXXX

3523 <XXXX>:The user does not have XXXXX access to XXX.XXXX (Procedure fail with 3523 Error when SQL SECURITY INVOKER use in the procedure)

5780 Cannot DROP a user or database that has DBQL enabled

3552 Cannot DROP databases with tables, journal tables, views, macros, or zones

3551 The user cannot DROP a database that has descendants

2837 Table being Fast/Multi Loaded; no data dumped

Failure ARC0805:Access Module returned error code 34: Tivoli dsmSendIbj error -72: ANS1235E (RC-72) as unknown system error has occured from which TSM cannot recover

Viewpoint stats manager jobs not running after system move (DBS) Or IP change

Teradata database instance with local storage on AWS not working after shutdown the instance

Teradata Studio Installation Failed with “64bit Java Runtime Environment X.X or above is required. Please provide the required JRE path”

1001 There may be errors at object level. This job was running on master node 001-01 and partition 34

DIP script “DIPRTBLOP - R Table Operator” failing with error cannot find -ludfGPLudf

TVAS Report failing with Error Failed in component: dbpool, BC-JAS-TRH Cannot create connection

Performance Data Collection is either not installed or the version is not supported in Teradata Viewpoint

Abort session from viewpoint query monitor failing with Portlet error “internal error: contact your administrator. Error ID (long hex number)”

Assert failed in gtwgateway pid XXXXX: utcbp->pausecount > 0 at tsk/tskuser.c:1034 in Teradata

7595:Operation not allowed: an online archive logging is currently active on <database_name>

DSC using JDBC 14.10 despite an upgrade to TTU 16.XX in Teradata

Teradata Viewpoint Error: “ Your login attempt was not successful, Please try again”

1148: DSA DSMAIN-BARNC Communication Exception: 1001: (xxx.xxx.xxx.xxx) AXMFile: write () retrned error 28: No space left on device

CNSSUPV start: All Interactive Partitions are busy!! in Teradata

/var/opt/teradata file system becoming full by Teradata gateway log files

The /var/opt/teradata filesystem is filling up with BARLog (dsmain) in Teradata

-bash: dbscontrol: command not found in Teradata

Abort Sessions and List status of Abort Session in Teradata

Kill user or Session in Teradata by using Teradata Global Utility (gtwglobal)

Move Space in Teradata using command

Show Hut lock and release lock in Teradata

How to change cufconfig Parameter (MallocLimit)

Enable Analytical Extensions/NPATH and SESSIONIZE in Teradata

How to enable ResUsage in Teradata

Level Pendingop Checks (Find Pending Mload or FastLoad) in Teradata

Check Teradata database (AMP,GTW,Node,PE,RSG,TVS) Status using Vprocmanager

How to use Perflook in Teradata

How to check Which DIP script has been Installed in Teradata

Disable & Enable Logon and Revoke & Grant User Logon in Teradata

Release MLOAD in Teradata

Check when the database was last reset in Teradata

How to enable access logging in Teradata

How to change connection timeout in Teradata Gateway

How to Identify which privileges are required by capturing real time access rights in Teradata

How to Drop Teradata database with all objects

How to run compress/uncompress command via ferret in Teradata

Install Teradata Plug-in for Eclipse

Which releases of R are certified and approved for usage with Teradata Database

Install R Packages in Teradata

Using Nslookup to resolve all domain names to ip adress

Installation SPSS Scoring Adapter for Teradata

How do you configure the connection timeout in JDBC for Teradata?

How to Collect TSET (export & pack) in Teradata

Security:

How to Configure LDAP Authentication in Teradata

Disable or Enable Password Expiration in Teradata

Best Practices & Procedure in changing System Password in Teradata Database

Teradata DBC password change and Reset

Check User locked status and Release lock in Teradata

How lot lock and unlock user account in Teradata

Backup and Recovery

How to find problematic object in DSA backup/restore in Teradata when job_status says "There may be errors at object level"?

DSC using JDBC 14.10 despite an upgrade to TTU 16.XX in Teradata

Stopping and restarting the TARA server on Linux

The /var/opt/teradata filesystem is filling up with BARLog (dsmain) in Teradata

Viewpoint:

How to Check Teradata Viewpoint Version

How To Restart Viewpoint Services in Teradata

Resetting the Admin User Password for Viewpoint in Teradata

Performance Data Collection is either not installed or the version is not supported in Teradata Viewpoint

Comments

Mohammad Nazmul Huda	Search this site