Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
Teradata
How much space should be reserved for Spool reserve in Teradata
Consequence of Abnormal Shutdown of Teradata Database
How to check number of CPU in Teradata System
Teradata Studio Create Database
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
How to search column name in Tables in Teradata
How to check Timzone Setting 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
6706 The string contains an untranslatable character
6849 The UDT (with Group Name TD_JSON_CLOB) does not have Transform, or does not have the specified Transform Group
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
CLI error: MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway in Teradata
Session are blocked by a session with Session ID=0 and State=“?” in Teradata
ARCMAIN TERMINTATED WITH SEVERITY X in Teradata
Special characters are not displaying properly from Client Tools 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
Why collect Statistics not updating the statistics even after running the Collect Statements in Teradata
How to collect necessary info for session stuck/hang issue in Teradata
Check if rollback is running (If session is in aborting state) in Teraddata
Run Scandisk and Checktable 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
How to use Ldap mechanism in TPT script 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
Cannot Export All Data(ZIP)/Summary Data(ZIP) from Viewpoint Portlet “Elastic Performance” in Teradata
Teradata Viewpoint: MessagingException sending mail. (Could not connect to SMTP host:<domain>, Port:25)
Unable to move TASM ruleset to READY or make it ACTIVE in Teradata Viewpoint Workload Designer (There was an error executing the request in TASM)
Comments