158 | 29 Aug 2014 @ 07:52 PDT | Database | Topic | Setting 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 ... |
157 | 23 Aug 2014 @ 10:24 PDT | Viewpoint | Topic | SLGs for Workloads | How to find the SLGs associated with workloads in Teradata Viewpoint?Is there any tdwm/system table that provides the same info?
|
156 | 19 Aug 2014 @ 07:42 PDT | Database | Topic | Failure 6725 while modifying Profile | An 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... |
155 | 19 Aug 2014 @ 09:18 PDT | Database | Topic | Increase in Response Time | We 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... |
154 | 19 Aug 2014 @ 06:27 PDT | Viewpoint | Reply | Auto Provisioning in Viewpoint | Thanks Stever!
|
153 | 17 Aug 2014 @ 08:26 PDT | Viewpoint | Topic | Auto 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?
|
152 | 10 Aug 2014 @ 12:02 PDT | Database | Reply | Profiles and Workloads | We 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... |
151 | 07 Aug 2014 @ 12:09 PDT | Database | Topic | Tactical queries | How to know if the tactical queries submitted are getting cached?
|
150 | 05 Aug 2014 @ 08:12 PDT | Database | Reply | Terminal Window Closed Accidentally | Thanks Krishaneesh!!
|
149 | 05 Aug 2014 @ 01:34 PDT | Database | Topic | Profiles 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... |
148 | 04 Aug 2014 @ 07:59 PDT | Database | Topic | Error 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... |
147 | 04 Aug 2014 @ 12:34 PDT | Database | Reply | Terminal Window Closed Accidentally | No, 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... |
146 | 02 Aug 2014 @ 11:55 PDT | Database | Topic | Terminal Window Closed Accidentally | I 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... |
145 | 30 Jul 2014 @ 11:02 PDT | Database | Topic | Cost 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 ... |
144 | 30 Jul 2014 @ 10:39 PDT | Viewpoint | Reply | Session CPU,IO Skew | Thank you so much Stever for clarifying!I got the point.
|
143 | 30 Jul 2014 @ 09:02 PDT | Viewpoint | Reply | Session CPU,IO Skew | Hi 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... |
142 | 29 Jul 2014 @ 10:24 PDT | Viewpoint | Topic | Session CPU,IO Skew | How 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 ... |
141 | 29 Jul 2014 @ 03:17 PDT | Viewpoint | Topic | Creating Different Operating Environment | How 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... |
140 | 29 Jul 2014 @ 12:26 PDT | Viewpoint | Reply | Reserved AWT pool | Thank you so much Rglass.The link provided above was indeed helpful in getting a clear idea.
|
139 | 28 Jul 2014 @ 08:42 PDT | Database | Reply | HashBufferSize | Sorry for the confusion.It is HashedBufSize
|
138 | 28 Jul 2014 @ 06:15 PDT | Database | Topic | HashBufferSize | What is the HashBufferSize parameter in Teradata?How does it affect Teradata system performance?
|
137 | 27 Jul 2014 @ 09:46 PDT | Viewpoint | Reply | Reserved AWT pool | Thanks 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... |
136 | 23 Jul 2014 @ 06:50 PDT | Database | Topic | *** 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... |
135 | 21 Jul 2014 @ 11:58 PDT | Database | Topic | Stats Collection after upgrade to TD14.10 | We 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 ... |
134 | 20 Jul 2014 @ 10:46 PDT | Viewpoint | Topic | Reserved AWT pool | Is there any way we can see what are the reserved pool of AWTs configured for the system in Viewpoint?
|