#DateForumTypeThreadPost
15829 Aug 2014 @ 07:52 PDTDatabaseTopicSetting Spool Space Limit for Profiles We are having ~1000 Business Users, who are accessing the Teradata Production system. The business users are assigned to a common profile.We want to set a spool space limit for the business ...
15723 Aug 2014 @ 10:24 PDTViewpointTopicSLGs for WorkloadsHow to find the SLGs associated with workloads in Teradata Viewpoint?Is there any tdwm/system table that provides the same info?
15619 Aug 2014 @ 07:42 PDTDatabaseTopicFailure 6725 while modifying ProfileAn account string is $L0+ADHX&S&D&H. We are modifying the profile and assign the account string: modify profile Profile01 AS ACCOUNT=('$L0+ADHX&S&D&H'); &nbs...
15519 Aug 2014 @ 09:18 PDTDatabaseTopicIncrease in Response TimeWe are experiencing increase in response time of queries of a workload during a particular time of the day.What could be the possible reasons for this?How to analyse the root cause?   Apprec...
15419 Aug 2014 @ 06:27 PDTViewpointReplyAuto Provisioning in ViewpointThanks Stever!
15317 Aug 2014 @ 08:26 PDTViewpointTopicAuto Provisioning in Viewpoint Automatic profile creation in Viewpoint is known as Auto provisioning . How to know if the Teradata viewpoint system is set up to create a user profile automatically?
15210 Aug 2014 @ 12:02 PDTDatabaseReplyProfiles and WorkloadsWe also has TDWM user enabled,the table tdwm.WlcClassifyOrder is showing as not existant in TD 14.10.  *** Failure 3807 Object 'tdwm.WlcClassifyOrder' does not exist.   &nb...
15107 Aug 2014 @ 12:09 PDTDatabaseTopicTactical queriesHow to know if the tactical queries submitted are getting cached?
15005 Aug 2014 @ 08:12 PDTDatabaseReplyTerminal Window Closed AccidentallyThanks Krishaneesh!!
14905 Aug 2014 @ 01:34 PDTDatabaseTopicProfiles and Workloads We are using TASM and Teradata 14.10 DB version.User is assigned to profile and profile is mapped to workload. A single profile can be mapped to more than one workload.Based on query creteri...
14804 Aug 2014 @ 07:59 PDTDatabaseTopicError while Granting Access Right A SP is complied on a Teradata Admin_User. The Work of the SP is to change the profile of the requested user. It takes 2 IN parameters: Username whose profile is to be changed and Profil...
14704 Aug 2014 @ 12:34 PDTDatabaseReplyTerminal Window Closed AccidentallyNo, I did not take the PID of the process. However, one way to get is to check the details is in DBC.SessionsInfo(if the session is active) & DBC.Logonoff (eventtype when the terminal is accid...
14602 Aug 2014 @ 11:55 PDTDatabaseTopicTerminal Window Closed AccidentallyI am connected to the teradata server through a session on my terminal.Accidentally  the terminal got closed.Will the session still continue to be there or it will be logged off immediately?Is...
14530 Jul 2014 @ 11:02 PDTDatabaseTopicCost Profile vs Startup String A business user is running reports that are using OLAP functions in the queries. The performance analyst has suggested to use the below diagnostic command , in all the sessions for the user ...
14430 Jul 2014 @ 10:39 PDTViewpointReplySession CPU,IO SkewThank you so much Stever for clarifying!I got the point.
14330 Jul 2014 @ 09:02 PDTViewpointReplySession CPU,IO SkewHi Stever, Thanks for the info. I  believe, for more real time update we can use the SYSLIB table function as in the following query:      SEL UserName (TITLE 'Users&#...
14229 Jul 2014 @ 10:24 PDTViewpointTopicSession CPU,IO SkewHow is session level CPU and IO skew calculated as dispalyed in Viewpoint for a particular session (in Query Monition) in the "Skew" tab for a particular session?Is it the skew factor of ...
14129 Jul 2014 @ 03:17 PDTViewpointTopicCreating Different Operating EnvironmentHow to create different Operating Environment in Teradata?When there is a planned and unplanned restart or downtime on the sytem for considerable time, the system has to do the ETL catch up once it...
14029 Jul 2014 @ 12:26 PDTViewpointReplyReserved AWT poolThank you so much Rglass.The link provided above was indeed helpful in getting a clear idea.
13928 Jul 2014 @ 08:42 PDTDatabaseReplyHashBufferSizeSorry for the confusion.It is HashedBufSize
13828 Jul 2014 @ 06:15 PDTDatabaseTopicHashBufferSizeWhat is the HashBufferSize parameter in Teradata?How does it affect Teradata system performance?
13727 Jul 2014 @ 09:46 PDTViewpointReplyReserved AWT poolThanks Rglass! I can find the number of reserved AWTs in my system at the Workload Designer->Workloads->Priority Distribution tab to be 5. Is there any way to find for which type of work thes...
13623 Jul 2014 @ 06:50 PDTDatabaseTopic*** Failure 7504***While calling the table  function tdwm.TDWMListWDs for Workload Information, getting the following error:   SELECT * FROM TABLE (tdwm.TDWMListWDs('N')) AS t1;  *** Fa...
13521 Jul 2014 @ 11:58 PDTDatabaseTopicStats Collection after upgrade to TD14.10We have stats collected on certain tables in TD 3.10.After upgrade to TD 14.10 , the stats are reportedly missing.I am aware that in TD 14.10, the stats collection is taken care by DBC.StatsTbl.Is ...
13420 Jul 2014 @ 10:46 PDTViewpointTopicReserved AWT poolIs there any way we can see what are the reserved pool of AWTs configured for the system in Viewpoint?

Pages