#DateForumTypeThreadPost
808 Jun 2015 @ 07:44 PDTViewpointTopicVery long running queries impacting performance due to frequent re-classificationWe have a relatively large datawarehouse (V14.0 Viewpoint V14.10 SLES 10). We have a problem with certain types of query and certain source tables that causes us tremendous problem with regards sy...
712 Jan 2015 @ 07:05 PSTDatabaseTopicDeleting taking an excessive amount of time from a table with a Join IndexHi All and a Happy New Year.   We have a new requirement to place a Join Index (that also happens to be ML-PPI) over two tables to aid performance for a Tactical Workload. The JI works well ...
606 Feb 2014 @ 06:39 PSTViewpointReplyTASM Workloads and frequent demotionsWe have a let's say "challenging" workload. Andy know's as we both worked on the same datawarehouse. As Andy says statistics are imperative and collection schedule is too. Collect...
526 Jul 2013 @ 07:12 PDTThird Party SoftwareTopicCOGNOS RetryHi All We have a situation where a COGNOS user is submitting many queries to our live service and TASM is, correctly, placing them in the delay queue, once our concurrency throttle has been r...
409 Apr 2013 @ 08:28 PDTThird Party SoftwareReplyCompatibility: TD12 - Datastage 8.7Correct according with the Interoperability Matrix but check with IBM themselves as they carry out the certification it may be a combination they have not considered.
309 Apr 2013 @ 08:06 PDTThird Party SoftwareTopicAB Initio / Teradata CompatibilityHi All I am conducting the latest upgrade to our Teradata enviroments and struggling to find details of Ab Initio / Teradata Compatibilty. I have checked the latest Interoperability Matrix on T@YS...
226 Feb 2013 @ 06:59 PSTGeneralTopicWhere is TASM state change information written to??Ahhh!!   I am looking to extract the timestamp of when TASM switches to the Overload state but I cannot find which DBC table holds this information. Can anyone help please.   Nick
102 Jul 2012 @ 05:45 PDTViewpointTopicQuery Throughput and comparison to Viewpoint I am trying to analyse the load on our box for comparison with pre and post upgrade but the query volumes I am extracting are no where near the volumes being reported in Viewpoint by an order of...