All comment activity

#DateUserWhereItemComment
663507 Apr 2016 @ 11:01 PDTmvuToolsLarge Object Loading with Teradata Parallel TransporterCan I see your TPT script?
663407 Apr 2016 @ 07:33 PDThemanshpToolsLarge Object Loading with Teradata Parallel Transporter I am trying to execute the TPT script for loading data to table having BLOB datatype from a Binary file. Note – The file is in binary format and does not have any delimiter,   ...
663307 Apr 2016 @ 07:31 PDThemanshpToolsLarge Object Loading with Teradata Parallel TransporterHi All,   I am receiving the below error which moving the data from binary file to BLOB datatype table. TPT19112 Variable (VAR) field length error. Expected maximum length 1024, Struc...
663207 Apr 2016 @ 07:26 PDTcsbandi5426carrie's blogEasing Into Using the New AutoStats FeatureThank you very much Carrie.
663106 Apr 2016 @ 09:29 PDTfgrimmerToolsTeradata Studio ExpressAmrutha, It sounds like you will need to GRANT create for the user. Please refer to the Teradata documentation regarding security administration. Teradata Studio provides dialogs to help with datab...
663006 Apr 2016 @ 03:21 PDTAmruthaAneppilToolsTeradata Studio ExpressHi, I have recently installed Teradata express 15.10.0.7using vmware and installation went successful. When i access Teradata Studio express inside it, i am not able to run any create table SQL du...
662906 Apr 2016 @ 02:54 PDTmanasrAsterIntroducing Aster LensHi, I am using aster lens for path analysis, specially the tree and sankey charts. The path consists of how the customer interacts with the company (visited shop, called customer service). Is it p...
662805 Apr 2016 @ 08:19 PDTHarshaKudumulacarrie's blogCPU Limits at Multiple LevelsHi Carrie, Thank you for the response. Yes, we are using platform metering on the 6800 box and here is the formulae we are using to calculate estimated total available CPU seconds/hr: Number o...
662704 Apr 2016 @ 12:59 PDTcarriecarrie's blogCPU Limits at Multiple Levels The 6800 does not support PM COD.  WM COD is the only supported option for COD on the 6800.    If you were actually using platform metering (PM) COD on the 6800 because of so...
662631 Mar 2016 @ 01:57 PDTrobing9carrie's blogStatistics collection recommendations – Teradata 14.0I have partition defined for more than 20 fact tables in my database only 2 tables has this issue.
662531 Mar 2016 @ 06:22 PDTHarshaKudumulacarrie's blogCPU Limits at Multiple LevelsHi Carrie, we recently migrated to 6800 system and implemented PMCOD 75% . I am using following formulae for available CPU Cycles in 6800 system. So estimated total available CPU seconds/day is ...
662430 Mar 2016 @ 11:47 PDTclakshminarasucarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.Thanks very much,  Carrie! I will analyse and do some amendments to the existing stats plan. Regards Lakshminarasu
662330 Mar 2016 @ 02:50 PDTcarriecarrie's blogStatistics collection recommendations – Teradata 14.0Robin,   I don't know of any way of "tuning" a collect statistics statement, in the way you might try to tune a regular query.   A collect stats statement is going to...
662230 Mar 2016 @ 02:19 PDTcsbandi5426DatabaseIdentifying Used, Unused and Missing StatisticsNice article and useful info. Thank you RK!!
662130 Mar 2016 @ 10:38 PDTcarriecarrie's blogEasing Into Using the New AutoStats FeatureChandra,   At a mininum, you need STATSUSAGE logging enabled for an Analyze Job to making recommendations regarding missing and used stats.  Enabling the XMLPLAN option as well may resu...
662030 Mar 2016 @ 10:35 PDTcarriecarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.Lakshminiarasu,   When you use the diagnostic help stats command, you may get more suggestions for statistics collections than you actually need.   Unfortunately,  it's di...
661930 Mar 2016 @ 10:04 PDTcarriecarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeGeeta,   The definitions you show below for CPUUServ and CPUUExec are taken from the ResUsageSPMA table (Chapter 6 in the ResUsage manual), which reports node-level metrics.  They are n...
661829 Mar 2016 @ 09:36 PDTrobing9carrie's blogStatistics collection recommendations – Teradata 14.0Yes I am collecting Sample Stats. How can i reduce the I/O in this case.   Regards Robin
661728 Mar 2016 @ 06:13 PDTWillimoaToolsIntroducing Teradata WalletHas anyone tried using tdwallet from a Python script ?   Using Teradata ODBC, via pyodbc interface. Thanks
661628 Mar 2016 @ 06:48 PDTcsbandi5426carrie's blogEasing Into Using the New AutoStats FeatureHi Carrie We recently started using statsmanager portlet and for DBQL logging what are all options required to start logging for the candidate databases we choose for ANALYZE job. We want to star...
661526 Mar 2016 @ 04:28 PDTclakshminarasucarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.Hi Carrie I have this situation where my team writes views (for simplicity, we call them reusable views) which often uses joins based on ID fields and current indicators. Then comes the consumer ...
661425 Mar 2016 @ 11:17 PDTgeethareddycarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeCarrie, I am seeing both the documentation and the view definitions reflecting the units as "centiseconds" in 14.10.  That is where exactly my confusion began. I am sending the d...
661325 Mar 2016 @ 10:18 PDTcarriecarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeGeeta,   In 13.10 the CPUTime is provided in the SPS table and is reported in milliseconds.  This column is removed from the table on 14.0 and up.   In 14.10, the CPUTime is prov...
661225 Mar 2016 @ 09:49 PDTTealiumLabsDatabaseTeradata Express 14.0 for Amazon EC2 Configuration GuideSteve - Can you grant me access to the AMI?  I'm trying to setup a test for a mutual customer of ours.
661125 Mar 2016 @ 08:21 PDTcarriecarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadFor question #1:  Requests that classify to a tactical workload will not be helped by setting up a parsing-only workload.  That is because tactical queries will do their parsing work in t...

Pages