All comment activity

#DateUserWhereItemComment
623601 Sep 2015 @ 11:47 PDTmukuljain015carrie's blogTeradata Basics: ParallelismHey Carrie, Thanks for putting useful contents in the blog. my question is: how to disable throttle on TD-14.10 sles-11 System. I'm trying to deactivate throttle by several means but it's...
623501 Sep 2015 @ 04:27 PDTcarriecarrie's blogStatistics collection recommendations – Teradata 14.02% sampling should fine fine for a UPI column.  Sampling at low percentages is fairly accurate for any column that is unique or nearly-unique.   Unfortunately, there is no way I know of...
623431 Aug 2015 @ 08:55 PDTsteverViewpointViewpoint Integration with Apache Ambari for Hadoop MonitoringVersions are as follows, though I'm sure some variations in these versions would also work. Apache Commons Codec 1.6 Jackson 1.9.7 Spring 3.2.2
623331 Aug 2015 @ 02:55 PDTcarriecarrie's blogUsing IOTAs to Determine the I/O Utilization of Your WorkloadsIn the Workload Management Capacity on Demand orange book, there is an I/O throughput metric that can be used to assess I/O usage by workload.  See section 5.2 of this orange book.  ...
623230 Aug 2015 @ 04:29 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressPaul, You have misunderstood. The steps you mention are for installing Teradata Plugin for Eclipse, where a user would have an existing Eclipse environment and they want to add the Teradata functio...
623129 Aug 2015 @ 01:14 PDTarpitsinhacarrie's blogStatistics collection recommendations – Teradata 14.0Thanks Carrie; Got the point.   Actually our client was collecting full stats on this column(s) and I saw the opportunity to suggest them this feature. Next time onwards first I will read t...
623028 Aug 2015 @ 09:36 PDTmojaveToolsTransitioning from SQL Assistant to Studio ExpressI was initially really looking forward to exploring the capabilities of SQL Studio Express, but I’m going to have to pass due to the complexity of the Eclipse install, especially:   &n...
622928 Aug 2015 @ 09:52 PDTcarriecarrie's blogStatistics collection recommendations – Teradata 14.0Arpit,   USING SAMPLE specified on a collect statistics statement does not necessarily result in sampling taking place.   It means you are letting the optimizer decide whether or n...
622828 Aug 2015 @ 08:04 PDTvuyyuruToolsTeradata Parallel Transporter #1 – Basicscan we use update operator to load multiple files into multiple tables sequentially using the same tpt script. if so, can you please advice on this.
622727 Aug 2015 @ 04:07 PDTcarriecarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Atul,   Dictionary stats usually take only a couple of minutes to collect, as the tables tend to be small.  And you do not need to recollect them very often.  I am not aware of any...
622627 Aug 2015 @ 01:24 PDTtomnolanConnectivityHow to use the Teradata JDBC Driver with RThis blog entry by Andreas illustrates how to call JDBC API methods directly. https://developer.teradata.com/blog/amarek/2013/12/how-to-avoid-duplicate-jdbc-connection-created-by-rjdbc-dbconnect ...
622527 Aug 2015 @ 11:50 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressPat, To create a Generic JDBC connection profile, you want to first add (check the box) 'Generic JDBC' to the list of Connection Profile Types, on the New Profile Connection Types preferenc...
622427 Aug 2015 @ 10:20 PDTPat GoHabsGoToolsTransitioning from SQL Assistant to Studio ExpressBonjour Francine,   Need some hep here , I'm trying to set Teradata Studio Express on my Mac OS X Yosemite to connect a generic JDBC database. I just can't get to find where to decla...
622327 Aug 2015 @ 07:14 PDTalgis78ViewpointViewpoint Integration with Apache Ambari for Hadoop MonitoringHello,   can you tell me the versions which you had used in yor classpath of these imports:   import org.apache.commons.codec.binary.Base64; import org.codehaus.jackson.annotat...
622226 Aug 2015 @ 06:07 PDTabhishek.jadhavViewpointOverview of Teradata Viewpoint 15.10 Hi Shrity,   Now that viewpoint 15.10 has PDCR data maintenance job portlet will there be newer versions of PS provided PDCR scripts (is there a PDCR 15.10 version?)   ...
622126 Aug 2015 @ 11:36 PDTKaramToolsTransitioning from SQL Assistant to Studio ExpressThanks Francine. What are tentitive release dates for Studio 15.11 ?
622026 Aug 2015 @ 11:09 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressKaram, Setting and locking preferences at install time is a feature that is planned for Studio 15.11 release. So are looking to be able to lock the Result Set Viewer 'Max Display Row Count'...
621926 Aug 2015 @ 10:34 PDTanujhcarrie's blogUsing IOTAs to Determine the I/O Utilization of Your WorkloadsHi  carrie , do we have something simmilar for database version v 14.0 where we can look at the IO usage
621826 Aug 2015 @ 10:14 PDTKaramToolsTransitioning from SQL Assistant to Studio ExpressYes, one of analytics manager requirement is to allow only limited set of rows to a certain business group. I also tried TASM but it is dependent on explain estimates which can vary due to multiple...
621726 Aug 2015 @ 06:34 PDTarpitsinhacarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie,   One of my table having 2,132,426,728 rows in a column which is also UPI for this table. It is on TD 14.10. While collecting stats on this table(Column) it is taking ~14K CP...
621626 Aug 2015 @ 03:05 PDTag186070carrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi,   1 question. If we collect dictionary stats, will this collect stats impact the application performance in anyway? Do we need to test the application as a whole before implementing col...
621525 Aug 2015 @ 12:58 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressKaram, For Studio Express, this is controlled by the Result Set VIewer preference (default 2000) that users can change. Are you wanting a way to prevent a user from changing this preference value?
621425 Aug 2015 @ 12:44 PDTAshwin4teraDatabaseBasic Teradata Admin Tools - 2 Minute GuideGood Article! Kind quick Refrence!
621325 Aug 2015 @ 11:41 PDTKaramToolsTransitioning from SQL Assistant to Studio ExpressVery infomative arcticle .Thanks for sharing. One question for you Is there any way to control - Max Display Row Count on users machine? Scenerio is that I want only 2000 rows to dispaly for all a...
621225 Aug 2015 @ 09:39 PDTAlexander KConnectivityHow to use the Teradata JDBC Driver with RIs there any way to execute statements like "SET" and "DATABASE" through JDBC? After successfully establishing a connection in variable "conn", when I try to specify...

Pages