#DateForumTypeThreadPost
1001 Oct 2015 @ 05:10 PDTDatabaseReplyBackup and Restore only statistics in TeradataHi Glass, I have copied tables from production to development but stats are not being copied and it is telling "there are no statistics defined" but the table in production has stats def...
921 Jul 2015 @ 03:04 PDTDatabaseTopicsize mismatch in tablesHi, I create a table in TMP database same as it is in DBname database(production DB). The new thing i saw here is Size mismatch. Both  table12 and table1 has same records still table1 is sho...
825 Sep 2014 @ 08:03 PDTUDAReplyQuery TuningWhat is the alternate of distinct, by what we can replace distinct and tune the query?  didnt get this point  4. if there are UNION operations as opposed to UNION ALL and also disntinct...
701 Sep 2014 @ 09:21 PDTViewpointTopicTo set a new Throttle LimitHi everyone, If I want to change system throttle limit for rule Medium_1 (suppose there are high number of delays in Medium_1) then what are the parameters should be cared of before changing and h...
605 Aug 2014 @ 12:29 PDTViewpointTopicCPU, CPU USE, CPU SKEWHi Guys, I am trying to understand the defintion of CPU, CPU USE, CPU SKEW, IMPACT CPU. I have referred viewpoint manual for this but still not able to grab it. Can anybody explain how these ...
529 Jul 2014 @ 10:20 PDTViewpointReplyPDCR Vs Viewpoint@krishaneesh  Thanks for response. Yes I havent used PDCR @gryback What should I do for system slowness issue. I also read ur article for viewpoint in different points of view where you tol...
429 Jul 2014 @ 12:32 PDTViewpointTopicPDCR Vs ViewpointHi everyone, Currently I am using Viewpoint V14.10 for monitoring and also feel everything fine. We find bad queries, diagnose system health and much more.  Amonst all most helpful thing is w...
310 Jul 2014 @ 02:41 PDTDatabaseReplySELECT failed 7453 : interval field overflowHey, Thank u so much.Really helpful!! but what if i write this ------------------------  LOCKING ROW FOR ACCESS SELECT count(1) FROM DBC.DBQLOGTBL WHERE CollectTimeStamp between '20...
209 Jul 2014 @ 11:33 PDTDatabaseTopicSELECT failed 7453 : interval field overflow I want to get querycount which ran less than 30 secs, For that I wrote this query but its giving SELECT failed 7453 : interval field overflow. For that I tried to fetch record for five days only...
108 Jul 2014 @ 12:15 PDTGeneralTopicOne of the fast Export session has been logged offHi All, My FastExport query failed twice both times the error in the log file was ‘RDBMS Error one of the FastExport session has been logged off’.     Kindly provid...