All comment activity

#DateUserWhereItemComment
676001 Jun 2016 @ 09:33 PDTsamy@7ToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskI am new to tpt..I want to tansfer data from oracle to teradata table.I wrote a script for that.Will u plz tell me how to run it.I m using unix(putty).Plz tell me what are the requirements to run t...
675901 Jun 2016 @ 08:22 PDTCarlosBarichelloConnectivityHow to use the Teradata JDBC Driver with teradataR Regarding this article: - It is three years old.   - There is a comment stating that TeradataR is no longer supported.    - The link to TeradataR is broken.  ...
675831 May 2016 @ 02:17 PDTthakurrabikant@gmail.comConnectivityAccess External Data - A Table UDFWe are trying to compile attached views on (the target System) and its failing with error ‘REPLACE VIEW Failed. 9881: Function Dblink called with invalid number or type of parameters&rsq...
675731 May 2016 @ 02:16 PDTthakurrabikant@gmail.comConnectivityAccess External Data - Part 1 The Table UDF  We are trying to compile attached views on amex1 and its failing with error ‘REPLACE VIEW Failed. 9881: Function Dblink called with invalid number or type of parameters’ These ...
675631 May 2016 @ 09:21 PDTsk6752carrie's blogStatistics Threshold Functionality 101Carrie, Thanks for great info. In 14.10, Will optimizer do system sampling when System Threshold option (SysChangeThresholdOption = 0) and Usecount logging is turned  on ? Should System T...
675530 May 2016 @ 08:59 PDTericscheieToolsTeradata Python Module@nani -  Move the line "udaExec = teradata.UdaExec(..." above the "for" loop.   udaExec should only be initializd once.   Its not that the query is being executed...
675430 May 2016 @ 03:48 PDTnani255ToolsTeradata Python ModuleHi Eric, I've a requirement of running same sql query with 10 different users by logging on to bteq. I've used teradata python module for this & my code looks like below. The problem ...
675327 May 2016 @ 01:44 PDTcarriecarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerHi Naga,   A service level goal (SLG) is only for reporting purposes, so you can compare actual performance against your goals.  It is optional.  It sounds like you were under the ...
675227 May 2016 @ 01:42 PDTcarriecarrie's blogReserving AMP Worker Tasks? Don’t let the Parameters Confuse You!Hi Sachin,   An express request is usually issued in order to get particular information from the data dictionary, such as to validate the columns in a table that the query uses, or to get a...
675127 May 2016 @ 08:09 PDTcarriecarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXHi Samir,   First, only the TPT Update supports MLOADX. Standalone MultiLoad does not support MLOADX.   Second, in the default setting, the user just submits a TPT Update job and the ...
675026 May 2016 @ 10:45 PDThkong000AsterUsing Aster Express: ACT 1Hi Mike Can I use mutiple SQL querie using ACT command in the shell program(.sh)? For Example, ' This is question area' section below sample.sh ****sample.s...
674926 May 2016 @ 09:01 PDTnagadcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerThanks  Carrie :) i have already refered to this articel , but my understanding is not clear so when we set SLG to workload exspecially in timeshare workloads  how the resources  w...
674825 May 2016 @ 11:48 PDTdevag221090DatabaseTeradata Express Network ConfigurationHi Mike, Thanks very much. Appretiated.
674724 May 2016 @ 01:35 PDTDiEgoRToolsTeradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00A direct link to the documentation and a few examples would really help here. Specifically, I was looking to how to export into a format MS Excel would understand and failed to find it here or in G...
674624 May 2016 @ 07:41 PDTsghanwcarrie's blogReserving AMP Worker Tasks? Don’t let the Parameters Confuse You!Hi Carrie, Thank You for sharing above information, it is really helpful. I need your help, Do we have any query to identify to which AMP/Node the Parser Express Request Goes usually ?...
674523 May 2016 @ 03:18 PDTteradatauser2carrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXHi Carrie, As mentioned, in the 14.10/15.0 timeframe, MLOADX responds to workload management rules similarly to legacy MultiLoad, does it mean that its better to use this when we move to 15.10(we ...
674423 May 2016 @ 03:04 PDTcarriecarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerSetting a service level goal (SLG) is an option within workload management.   You are not required to set a service level goal for a workload, and it may not make much sense for most appl...
674323 May 2016 @ 09:19 PDTcarriecarrie's blogEasing Into Using the New AutoStats FeatureYou are correct.  Autostats uses tableIds to join it’s infrastructure (tdstats repository)  with the dictionary.   Thanks, -Carrie 
674223 May 2016 @ 06:33 PDTDany3R9ViewpointAn Overview of the new Viewpoint 15.11 DashboardNice introduction!   Viewpoint rulez ;)
674121 May 2016 @ 11:42 PDTnagadcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerHi Carrie, Can you please breif the purpose of SLG in timeshare workloads  on 2800 appliances. Thanks
674020 May 2016 @ 04:44 PDTcarriecarrie's blogStatistics Threshold Functionality 101Hi George,   Offhand, I don't know of a way to apply USING NO THRESHOLD to all the stats for a table.  You could turn off SysChangeThresholdOption if you don't want threshold to...
673920 May 2016 @ 08:51 PDTcarriecarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksThis is explained in a different blog posting titled  "How to Calculate Your Max Number of Usable AMP Worker Tasks"  at this location:   http://developer.teradata.com/blo...
673820 May 2016 @ 08:45 PDTcarriecarrie's blogExpediting Express RequestsWhat is a "high" value for ParserExpReq depends on the the complexity of the queries being executed and whether the system is congested or not.   You could try to establish a &q...
673719 May 2016 @ 11:42 PDTJagadishpes@gmail.comToolsTeradata Python ModuleI am repeatedly getting socket when trying to connect to Teradata: Error: Teradata.api.DatabaseError: (65, "[08001] [Teradata][Unix system error]  65 Socket error - The Teradata server c...
673619 May 2016 @ 02:13 PDTmbudkaODBCTeam's blogPerl with Teradata ODBC Hi, I've communicated the issue with CS support.  After several not sucessfull attemps we found out the root cause - libtdgss.so in TTU 15.10 is not compiled with libCst...

Pages