What if your viewpoint stops working or there is a upgrade. At that point of time lots and lots of questions arise in your mind. How to know about running sessions, or rush a session, how to track ETL loads, how to change priority of a session…. Bla Bla Bla… below are the answers of … More Teradata :Get Sessions Info.
SELECT MAX(LOGONDATE) FROM DBC.LOGONOFF WHERE USERNAME=’USERNAME’;
Databases size in GB The size of database is the diffrence of maxperm and currentperm space of a database. select the sum of maxperm and currentperm from DBC.DISKSPACE and convert into GB and get the difference. Below is the query to find database size in GB select databasename,cast(sum(maxperm)/1024 ** 3 as decimal(7,2)) max_perm_GB, cast(sum(currentperm)/1024 **3 … More Teradata : Get databases size in GB
It is really simple to change a user’s password in Teradata. Password could be changed by using MODIFY command. The syntax to change password is MODIFY USER USERNAME AS PASSWORD =”PASSWORD”;
Teradata relies on four architectural components Parsing Engine(PE) or Optimizer Access Module Processors(AMPs) BYNETs Disks Parsing Engine A Parsing Engine (PE) is a virtual processor (vproc). It is a component that interprets SQL request, receives data add pass it. It is made up of the following software components: Session Control Parser Optimizer Dispatcher Each … More Teradata Architecture
It is very necessary for every Teradata(TD) user to know what error is attached to an error code to drill down to till base to tackle the issue… here is the complete list of error codes which a TD user can encounter. Download Complete List of error codes here – TD_Error_Codes The file is password protected … More Teradata Error Codes
The World of Teradata 