#DateForumTypeThreadPost
1428 Jan 2016 @ 02:40 PSTToolsReply Why USEXVIEWS=ON parameter has no effect on Teradata Studio ?Thanks you to both of you for your help. It's great. I can configure it in Teradata Datatools Preferences. There is a <select All VX Views> option to select. One last question if any i...
1325 Jan 2016 @ 03:35 PSTToolsTopic Why USEXVIEWS=ON parameter has no effect on Teradata Studio ?We cannot replace Teradata SQL Assistant and Teradata Administrator by Teradata Studio because the USEXVIEWS parameter has no effect on Teradata Studio. When I configure USEXVIEWS=ON in the JDB...
1225 Jan 2016 @ 03:30 PSTToolsReplyTeradata Studio - USEXVIEWSHi vinceBernard, Happy to see that I'm not alone on this question. Do you have an answer to your question 3 years after ? Because I'm VERY  interested to know if there is any soluti...
1126 May 2015 @ 05:56 PDTGeneralTopicInterpretation of PhysIOKB in dbc.QryLogStepsHello, I'm interested in the field PhysIOKB (dbc.QryLogSteps). It's based on the ExtraField30 in  DBC.DBQLStepTbl. As mentionned in the Database Administration documentation :...
1007 Jan 2015 @ 07:26 PSTToolsTopicHow can I perform the same with a TPT script ?Hello ,   I use very often this kind of code based on bteq export and I do not know how to turn it on TPT ? Thanks for your help bteq << E...
923 Dec 2014 @ 06:23 PSTToolsReplyHow to execute a macro using TPT operator?I don't know how but maybe someone have any suggestions on how to simulate condition based on ACTIVITYCOUNT anyway ? Because I really need to introduce a condition in my JOB   Thanks
817 Nov 2014 @ 05:57 PSTToolsReplyTPT Vs other ETL UtilitiesHello Feinholz, About DATA STREAM and internal memory considerations. We load the TERADATA by batch processing overnight. The system is configured with 20 simultaneous loads. We do it through UT...
706 Nov 2014 @ 02:09 PSTToolsReplyhow to select sessions,tenacity,sleep,checkpoint etc for fastload,multiload,tpump utilitiesHello, We implemented this new architecture in our system : Powercenter Realtime module received messages from MQ and each message is load in a TERADATA table using TPT STREAM operator. My quest...
631 Oct 2014 @ 05:57 PDTToolsReplySession and Checkpoint consideration in TTUs and TPThow can I manage the number of sessions used by TPT Streams ?   Unlike TPT Load operator, Stand Alone FastLoad or  Stand Alone MultiLoad, we cannot define a session limit for TPT STREAM...
510 Aug 2012 @ 05:21 PDTConnectivityReplyLaddered Concurrent Connect (LCC) Thanks you vhari.   One more question on your article : I quote : "3.  ODBC connects to MULTIPLE nodes based on the a specified Delay Internval" Can you tell ...
408 Aug 2012 @ 08:26 PDTConnectivityTopicLaddered Concurrent Connect (LCC) Thank you Darrick S, vhari, steveg for your article on Laddered Concurrent Connect (LCC): Client Performance Improvements http://developer.teradata.com/connectivity/articles/laddered-concurren...
316 Feb 2012 @ 04:36 PSTToolsReplyTransformations in TPT Hi mutador,   I'm looking for the same thing. There are no example on TPT's typical use.   Is there someone who can give us an example which illustrate the ...
221 Jun 2011 @ 03:20 PDTDatabaseReplyThoughts on CPUBusy caclulations.Hi all, Can someone help me to understand the AMPCPUTime define in dbc.dbcqlogtbl ? Is it correctif I try this approach : AMPCPUTime = CPUUExec + CPUUServ ? thanks for your help
107 Apr 2011 @ 01:51 PDTDatabaseReplyResponse Time, CPU Disk Ratio.Hi, I got the same error : "Request aborted by TDWM. Exception criteria exceeded: Response Time." The request has been delayed because I have defined a throttle on a query limit. But after...