All comment activity

#DateUserWhereItemComment
661025 Mar 2016 @ 08:10 PDTcarriecarrie's blogStatistics collection recommendations – Teradata 14.0Robin,   By any chance are you collecting statistics with the USING SAMPLE option? If sampled stats are being collected on a NPPI table, when you change to a PPI table the optimizer may deci...
660923 Mar 2016 @ 03:29 PDTrobing9carrie's blogStatistics collection recommendations – Teradata 14.0Hi I converted a Non Partitioned table to a Partitioned table (both same index). in the partitioned table i added new Stat Column(Partition).   I found that the new table (PPi) took more ti...
660822 Mar 2016 @ 01:24 PDTspbalucarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadCarrie, Couple of questions -  Does setting up parsing only workload help the tactical query in any way? Also, when you setup criteria for parsing only workload as  Username = *, Acco...
660721 Mar 2016 @ 11:51 PDTahmad.mahmood40ravi.koone's blog.NET Data Provider for Teradata supports Visual Studio 2012 and 2013how to use that in c# code. if you tell me the method then it should be very helpful
660621 Mar 2016 @ 02:01 PDTgeethareddycarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeThank you for your comments Carrie, On my 2nd question, here is what i am trying to understand. Until 13.10 Version,  I used to see the CPUTime column result in Milli seconds (which is also ...
660521 Mar 2016 @ 11:02 PDTwmmiteffConnectivityTeradata Mainframe Client Utilities updateWas the compiler for BTEQ change with TTU 14.00 or was this done later? I am currently using 14.00 and upgraded to 15.10 now we are seeing issues with BTEQ output files that are not defined as...
660421 Mar 2016 @ 10:32 PDTsuhailmemon84carrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXThank you Carrie.
660319 Mar 2016 @ 08:28 PDTcarriecarrie's blogConverting CPU Seconds, Old Node Type to New Node Type Geeta,   The reason  CpuTime was removed was because it was duplicating the information provided by the sum of the other fields.  We were reducing the cost of the SPS tabl...
660218 Mar 2016 @ 10:03 PDTmh151012ToolsWhat's New in 15.10 for Teradata OLAP PortfolioThis location should be used for questions concern Teradata OLAP Portfolio.  For specific questions regarding Teradata Database releases, please refer to the Database section in DevEx  
660118 Mar 2016 @ 08:08 PDTsekharg9@hotmail.comToolsWhat's New in 15.10 for Teradata OLAP PortfolioHi All, We are upgarding our applicance from teradata 14 to 15 , I need to list of the befints of upgrade - Teradata V2R14 vs Teradata V2R15. Thanks
660018 Mar 2016 @ 04:49 PDTmd186053ToolsTeradata Debugger for C/C++ UDF 15.10.01 Eclipse Plug-in now availableHi , I am following C/C++ UDF Installation Guide to configure my eclipse. I am getting follwoing error in section in chapter 3 while installing plug-in http://downloads.teradata.com/download/cdn...
659917 Mar 2016 @ 04:08 PDTgeethareddycarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeHello Carrie, Recently, I have noticed the CPUTime Column is not available on 14.10 ResUsageSPS table (which was there in 13.10 SPS Table).  Please have a glance on my understanding is ...
659817 Mar 2016 @ 09:00 PDTcarriecarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXSuhail,   In order to force TPT Update jobs to use MLOADX you would have to change the DBSControl Internal field 296 to 2.      296. MLoadProtocol - This field ena...
659717 Mar 2016 @ 02:03 PDTpietro.nardellaViewpointIntroduction to Viewpoint 15.11 MobileHi Craig, sorry if my comment is out of topic. We are running viewpoint 15.10 on TD 15.0. Is there a way in viewpoint to discover on what table we are loading data with Multiload/FastLoad ? ...
659616 Mar 2016 @ 11:36 PDTsribmsceConnectivityTeradata Connector for Hadoop now availableHi, I am also facing this issue with delimiter \r and \n and don't find any solution for it. TDCH does not support the feature  --hive-drop-import-delims yet as far i tested. I have TDC...
659516 Mar 2016 @ 04:38 PDTWillimoaExtensibilityIn database linear regression using the CalcMatrix table operatorGreat Articles Mike.  Keep up the good work.
659416 Mar 2016 @ 03:30 PDTODBCTeamODBCTeam's blogPerl with Teradata ODBCHi Brandon, You are correct, it is not necessary to use DataDirect DM. However, it is the only ODBC Driver Manager on Linux/Unix supported by Teradata. We do not support unixODBC DM at this po...
659316 Mar 2016 @ 11:28 PDTbrandonwagnerODBCTeam's blogPerl with Teradata ODBCIs it really necessary to use the DataDirect DM? I have had success using the standard unixODBC DM...without altering the Makefile. 
659216 Mar 2016 @ 09:35 PDTsuhailmemon84carrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXHi Carrie, is there anway to enforce the usage of MLOADX even though the target table does not have any USI/RI/JI? We're in the process of converting few of our MLOAD jobs from legacy multiloa...
659114 Mar 2016 @ 09:38 PDTpietro.nardellaViewpointOverview of Teradata Viewpoint 15.10Hi Shrity, we are running viewpoint 15.10 on TD 15.0. Is there a way in viewpoint to discover on what table we are loading data with Multiload/FastLoad ? I use remote console utility -> query...
659014 Mar 2016 @ 05:32 PDTpadhiaODBCTeam's blogPython with Teradata ODBC It's good to know that Teradata ODBC drivers work with unixODBC DM. The article suggests that unixODBC DM on Linux is not supported. I wasn't sure if it was possible to have both DataDirect...
658909 Mar 2016 @ 02:52 PSTODBCTeamODBCTeam's blogPerl with Teradata ODBCHi Milan, At the bottom of your post, you said "I think this is due to this missing line...". Did you make the changes to Makefile.PL as described in the article? Did you succeed or did ...
658808 Mar 2016 @ 06:49 PSTalirana78keep it simpleExtract and Analyse Database Object DependenciesThank you for the answers and the reference links. i am going to be checking on the Teradata MDS suite to see if we can obtain that with the install free of charge so that this type of analysis can...
658708 Mar 2016 @ 09:03 PSTmbudkaODBCTeam's blogPerl with Teradata ODBCHi, I’ve trouble with configuration of Perl (5.22) DBD::ODBC (1.52) and TTU 15.10 on Solaris 11.2 .  Description of issue  TTU installation of ODBC is OK:  export ODBCINI=/...
658608 Mar 2016 @ 12:12 PSTulrichkeep it simpleExtract and Analyse Database Object DependenciesHi Ali, I guess it will become a challange to do what you want based on DBC infos. You might check the infos in the DBQL object view. But this requires that DQBL object logging is on and that you ...

Pages