#DateForumTypeThreadPost
1930 Oct 2015 @ 12:37 PDTDatabaseReplyTracing stored procedure parameter values you need to enable this replace Query Logging with PARAMINFO on ALL; (or specific account you would like to).   The only issue i had is that i can trace any store proc parameters e...
1818 Jun 2013 @ 08:46 PDTDatabaseReplyMERGE vs UPSERTHow can i do an upsert into teradata table(DEV) by comparing PRD table. Looking for a way to synch DEV table to PRD table and make them identical as there are some changes made to the existing...
1717 Apr 2013 @ 04:47 PDTDatabaseReplyRevoking All Access Rights For Usersis it possible to revoke access to everyone on a database?
1615 Jan 2013 @ 07:13 PSTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data fileIs there a way to diasble the fall back option for fastload error tables? It seems like by default error tables will have fallback option enbaled in 13.10.
1513 Aug 2012 @ 07:20 PDTDatabaseTopicTeradata 13 Vs 14 Can someone please layout any major differences with these 2 versions or point me to any document that shows the every change. I have read few details about that but wanted dive into more d...
1418 Jun 2012 @ 11:54 PDTToolsTopicRDBMS error 2633 Too many load/unload task running I am getting this error when i try to run a fastload job specifying just 1 session in the script. I know there is a limitation of 30 load jobs on the applicance and so when i checked on viewpoin...
1311 Jun 2012 @ 11:02 PDTDatabaseTopicImport/Export from Teradata to SQL Server we have been moving data using SQL Server using Linked Server(ODBC driver) and TPT using attunity but these 2 options are very slow in speed. Is there any other method or may be some 3...
1230 Apr 2012 @ 08:31 PDTToolsReplyFastload error-Kindly Help!! How can i find maximum allowed sessions on my system. If a fload script doies not mention session number how many sessions it would take to run the load on a 12 node system.
1124 Apr 2012 @ 06:22 PDTToolsTopicBest Practice - Client Tools What is the best practice to use SQL Assitance and Teradata Manager from end user point. Currently we install all client tools on a windows VMware machine and all the users access the tools by R...
1019 Jan 2012 @ 12:51 PSTDatabaseReplyPerformance problem that makes sense i agree but in this situation what are the options i have to gain performance.
919 Jan 2012 @ 07:03 PSTDatabaseReplyPerformance problem 80% of the records has 1 and the rest 0 but most the time we qry on 1.
819 Jan 2012 @ 06:29 PSTDatabaseReplyPerformance problem yes, i tried that already it does not make any difference.
719 Jan 2012 @ 03:13 PSTDatabaseTopicPerformance problem I have a table of 2tb with MV compression and when i do a query using a where clause of an indiacator which has just 2 values either 0 or 1, the performance is really bad there is a difference o...
621 Oct 2011 @ 10:11 PDTViewpointReplyMyQuery Portlet setup. yes i do, though i was thinking all other tabs would appear only if the threshods are met but i am assuming SQL and EXPLAIN tab has to appear by default.
521 Oct 2011 @ 07:11 PDTViewpointReplyMyQuery Portlet setup. Thanks Steve, i got that. Also when i drill down to a session except the overviee tab all other tabs(explain.sql,queryband etc ) are grayed out, is there any setting that i have to enable for th...
420 Oct 2011 @ 11:54 PDTViewpointReplyMyQuery Portlet setup. I am in the same situation, did you get it resolved?
327 Sep 2011 @ 08:49 PDTViewpointTopicInfo on Viewpoint Database I think viewpoint miantains its own database in Postgre, is there a way i can find details about that database and query it? Also i would like to know the capacity limit of the database
217 Sep 2011 @ 07:31 PDTDatabaseTopicUnderstanding Spool Space Need some clarity on spool space allocation. 1. Lets say i have a user "user1" has a perm space 100gb and spool space 500gb (shared between 10 users) and user1 has a...
131 Aug 2011 @ 10:24 PDTDatabaseReplyAdding Compression to existing table I think this should be fixed in 13.10, right?