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”;
The World of Teradata 