#DateForumTypeThreadPost
3110 Oct 2014 @ 08:57 PDTViewpointReplyPortlet Lock Viewer no show dataHi, maybe you could point (and add) the following rights (Database side) : grant execute procedure on locklogshredder to "viewpoint"; grant create table on "viewpoint" to lo...
3002 Sep 2014 @ 01:46 PDTDatabaseReplyTemporals and Outer JoinsHi, what about TEMPORAL DATA and OUTER JOINs today on V14.10 ? i am facing some cases of requests ending with 3610 error and crashdumps, with a stack of views on temporal tables, each view based ...
2930 Jul 2014 @ 03:22 PDTViewpointReplyHow can i download viewpoint pdk api?Hi Gary, how to get out of Viewpoint interface a list of roles , a list of roles and users links or a list of roles and permissions, all that sort of documentation for helping not to run through p...
2818 Jul 2014 @ 06:08 PDTTeradata StudioReplyCan't create User from Teradata Studio UIHi, how to get "Teradata Studio for administrative functionality" ? i just installed STUDIO Express V15.00 (on a V14.10.0.4 platform) and i do not find the Administrator perspective: t...
2702 Jul 2014 @ 05:26 PDTDatabaseReplyGetting error while copying data from one temporal table to other temporal tablePrathap,   i experimented that situation, sort of a confusing mix of INSERT (into a non temporal data in my test) and SELECT from a temporal data. You could try with a derived table: "...
2616 May 2014 @ 08:38 PDTDatabaseReplyCalculation SkewHi, I send again my previous question about TD ADMIN (14.10) not displaying some tables ( "Table Space" option): some empty tables are not displayed , even small tables (2 lines) are n...
2516 Apr 2014 @ 03:10 PDTDatabaseReplyExplain PermissionsHi Tom, what about your demand on "GRANT EXPLAIN ..." ? Some news for V14.10 Users maybe ? Pierre
2416 Apr 2014 @ 01:39 PDTDatabaseTopicSPOOL estimation (Explain) and SPOOL value (QRYLOG)Hi spool watchers, As an exercise i picked up a user request that runned in 53 minutes with an actual spool of 1,5 TO (query monitor V14.10) and tried to optimize. After explaining the query and ...
2327 Mar 2014 @ 06:53 PDTDatabaseReplySQL Issue - Qualify partition by issueHi Adeel, i just experiment the same issue on Acctg table (V14.10): rows are multiplied by the number of AMPs !!! SELECT  AccountName ,USERNAME ,SUM(CPUNorm)  over (partition by A...
2216 Oct 2013 @ 06:09 PDTDatabaseReplyHow to find a third lowest salary without RANK or TOP functionHi, did you try with a window function ? -- Partition by Department qualify row_number() over(partition by Department order by Salary_Amount) < n -- NO Partition at all qualify row_number(...
2107 Oct 2013 @ 07:15 PDTDatabaseReplyORPHAN ACCESS RIGHTS - HOW TO DELETE ?Hi Dieter, considering the two options i decided to drop/create the user, and no "bypass" ;-) DU/CU is a good way to get the dbc.accessrights table clean, just waiting a few minute...
2002 Oct 2013 @ 01:40 PDTDatabaseTopicORPHAN ACCESS RIGHTS - HOW TO DELETE ?Hi, I just found a USER with more than 160 000 rows in DBC.ACCESSRIGHTS (skew is 88 !): the main part of those rows are orphan rights with createtimestamp dating of 2005 , 2006 ... before migratio...
1909 Jul 2013 @ 08:34 PDTViewpointTopicVIEWPOINT frozen for 3 hoursA noticeable event early in the morning (time of Paris): it looks like Viewpoint stopped collecting data between 5:51:00 AM and 8:51:00 AM. Activity is logged in LOGONOFF and DBQLOGTBL ta...
1812 Feb 2013 @ 07:05 PSTDatabaseReplyHow to check access privileges?? Hi, I just wonder how to make sure of privileges granted to a user: As a common rule on our site Users are granted on "all" (the whole Database objects) via Roles, i...
1706 Dec 2012 @ 08:00 PSTViewpointReplyProductivity Portelet - QPH metricsWell, maybe the Query logging threshold (5 sec. CPU) could be an explanation ... Subject closed during investigations ... Pierre
1605 Dec 2012 @ 05:24 PSTViewpointTopicProductivity Portelet - QPH metricsHi, Productivity portlets has a pretty good display of the activity in terms of Applications and number of Query per Hour (QPH). But ... i can't explain the QPH metrics: when requesting on QR...
1527 Jun 2012 @ 05:57 PDTViewpointReplyViewpoint CHANGE PRIORITY command Steve, Some details and news: one attempt to change priority at session level for a user was successful, and a second one too for another session of the same user, but no way to change other...
1419 Jun 2012 @ 02:25 PDTViewpointTopicViewpoint CHANGE PRIORITY command Hi, I have experienced some difficulties when trying to change the priority of a session (Viewpoint 13.11 previously and now Viewpoint 14): sometimes it works, most of the time it doesn&...
1318 Apr 2012 @ 10:03 PDTDatabaseReplySQL History Hi everybody, I use to request on dbc.qrylog (v13.10) for a while, and i just wonder why "NumResultRows" is never filled (SpoolUsage is OK). Something i missed ? another column...
1227 Mar 2012 @ 08:48 PDTConnectivityReplyExcel Connector for Teradata That's it ! you can do it via Ms-Query (ODBC), From Excel sheet ("2003" version): Menu Data, External Data, Create a request (or modify a request), Choose a data So...
1127 Mar 2012 @ 06:52 PDTConnectivityTopicHow to restrict connection according to IP adress or Client Hi, a somewhat odd question about a simple method to restrict (inhibit) connection using a "production" User that is over-used among developpers (everybody knows User and Pwd). ...
1018 Jan 2012 @ 03:50 PSTDatabaseReplyDifference of rows in SELECT COUNT(*) and SELECT * Clear, thank you Ulrich, Pierre
918 Jan 2012 @ 01:23 PSTDatabaseReplyDifference of rows in SELECT COUNT(*) and SELECT * Hi, I have the same interrogation: LOCKING ROW FOR ACCESS is said to be the best ... but why ? Doc is not so much clear about that: "Locking an entire base table across all AMPS...
807 Oct 2009 @ 04:26 PDTThird Party SoftwareTopicConnect INFORMATICA PowerCenter to TERADATAHi, this is a second post, looks like the former one is lost ... an attempt to connect INFORMATICA to TERADATA via ODBC returns an error : [DataDirect][ODBC Teradata Client driver][Teradata]Th...
713 Aug 2009 @ 02:32 PDTDatabaseReplyIDENTITY COLUMN - 5753 error messageHi Dieter, Thank you for your clear and comprehensive comment on the topic ! i was lost on a bad track ... Some requests from two sessions achieved to illustrate the way it works: Identity colu...

Pages