#DateForumTypeThreadPost
13320 Jul 2014 @ 08:39 PDTDatabaseReplyUDFs 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!!
13220 Jul 2014 @ 08:37 PDTViewpointReplySytem in Degraded Mode in ViewpointThanks Dieter!
13119 Jul 2014 @ 11:53 PDTViewpointTopicSytem in Degraded Mode in ViewpointIn 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...
13017 Jul 2014 @ 09:04 PDTDatabaseTopicUDFs and Granting of Access Rights1)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 ...
12905 Jul 2014 @ 01:30 PDTDatabaseTopicDrop UserIs it possible to drop a user if detailed logging is enabled for the user?   Thanks , Kishore
12803 Jul 2014 @ 12:26 PDTDatabaseReplyRuleType in tdwm.ruledefsCan anybody answer the above question. Thanks in Advance!
12702 Jul 2014 @ 02:44 PDTDatabaseTopicEnabling Permanent Journal FeatureWhich DBS Control Parameter should be enabled to enable Permanent Journalling at the system level in Teradata?
12630 Jun 2014 @ 12:16 PDTDatabaseTopicAccess Rights Validation PerformanceWhen 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...
12529 Jun 2014 @ 12:58 PDTDatabaseReplyDB 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...
12429 Jun 2014 @ 03:08 PDTDatabaseTopicDB Creation And AccountI 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...
12326 Jun 2014 @ 08:34 PDTDatabaseTopicRuleType in tdwm.ruledefsIn 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.
12224 Jun 2014 @ 05:51 PDTDatabaseReplyMonitor PartitionThanks Dieter!!
12124 Jun 2014 @ 02:13 PDTDatabaseTopicMonitor PartitionWe have the partition type DBC/SQL for SQL Sessions. What type of queries fall under the Monitor Partition in Teradata?
12018 Jun 2014 @ 04:00 PDTDatabaseTopicWD-Default WorkloadI 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...
11918 Jun 2014 @ 03:25 PDTViewpointTopicHot Standby NodesIn which portel in Viewpoint can we see HSN(Hot Standy Nodes) in the Teradata System?
11817 Jun 2014 @ 01:09 PDTDatabaseTopicFetching DBQLRules InfoI 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...
11715 Jun 2014 @ 09:13 PDTDatabaseTopic3883 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...
11615 Jun 2014 @ 09:11 PDTDatabaseReplyNew Stats Collection Process in Teradata 14.10Thanks Raja. Hope scheduling this report over a period of time will help us identify indexes that are not needed  and take appropriate action.
11514 Jun 2014 @ 10:45 PDTDatabaseTopicNew Stats Collection Process in Teradata 14.10Is there any relationship between ObjectUseCount feature and new stats collection feature in Teradata 14.10? If so, what is it?   Thanks in Advance!
11409 Jun 2014 @ 08:32 PDTDatabaseTopicDelay 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...
11306 Jun 2014 @ 02:13 PDTDatabaseReplyParameter Values in SYSLIB.AbortSessionsThanks Tom for going the extra mile and answering the question..
11204 Jun 2014 @ 07:27 PDTDatabaseReplyParameter Values in SYSLIB.AbortSessionsThanks 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...
11104 Jun 2014 @ 04:13 PDTDatabaseTopicParameter Values in SYSLIB.AbortSessionsWe 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 ...
11030 May 2014 @ 08:29 PDTDatabaseTopicIdentifying Single-AMP and All-AMP queriesIs  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?
10930 May 2014 @ 10:05 PDTDatabaseTopicCPU 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?

Pages