108 | 30 May 2014 @ 10:03 PDT | Database | Reply | DBQL AMPCPUTime and TDWM Exception Abort | Thanks Rob for the explaination:)
|
107 | 28 May 2014 @ 05:36 PDT | Database | Reply | Collecting Sample Stats | Thanks Raja ,Deiter for the information.
|
106 | 28 May 2014 @ 04:32 PDT | Database | Topic | DBQL AMPCPUTime and TDWM Exception Abort |
We are using TD 13.10
We have TDWM Exception to abort a session if the CPU consumed by the query is more than a threshold value.
In DBC.DBQLogTbl , the value of AMPCPUTime is very less t... |
105 | 27 May 2014 @ 10:01 PDT | Database | Topic | Collecting Sample Stats | Collection of full table stats is taking longer and consuming lot of CPU resources,and we are not able to complete the stats collection for all tables in the Prod system within the scheduled window... |
104 | 27 May 2014 @ 09:11 PDT | Database | Reply | Statistics Collection Replication | Thanks Dieter for the reply.We are on TD 13.10.
Though we can use TSET to reapply stats, I believe we cannot automate the process of applying the Stats for a large number of tables using TSET.
Pl... |
103 | 27 May 2014 @ 08:57 PDT | Database | Topic | Identifying Sessions Causing AWT exhaustion | The Teradata system is going into frequent flow control.There are a few sessions running with high CPU skewness.
Is there any query to know which sessions are consuming maximum AWTs , so tha... |
102 | 24 May 2014 @ 11:31 PDT | Database | Topic | Statistics Collection Replication | Collecting stats gives the PE an idea of the data distribution of the tables involved in a query and come up with an optimised plan for query execution.
Stats collection is a highly CPU intensive ... |
101 | 19 May 2014 @ 03:03 PDT | Database | Topic | Setting LOGONPROMPT off for session |
If the LOGONPROMPT setting is OFF, BTEQ does not prompt for userid or password if the user omits these entries during logon.
I have set the logon prompt to OFF
.logonprompt off
 ... |
100 | 15 May 2014 @ 06:10 PDT | Database | Topic | Knowing Teradata System TimeZone | How do I know what is the timezone to which the Teradata Server time is set to?
Also where do we store the valid timezone values?Is there any sytem metadata table?
|
99 | 12 May 2014 @ 09:45 PDT | Database | Topic | Querybanding and Changing Workload | I have a scheduled job(a set of CPU intensive statements) which should run under a high priority workload during off business hours and should run under a low prioirity workload when the sytem is b... |
98 | 08 May 2014 @ 10:02 PDT | Database | Topic | Temporal Table Updates |
I have a temporal table,"Policy_Dtls" with columns: CustID,PolicyID,PolicyType,ServiceReq_Num,Policy_Mod_TT .
Policy_Mod_TT is TransactionTime column.
Initially Customer A is o... |
97 | 08 May 2014 @ 08:44 PDT | Database | Reply | Identifying Temporal Tables | Thanks Ulrich,Raja and Dieter for the valuable information on identifying temporal tables in Teradata.
Could you please help me in answering: Which DBS control parameter(s) should be enabled... |
96 | 03 May 2014 @ 12:30 PDT | Database | Topic | Identifying Temporal Tables | Is there any way to identify temporal tables using data dictionary (DBC) tables in TD 13.10 and above?
-Thanks
|
95 | 03 May 2014 @ 12:25 PDT | Database | Reply | Period data type | Thanks Raja for the info,it really worked!
|
94 | 29 Apr 2014 @ 07:30 PDT | Database | Topic | Period data type | How can I extract the start date and end date of the values stored in a period data type column?
I want to use this to calculate the duration for which a particular policy was valid, hence n... |
93 | 23 Apr 2014 @ 09:08 PDT | Database | Topic | Throttle Limits | I want to generate a report with profilenames and throttle limits defined for each profile in the Teradata system.
Kindly let me know which TDWM tables should I refer to get the required informati... |
92 | 23 Apr 2014 @ 09:03 PDT | Database | Reply | Teradata Temporal Error | Thanks Adeel, it worked.
|
91 | 19 Apr 2014 @ 08:48 PDT | Database | Reply | Teradata Temporal Error | TD version is 13.10
|
90 | 17 Apr 2014 @ 08:57 PDT | Database | Topic | Teradata Temporal Error | I am getting the following error while using the following query:
CURRENT VALIDTIME SELECT * FROM Policy;
*** Failure 9330 ValidTime qualifier requires at least one table with Val... |
89 | 14 Apr 2014 @ 07:59 PDT | Viewpoint | Topic | System Heartbeat Canary Query |
We have set the following as the canary query in the Viewpoint server:
Select * from DBC.dbcinfo;
What are the other canary queries available? Is it ok to set the f... |
88 | 08 Apr 2014 @ 12:31 PDT | Viewpoint | Reply | Exception Interval | thanks for the info!
|
87 | 08 Apr 2014 @ 12:28 PDT | Database | Topic | Maximum Data Block Size | How can I know the Maximum Data Block Size set for a Teradata system?
Thanks,
Kishore
|
86 | 31 Mar 2014 @ 04:32 PDT | Database | Reply | Finding User information | You may use PasswordModTime in DBC.DBASE to get the last modification time stamp.
PasswordChgDate value is stored as a Julien date in DBC.DBASE.Conversion of Julien date to integer date form... |
85 | 30 Mar 2014 @ 10:01 PDT | Database | Reply | Finding User information | Teradata uses one way encrytion for storing user passwords,we cannot decrypt the password if its forgotten.
Only way is to reset the password with the help of administartor.
|
84 | 23 Mar 2014 @ 01:21 PDT | Viewpoint | Reply | Exception Interval | I am unware of the areas in Viewpoint where Expection is dealt with.
Could ypu please let me know the various areas.
Appreciate your help!!
-Thanks
|