All comment activity

#DateUserWhereItemComment
555906 Mar 2015 @ 04:42 PSTecamagna76carrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksHi Carrie, Is there a way to check how many AWT does a user used in realtime? Thanks.
555805 Mar 2015 @ 02:58 PSTrechenwToolsTeradata Plug-in for Eclipse 15.00 now available@fgrimmer, if we are running Teradata version 14(.10.0.04), do we have to stick with version 14 of the Eclipse plug-in, or is version 15 of the plug-in backwards compatible with Teradata 14?
555705 Mar 2015 @ 08:24 PSTcarriecarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10You would have to use DBQLogTbl to examine query-level detail.  The ResUsageSPS table reports information about workloads, but not individual queries within a workload.   DBQLogTbl has ...
555605 Mar 2015 @ 08:21 PSTcarriecarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeTo  know how many of the new nodes you need, you have to track past, current, and expected future CPU usage, and determine how much CPU you will require after adding new nodes. It is imporant ...
555505 Mar 2015 @ 03:55 PSTgeethareddycarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Hi Carrie, I think running DBC stats daily is recommendable on versions earlier than 14.10. Do you  have any other frequency recommendations for version before and after 14.10?   Than...
555405 Mar 2015 @ 02:53 PSTLUCAScarrie's blogNew, Simplified Approach to Parsing Workload SelectionCarrie, I do agree on everything about rows/requests considerations. About Session WDID and WDID of the request i can't say that they often differ, just it happens on some users. About ident...
555305 Mar 2015 @ 02:44 PSTNC185016ToolsTeradata StudioFrancine - is there a way of extracting/exporting the SQL History entries from one Studio install to another (like you might do by just copying the Access database .MDB file from a SQLA installatio...
555204 Mar 2015 @ 02:47 PSTcarriecarrie's blogNew, Simplified Approach to Parsing Workload SelectionPierre,   Each DBQLogTbl row represents an entire request, parsing and AMP work combined.   There are no "session-only rows" in DBQLogTbl, there are only "request ro...
555103 Mar 2015 @ 09:28 PSTsunnystevecarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Hi Carrie, One of our application is missing its SLG very often ,So I am just wondering which is the best place to  analyze how often the SLG is being missed is it querylog or resusagesps. &...
555003 Mar 2015 @ 09:24 PSTsunnystevecarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeHi Carrie, Our prod system is approaching the capacity limits and we are looking to expand the system but the question is how do I calculate the no of nodes or the space that need to be added in t...
554902 Mar 2015 @ 11:40 PSTsmazingoDatabaseMigrating to Teradata 13.0I am thinking that you should rearch out to your Teradata site team to request the Ghost patch. We have certified the Ghost fix for 13.10 and updated TSS with the certified packages. We are recomme...
554802 Mar 2015 @ 09:26 PSTsmazingoDatabaseMigrating to Teradata 13.0let me direct your question to the proper resource. thanks, steve
554702 Mar 2015 @ 07:32 PSTLUCAScarrie's blogNew, Simplified Approach to Parsing Workload SelectionHi Carrie, assuming that DBQLOGTBL captures the whole logging of the activity, what is the proven rule to distinguish session rows with a specific parsing WDID ? everytime SessionWDID is differen...
554601 Mar 2015 @ 10:51 PSTMaheshJessyDatabaseMigrating to Teradata 13.0 Can you pls let me know if you have any impact due to the patch Installation…any impact to the current work or next releases   Since we are in Teradata13.10 but we wanted to ...
554527 Feb 2015 @ 06:41 PSTvenkatkannan3ConnectivityLogging On Teradata Database Sessions via BTEQCan we connect using DSN that we've created for SQL Client?   Thanks, VK
554426 Feb 2015 @ 10:22 PSTvic.mirandasjpeeris's blogWriting to a file from a Java External Stored ProcedureWhich node is the file going to reside? Thank you very much Vic
554325 Feb 2015 @ 07:55 PSTcaimantianConnectivityTeradata Connector for Hadoop now availableHi All, I am using teradata-connector-1.3.3 with the following versions: ->Teradata 15.0 ->HDP 2.1 I am trying to import data from teradata tables to HDFS.   I create a table i...
554224 Feb 2015 @ 07:28 PSTwolfgang.neurauterToolsIntroducing Teradata WalletHi MaxG,   As mentioned we use a Windows Server. I could not find a Windows tool (Expect one for 999$) to download. Do you have a link where I can download Expect for Windows? A non interac...
554120 Feb 2015 @ 01:35 PSTunnam237@gmail.comDatabaseIdentifying Used, Unused and Missing StatisticsNice Article ....!!!
554020 Feb 2015 @ 11:25 PSTMaxGToolsIntroducing Teradata WalletWolfgang -- you can use the Expect tool (mentioned in the comments above) to add entries to the wallet. The Teradata Wallet user should be the same as the BTEQ user. Wallet entries on Windows are ...
553920 Feb 2015 @ 07:21 PSTwolfgang.neurauterToolsIntroducing Teradata WalletHello Shawn & MaxG, I have tried to use tdwallet with our job scheduling software IBM TWS (Maestro) using Windows server.   Running a bteq script interactively tdwallet works fine. Run...
553820 Feb 2015 @ 12:13 PSTUttamnConnectivityTeradata Connector for Hadoop now availableDoes Teradata connector for hadoop also works for  Aster  connectivity?Looking for Aster 5.0 and HDP 2.2 connectivity.
553718 Feb 2015 @ 04:58 PSTfgrimmerToolsTeradata StudioThe 15.10 release is scheduled for first week in April. We are still finalizing the list of fixes. New features include: Install Configuration File,  Aster Administration (Create Database, Sch...
553618 Feb 2015 @ 03:23 PSTteraJavaToolsTeradata StudioThanks Francine, When is the 15.10 release scheduled for? Is there a list of features and fixes available for users like us to consider?
553518 Feb 2015 @ 02:42 PSTfgrimmerToolsTeradata Studio@teraJava, In our next release (15.10), we will be providing an install option for you to provide a list of connection profiles for your users. I think it will provide you with what you need as des...

Pages