133 | 20 Jul 2014 @ 08:39 PDT | Database | Reply | UDFs and Granting of Access Rights | @Glass,I have revalidated and the problem description provided by me is correct.
Thanks Fred for the suggestion.It worked!!
|
132 | 20 Jul 2014 @ 08:37 PDT | Viewpoint | Reply | Sytem in Degraded Mode in Viewpoint | Thanks Dieter!
|
131 | 19 Jul 2014 @ 11:53 PDT | Viewpoint | Topic | Sytem in Degraded Mode in Viewpoint | In the System Health Portal, the System is showing in degraded mode.On cliking the icon, I can see the different Health metrics.One of them is AWT usage , which is showing in red.How do I check wha... |
130 | 17 Jul 2014 @ 09:04 PDT | Database | Topic | UDFs and Granting of Access Rights | 1)There are certain UDFs cretaed in my Prod Teradata system.I am trying to grant "EXECUTE FUNCTION" on the UDFs to users.
However when i try granting them , error is encountered:The UDF ... |
129 | 05 Jul 2014 @ 01:30 PDT | Database | Topic | Drop User | Is it possible to drop a user if detailed logging is enabled for the user?
Thanks ,
Kishore
|
128 | 03 Jul 2014 @ 12:26 PDT | Database | Reply | RuleType in tdwm.ruledefs | Can anybody answer the above question.
Thanks in Advance!
|
127 | 02 Jul 2014 @ 02:44 PDT | Database | Topic | Enabling Permanent Journal Feature | Which DBS Control Parameter should be enabled to enable Permanent Journalling at the system level in Teradata?
|
126 | 30 Jun 2014 @ 12:16 PDT | Database | Topic | Access Rights Validation Performance | When a request is submitted, Teradata parser parses the request and checks for appropriate access rights .We are managing access rights through Roles.There are some direct access rights granted als... |
125 | 29 Jun 2014 @ 12:58 PDT | Database | Reply | DB Creation And Account |
Hi VandeBergB,
To summarize what you have said: It is user who submits a requests since only user can only logon and establish sessions with Teradata Server and not databases them... |
124 | 29 Jun 2014 @ 03:08 PDT | Database | Topic | DB Creation And Account | I am creating a Database.Do I need to associate the DB with an account in the create DB statement as in:
CREATE DATABASE DB_Name
AS Perm=0
Spool=0
Account=(‘$L’)
…
…
What is t... |
123 | 26 Jun 2014 @ 08:34 PDT | Database | Topic | RuleType in tdwm.ruledefs | In tdwm.ruledefs table, ruletype=5 means the ruletype is for Workloads in the system.
What does ruletype=1,2,3,4 denote?Where can I get this information.
|
122 | 24 Jun 2014 @ 05:51 PDT | Database | Reply | Monitor Partition | Thanks Dieter!!
|
121 | 24 Jun 2014 @ 02:13 PDT | Database | Topic | Monitor Partition | We have the partition type DBC/SQL for SQL Sessions.
What type of queries fall under the Monitor Partition in Teradata?
|
120 | 18 Jun 2014 @ 04:00 PDT | Database | Topic | WD-Default Workload | I want to identify users/sessions that are running in the default "WD-Default" workload in the teradata system.
Is there any query or function that I should use to get the required infor... |
119 | 18 Jun 2014 @ 03:25 PDT | Viewpoint | Topic | Hot Standby Nodes | In which portel in Viewpoint can we see HSN(Hot Standy Nodes) in the Teradata System?
|
118 | 17 Jun 2014 @ 01:09 PDT | Database | Topic | Fetching DBQLRules Info | I am trying to find the DBQL rule associated with an user.For this I am checking the DefaultAccount in DBC.Users .
I am comparing the defaultaccount value with the accountstring column in DBC... |
117 | 15 Jun 2014 @ 09:13 PDT | Database | Topic | 3883 error |
A query failed with 3883 error.
As per Teradata manual:
A GROUP BY constant does not represent the position of a selected expression, or the selected expression represented is itself a c... |
116 | 15 Jun 2014 @ 09:11 PDT | Database | Reply | New Stats Collection Process in Teradata 14.10 | Thanks Raja.
Hope scheduling this report over a period of time will help us identify indexes that are not needed and take appropriate action.
|
115 | 14 Jun 2014 @ 10:45 PDT | Database | Topic | New Stats Collection Process in Teradata 14.10 | Is there any relationship between ObjectUseCount feature and new stats collection feature in Teradata 14.10?
If so, what is it?
Thanks in Advance!
|
114 | 09 Jun 2014 @ 08:32 PDT | Database | Topic | Delay Queue Count | I am using tdwm.TDWMGetDelayedQueries to get the delay queue count.
When W is passed as parameter, TDWMGetDelayedQueries returns the workload delay queue
When A is passed as para... |
113 | 06 Jun 2014 @ 02:13 PDT | Database | Reply | Parameter Values in SYSLIB.AbortSessions | Thanks Tom for going the extra mile and answering the question..
|
112 | 04 Jun 2014 @ 07:27 PDT | Database | Reply | Parameter Values in SYSLIB.AbortSessions | Thanks Tom for the quick response.
• An identified session is being session-switched.
By "session-switched", do you mean the session is being moved to any secondar... |
111 | 04 Jun 2014 @ 04:13 PDT | Database | Topic | Parameter Values in SYSLIB.AbortSessions | We are trying to logoff sessions from our Teradata Production system,using the SYSLIB.AbortSessions() function.
SYSLIB.AbortSessions function takes 5 parameters.Can someone tell me what does ... |
110 | 30 May 2014 @ 08:29 PDT | Database | Topic | Identifying Single-AMP and All-AMP queries | Is there any way we can trace if a query executed is a Single-AMP or Multi-AMP request other than explain plan or execution plan?Is this info stored in DBC tables?
|
109 | 30 May 2014 @ 10:05 PDT | Database | Topic | CPU Resources Availability |
I want to calculate the CPU seconds available to each workload in my Teradata Server.
How can I calculate the total CPU seconds available to the system per day?
|