All comment activity

#DateUserWhereItemComment
658507 Mar 2016 @ 05:34 PSTalirana78keep it simpleExtract and Analyse Database Object DependenciesUlrich this is a great article and i have used part of your code to generate a heat map on the table as well as semantic view level based on analytic users. is there a way we can develope a metadat...
658407 Mar 2016 @ 05:32 PSTalirana78keep it simpleExtract and Analyse Database Object DependenciesUlrich this is a great article and i have used part of your code to generate a heat map on the table as well as semantic view level based on analytic users. is there a way we can develope a metadat...
658307 Mar 2016 @ 01:11 PSTfrank101ConnectivityTeradata Connector for Hadoop now availableAnand, You mentioned that hive-drop-import-delims has been solved in TDCH v1.4 which I could not find it. Could you please point me the right direction. Thanks. 
658207 Mar 2016 @ 09:45 PSTcarriecarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightTheTime is defined in the Resource Usage Macros and Tables  manual as:  Nominal time of the log entry.   Since the log entry is not made until the end of the interval, this me...
658106 Mar 2016 @ 03:00 PSTStevenSchmidcarrie's blogThings that Run in the Session WorkloadThanks Carrie, I didn't have a Teradata Sytem available to check the actual settings. Cheers
658004 Mar 2016 @ 03:32 PSTraywonqaToolsGetting Started with Teradata Plug-in for EclipseAfter installing the teradata plugin in Eclipse 4.5 Mars.1, the workspace launcher no longer appears when one starts eclipse.  Eclipse always defaults to the default workspace. The Eclipse sta...
657904 Mar 2016 @ 10:13 PSTcarriecarrie's blogThings that Run in the Session WorkloadSteven,   If you want to add target criteria to a workload so that all stored procedure CALL statements will run there you would select Target Critieria, then Stored Procedure in the drop do...
657804 Mar 2016 @ 06:59 PSTbrokenp87carrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightOne question, when the value of TheTime is '04:10:00.00' all the data regarding awts refers to the interval from 04:00 to 04:10 or refers to the interval 04:10 to 04:20?
657703 Mar 2016 @ 03:22 PSTcarriecarrie's blogRejection CAN be RewardingAmar,    You need to add the table as target selection criteria first, then specify no table scans as subcriteria to that table:   If you want the filter rule to apply only to fu...
657603 Mar 2016 @ 01:29 PSTfgrimmerToolsTeradata StudioJoseph, Yes. Once you have exported your history file from SQL Assistant, on the Studio SQL History toolbar there is an Import button that will prompt you for the SQL Assistant History file locatio...
657502 Mar 2016 @ 09:34 PSTjosephmichael.navarroToolsTeradata StudioIs there a way to import Query History from SQL Assistant to Teradata Studio?
657402 Mar 2016 @ 01:06 PSTamar3009carrie's blogRejection CAN be Rewarding Hi Carrie,   Hope you are doing good. I would request your help here.   I am trying to avoid Full Table Scans on one of our big tables. I tried to create a filter, but ...
657301 Mar 2016 @ 08:14 PSTStevenSchmidcarrie's blogThings that Run in the Session WorkloadHi Carrie Thanks the article, very informative as always. Do you think we could classify the "Call" stored procedure statement in the parsing only workload as AMPCPUTime is usually 0, o...
657229 Feb 2016 @ 02:21 PSTJohnHolmesODBCTeam's blogPython with Teradata ODBC The instructions say: Update the lines as follows: extra_compile_args = None extra_link_args = ['-L/opt/teradata/client/15.10/lib64'] Is that for 2.1.6 only?  "e...
657129 Feb 2016 @ 11:41 PSTjanusODBCTeam's blogPython with Teradata ODBC I have used the Teradata ODBC drivers with unixODBC multiple times before, never had an issue. Are you reffering to a specific problem?
657025 Feb 2016 @ 05:11 PSTpadhiaODBCTeam's blogPython with Teradata ODBC Is it correct to assume that there cannot be more than ODBC Driver Managers installed at the same time? Since Teradata doesn't support unixODBC on Linux, does this mean unixODBC will need to be...
656925 Feb 2016 @ 08:28 PSTcarriecarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10There is no method for just collecting incremental statistics on Teradata currently.   You can collect stats on expressions starting in 14.1, but that will not help you with a partitioned...
656824 Feb 2016 @ 01:56 PSTKishore_1ExtensibilityBlock Level Compression evaluation with the BLC utilityWhy divide by 96000 when calculating Minimum_Sample_Fraction?
656722 Feb 2016 @ 06:35 PSTgeethareddyViewpointAn Overview of the new Viewpoint 15.11 DashboardNice article. From the Viewpiont 15.10 version, via Alert Viewer portlet we cannot go back more than "Last 1 Week". Is that limitation still applicable in 15.11 version? And is the...
656622 Feb 2016 @ 03:18 PSTTDThrottlecarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10Thank you Carrie. In Teradata, do we have any way to collect statistics for a particular day/incremental statistics for Partitioned Tables. Some thing similar to Incremental Gloabl Statistics...
656522 Feb 2016 @ 10:47 PSTHarshaKudumulaRaising IntelligenceRaising Intelligence - Viewpoint DCS UsageThank you, Gary.
656422 Feb 2016 @ 09:43 PSTgrybackRaising IntelligenceRaising Intelligence - Viewpoint DCS UsageThe amount of data generated is dynamic based on the system query activity and how often it is being collected. I was going to suggest the easiest way would to determine the space consumption would...
656322 Feb 2016 @ 08:54 PSTHarshaKudumulaRaising IntelligenceRaising Intelligence - Viewpoint DCS UsageGary, Thanks for immediate response. I too agree that it is totally client requirement. But as you mentioned i am recommending the client to set the value based on time period (set to 6 months) i...
656221 Feb 2016 @ 08:13 PSTgrybackRaising IntelligenceRaising Intelligence - Viewpoint DCS UsageThere is no recommended retention because it is specific to the customer environment and not only the desired length of data retention but how much data is generated per collection, what is the fre...
656119 Feb 2016 @ 08:17 PSTHarshaKudumulaRaising IntelligenceRaising Intelligence - Viewpoint DCS UsageGary, Very nice ariticle. In our current system, we defined 10 GB to purge session data in data collector. Due to that it is holding only 1 month of production session history data. i am recommen...

Pages