#DateForumTypeThreadPost
1121 Jan 2013 @ 02:02 PSTDatabaseTopicCompression - BLC and MVC All, I see the following disclaimer in the AtanSuite Compression tool. "Tables using block level compression should not be selected." Currently we are on appliance which has block leve...
1011 Jan 2013 @ 07:46 PSTDatabaseTopicMERGE-INO  I am trying to convert the below INSERT and UPDATE statements in to one merge-in SQL so that I can save some CPU and TIME but nothing is working as expected. Any help is greatly apprecia...
905 Dec 2012 @ 04:32 PSTDatabaseTopicCan I activate a new TASM rule via SQL?All, I know that we can activate a state via store proc but I wanted to know whether we can activate the ruleset itself via any sql or commands at console?
819 Nov 2012 @ 06:06 PSTDatabaseReplyAccount Strings - AGThanks Dieter.  As we are on Appliance box we dont have full blown TASM (just filters and throttles; no workloads). In the QryLogExceptions, I just see the exceptions for the filters that we ...
719 Nov 2012 @ 03:30 PSTDatabaseTopicAccount Strings - AGAll, My system has the SCHMON settings (default) show below:   ----------------- Id  Partition Name    Weight  Limit  0  Default   &nbs...
615 Nov 2012 @ 12:36 PSTViewpointReplyWorkload Designer and Viewpoint 14 with RDBMS 13.10 errorThanks Gary. Teradata support asked us to drop TDWM database and rerun the DIPTDWM and I did it but to my surprise I am still getting the same error after the DIP. Also the globalparams still show...
514 Nov 2012 @ 04:07 PSTViewpointReplyWorkload Designer and Viewpoint 14 with RDBMS 13.10 error  Mark, Currently we are having the same issue. We moved from TD 13.0 to TD 13.10 and ran the DIPTDWM but we are still getting the error.  Wondering how were you able to resolve this i...
431 Jul 2012 @ 08:23 PDTUDATopicRelease all queries from TASM Delay Q Hi All, Wondering is there a way to release all the users at once from the Delay Queue?  
308 Feb 2012 @ 11:24 PSTUDAReplyParsing/Response Thanks Rob. For the second question (Parsing), the explanation that you gave is what exactly ran through my mind but I was doubting since Teradata wouldnt want the 'syntax errored' q...
203 Feb 2012 @ 01:20 PSTUDATopicParsing/Response Hi All, I've two questions: For a query, which is in responding mode, does increasing the priority (Higher Workload) help? When does the parsing happen for the query in TAS...
120 Nov 2011 @ 07:33 PSTDatabaseTopicResponse mode Does bouncing the TASM Workload to a higher pace for a query that is in response mode helps to peform the query better?