#DateForumTypeThreadPost
10830 May 2014 @ 10:03 PDTDatabaseReplyDBQL AMPCPUTime and TDWM Exception AbortThanks Rob for the explaination:)
10728 May 2014 @ 05:36 PDTDatabaseReplyCollecting Sample StatsThanks Raja ,Deiter for the information.
10628 May 2014 @ 04:32 PDTDatabaseTopicDBQL 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...
10527 May 2014 @ 10:01 PDTDatabaseTopicCollecting Sample StatsCollection 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...
10427 May 2014 @ 09:11 PDTDatabaseReplyStatistics Collection ReplicationThanks 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...
10327 May 2014 @ 08:57 PDTDatabaseTopicIdentifying Sessions Causing AWT exhaustionThe  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...
10224 May 2014 @ 11:31 PDTDatabaseTopicStatistics Collection ReplicationCollecting 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 ...
10119 May 2014 @ 03:03 PDTDatabaseTopicSetting 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  ...
10015 May 2014 @ 06:10 PDTDatabaseTopicKnowing Teradata System TimeZoneHow 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?  
9912 May 2014 @ 09:45 PDTDatabaseTopicQuerybanding and Changing WorkloadI 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...
9808 May 2014 @ 10:02 PDTDatabaseTopicTemporal 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...
9708 May 2014 @ 08:44 PDTDatabaseReplyIdentifying Temporal TablesThanks 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...
9603 May 2014 @ 12:30 PDTDatabaseTopicIdentifying Temporal TablesIs there any way to identify temporal tables using data dictionary (DBC) tables in TD 13.10 and above? -Thanks
9503 May 2014 @ 12:25 PDTDatabaseReplyPeriod data typeThanks Raja for the info,it really worked!
9429 Apr 2014 @ 07:30 PDTDatabaseTopicPeriod data typeHow 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...
9323 Apr 2014 @ 09:08 PDTDatabaseTopicThrottle LimitsI 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...
9223 Apr 2014 @ 09:03 PDTDatabaseReplyTeradata Temporal ErrorThanks Adeel, it worked.
9119 Apr 2014 @ 08:48 PDTDatabaseReplyTeradata Temporal ErrorTD version is 13.10
9017 Apr 2014 @ 08:57 PDTDatabaseTopicTeradata Temporal ErrorI 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...
8914 Apr 2014 @ 07:59 PDTViewpointTopicSystem 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...
8808 Apr 2014 @ 12:31 PDTViewpointReplyException Intervalthanks for the info!
8708 Apr 2014 @ 12:28 PDTDatabaseTopicMaximum Data Block SizeHow can I know the Maximum Data Block Size set for a Teradata system?   Thanks, Kishore
8631 Mar 2014 @ 04:32 PDTDatabaseReplyFinding User informationYou 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...
8530 Mar 2014 @ 10:01 PDTDatabaseReplyFinding User informationTeradata 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.  
8423 Mar 2014 @ 01:21 PDTViewpointReplyException IntervalI 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

Pages