All comment activity

#DateUserWhereItemComment
698626 Jul 2016 @ 05:31 PDTjgordonToolsIntroduction to Teradata Data Mover: Create your first jobYou can only do partial copies with ARC on a limited basis.  Please read the "About Partial Copies" section in the Data Mover User Guide for more details.  If you're interes...
698526 Jul 2016 @ 09:56 PDTericscheieToolsTeradata Python Module@eo186005 - Can you e-mail me the log file with DEBUG enabled?   Also, what OS are you running on, and what session character set is being used?   If you change the session character set ...
698426 Jul 2016 @ 08:58 PDTeo186005ToolsTeradata Python ModuleFurther to the above, I turned on DEBUG logging and I can see this: SQLFetch succeeded with info:  [01004] [Teradata][ODBC Teradata Driver] Character string truncated Anyone got any ideas on...
698326 Jul 2016 @ 05:49 PDTeo186005ToolsTeradata Python ModuleHi Eric. I've been hapilly using your excellent module for a few months now. However, today I hit a snag and I'm unable to resolve. I am using some simple code: for resultRo...
698226 Jul 2016 @ 05:49 PDTeo186005ToolsTeradata Python ModuleHi Eric. I've been hapilly using your excellent module for a few months now. However, today I hit a snag and I'm unable to resolve. I am using some simple code: for resultRo...
698125 Jul 2016 @ 06:05 PDTNavicToolsIntroduction to Teradata Data Mover: Create your first jobThanks Gordon!!   Can we use data filters for filtering data from tables while performing Archival using Arcmain utility? If yes, can you help me with the command.  If not, What is the...
698025 Jul 2016 @ 01:10 PDTjgordonToolsIntroduction to Teradata Data Mover: Create your first jobData Mover does not create physical data files when copying data.  Data is transferred through buffers in memory.
697925 Jul 2016 @ 10:13 PDTNavicToolsIntroduction to Teradata Data Mover: Create your first jobHi Gordon, Is TDM creates any physical file so I can move to new box and restore? if no, is there any option to copy the Teradata DB from one box to another using physical copy.   Thnx Na...
697822 Jul 2016 @ 02:10 PDTdnoethExtensibilityUDF User GuideDid you notice that this was posted 13 years ago? There's a SQL Functions and Operators manual: http://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/index.html#page/SQL_Reference/B035_1145...
697722 Jul 2016 @ 01:37 PDTkalchachuExtensibilityUDF User GuideHi, Hope you are doing well. I am Kal from UK, working for a MNC which uses Teradata. However I am coming from Oracle background and struggling to find oracle functions in Teradata.   ...
697621 Jul 2016 @ 01:45 PDTgrybackViewpointTeradata Data Lab 15.10 ReleaseIt would not be something we would recommend as the data lab size will not be immediately updated as it will be waiting on one of the collectors to run and pick up the new size. However as a work-a...
697521 Jul 2016 @ 08:10 PDTcarriecarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksHi Helena,   If you are running out of AMP worker tasks (AWT) that can slow a query down.   Query steps require AWTs to execute, and if all the AMPs a query step is running in do n...
697421 Jul 2016 @ 01:29 PDTkvzViewpointTeradata Data Lab 15.10 ReleaseHi Gryback, We want to decrease space of single datalab. We are bypassing VP portlet for space movement because as informed above CS confirmed that its bug. But till the client upgrade datalab pa...
697320 Jul 2016 @ 12:58 PDTB_RockToolsTeradata Python ModuleHow do you update the config file? I'm trying to build a gui and I want to allow the user to change the config file settings.    Thanks,  
697220 Jul 2016 @ 08:30 PDTgrybackViewpointTeradata Data Lab 15.10 ReleaseAre you decreasing space of a single data lab or of a lab group? And what is the justficiation to bypass the Viewpoint interface? 
697120 Jul 2016 @ 05:52 PDTkvzViewpointTeradata Data Lab 15.10 ReleaseHi Gryback, Will there be any problem user may face, if i decrease datalab space through administrator not through VP portlet ??
697019 Jul 2016 @ 12:54 PDTh.r.thejas@gmail.comToolsTeradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00i am using TPT 15.10 to export data directly export data to HDFS, but i am having issue with EscapeQuoteDelimiter and EscapeTextDelimiter  both are ' \ ' this is giveng me pr...
696919 Jul 2016 @ 06:44 PDThv186006carrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksHi Carrie, A question from the Netherlands. We are with a customer with a 2700 box and we are experiencing issues with respect to the performance at the moment. We are not seeing any strange s...
696818 Jul 2016 @ 09:36 PDTKarthikkToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskHi Tony,   I have refered the manual and I am able to load multiple target servers using MULTIPlLE APPLY feature of TPT. Thank you for your assistance on the same   Regards, Karthik
696718 Jul 2016 @ 02:14 PDTjebeckford1020ConnectivityTeradata Connector for Hadoop now availableHi I've downloaded TDCH 1.4.4.  I'm trying to connect an IBM BI 3.1 (Hadoop 2.2) cluster to a TD 14.10 database.  I have read through the TDCH 1.4 tutorial that you included in th...
696618 Jul 2016 @ 07:10 PDTMadhumToolsTeradata Studio Expressthanks for the info Fgrimmer....
696517 Jul 2016 @ 11:06 PDTckothiDatabaseIdentifying Used, Unused and Missing Statistics Hi Rama,   We are in 14.10 .We have set  NoDot0Backdown = False in the control file.   Currently I created few Analyze jobs in stats manager for databases I enable...
696417 Jul 2016 @ 08:31 PDTckothicarrie's blogStatistics Collection Recommendations – Teradata 14.10, 15.0 and 15.10 Hi Carrie,   We are in 14.10 .We have set  NoDot0Backdown = False in the control file.   Currently I created few Analyze jobs in stats manager for databases I enab...
696314 Jul 2016 @ 09:11 PDTdnoethÜber SQLNew StatsInfo query for TD14This still works in TD15.10, there seems to be no additonal info.   Outdated stats can be found by adding a WHERE-condition on LastAlterTimeStamp/LastCollectTimeStamp and table without ...
696214 Jul 2016 @ 08:50 PDTDRossmannRobG's blogDetermining Month-End Date for a Date DimensionI just ran the two statements from SRINIVAS... and they gave different results for July 2016.  The first one gave 07/30/2016 and the second gave 07/31/2016.  I can't exactly figure ou...

Pages