#DateForumTypeThreadPost
1205 Jul 2015 @ 08:12 PDTDatabaseReplyErrormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10Not sure if anyone ever saw a fix for this issue, but I encountered the same issue when upgrading TTU 13.10 to 14.00, and 14.10 and 15.00. For me, i was able to use BTEQ from the commanf line only ...
1124 Jun 2015 @ 06:42 PDTToolsReplyBTEQ and the Commit statementHi, I have noticed that when using .Net in SQL Assistant and ANSI mode, that a replace view adds a COMMIT WORK to the end of the definition of the view. This then results in a failure if you call t...
1002 Mar 2014 @ 05:15 PSTViewpointReplyMigrating to new Viewpoint serverHi gryback,      We have 2 physical Viewpoint servers, one on V14.00.00.07 and our new one on V14.11. We are in the process of getting both updated to the latest certified patc...
928 Jul 2013 @ 11:27 PDTDatabaseReplyTeradata system dictionary Backup by NetvaultYou should also check to see if your dictionary job is being blocked by other running jobs. We see this quite often and our normal dictionary backup of 45 minutes can end up taking up 2-3 hours or ...
830 Mar 2013 @ 05:21 PDTGeneralReplyROW_NUMBER() OVER (PARTITION BY col1,col2.... order by col1)How do we use Row_Number if our rows returned ends up larger than the 'Integer' limit on it?
709 Dec 2012 @ 05:15 PSTViewpointReplyViewpoint - 14 - Query Monitor issueWe have also discovered an issue with Query Monitor in Viewpoint 14.00 - When the system is very busy, we notice that some sessions do not refresh the Explain or the SQL code. We only pick up the c...
627 Sep 2012 @ 08:17 PDTViewpointReplyWorkload Designer - Using Time PeriodsThanks, you were right about the Allocation Groups. I visited another Teradata site and got put back on the right track by reviewing how their system was setup.
512 Aug 2012 @ 08:04 PDTViewpointTopicWorkload Designer - Using Time Periods Hi, I am a little confused in how to setup a simple workload period and configure it for changes to allow different workloads to have different resource allocations at different times of the day...
407 Aug 2012 @ 06:06 PDTViewpointTopicUpdating Metrics Analysis Portlet to ignore FICON Nodes Hi, Can someone advise if it is possible to remove the FICON Nodes from being analysed in the Metrics Analysis Portlet? We currently have 8 Processing Nodes (with AMPS) and 2 FICON Nodes (no AMP...
307 Aug 2012 @ 05:59 PDTViewpointReplyCan Teradata Development Porlet (Come with PDK) be setup for real Data Collection? On the flip side to the this, if we have already created a portlet using the PDK, how to we export this for use on the actual Viewpoint server? Is this porcess documented somehwere also?
210 Jul 2012 @ 04:39 PDTDatabaseReplyError 3523: Error calling stored procedure from stored procedure Hi, I do not see any mention of a fix for the issue described, was one found? We have exactly the same issue, but it only occurs on our PROD system and not on our TEST system - both are runn...
119 May 2012 @ 04:38 PDTToolsReplyWDID in tables? What table has replaced Wlcdefs in Teradata 13.10? I want to be able to map WDID from Querylog with the workload name so I can determine who is still coming in the default workload?