All comment activity

#DateUserWhereItemComment
681527 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 ...
681427 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...
681327 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 ...
681226 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...
681126 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...
681025 May 2016 @ 11:48 PDTdevag221090DatabaseTeradata Express Network ConfigurationHi Mike, Thanks very much. Appretiated.
680924 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...
680824 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 ?...
680723 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 ...
680623 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...
680523 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 
680423 May 2016 @ 06:33 PDTDany3R9ViewpointAn Overview of the new Viewpoint 15.11 DashboardNice introduction!   Viewpoint rulez ;)
680321 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
680220 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...
680120 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...
680020 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...
679919 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...
679819 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...
679718 May 2016 @ 10:52 PDTaabhyankar9ViewpointIntroduction to Viewpoint 15.11 MobileHi, Can you please tell more on Viewpoint Mobile? We connect to client viewpoint using Citrix gateway. How does it load viewpoint just by opening in browser?   Ajinkya
679618 May 2016 @ 08:42 PDTgeo590carrie's blogStatistics Threshold Functionality 101Hi Carrie, Great article.  Is there an easy way to refresh ALL existing statistics on a table USING NO THRESHOLD?  It looks like you need to specify an explicit column / index when the U...
679518 May 2016 @ 07:39 PDTms628255carrie's blogEasing Into Using the New AutoStats FeatureHi Carrie,   one short question that came up from a customer. What happens if a table is being renamed and a new table is being created with the old name? Is the Stats Manager based on table...
679417 May 2016 @ 09:28 PDTbchuToolsTeradata Python Modulewould someone please let me what i did wrong here? here is the script: -- import teradata with udaExec.connect(method="odbc", system="elm", username="dbc", password...
679317 May 2016 @ 08:08 PDTTeradata MikeAsterUsing Aster Express: ACT 2, Loading DataThere is an option to skip errors.  You can always see the options by running       ncluster_loader --help   Here is the option to skip malformed rows. --e...
679217 May 2016 @ 04:50 PDThkong000AsterUsing Aster Express: ACT 2, Loading DataHi Mike!! Are there any options for skip the row when error occurs using ncluster loader?
679116 May 2016 @ 11:28 PDThoadheadToolsBenchmarking and TdBench 7.2This is a well though out comprehensive approach for doing an evaluation of a Teradata product.

Pages