#DateWhereItemComment
32024 Sep 2013 @ 03:02 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0To venkatarayudu:   The official Teradata documentation has background and explanatory information about statistics collection.   Go to http://www.info.teradata.com/   This man...
31924 Sep 2013 @ 03:00 PDTcarrie's blogPenalty Box Over-Population It's usually a good idea if you can identify poorly-written queries before they run and create filter rules in TASM to reject them before they begin to run.   I have seen such rules b...
31824 Sep 2013 @ 02:57 PDTDatabaseStatistics Collection Recommendations for Teradata 12The AutoStats feature in 14.10 will be able to identify unused stats.   I don't know of any way in SQL to currently find that out, as there is no data stored in any database table tha...
31724 Sep 2013 @ 12:11 PDTcarrie's blogIndex Maintenance During Mini-Batch ProcessingHi Raja,   You can certainly use the HASH BY COLUMN or HASH BY RANDOM options, if you are on 14.0.  They work on any NOPI table (column-partitioned or not), but not on tables that have ...
31612 Sep 2013 @ 05:03 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Target Level Emulation mimics the customer environment by capturing such detail as DDL, stats, RAS, cost profiles, DBS Control detail, etc. from one system and then placing that detail on another s...
31506 Sep 2013 @ 03:54 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsJana,   An auxiliary session is not required as part of a load utility job, although most Teradata utilities do support that option.  But if you use an auxiliary session it will not be ...
31405 Sep 2013 @ 08:29 PDTcarrie's blogAutomated Demotions on the Appliance: What are Query Milestones?Hi Ricky,   By default, all requests will run in $M (allocation group 2) on the appliance unless their user's account string has been modified to point to one of the other performance gr...
31326 Aug 2013 @ 04:39 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Surup,   You cannot use the new 14.0 collect statistics syntax on a database with earlier software, such as 13.10.  It will not be recognized.     Here is an example of the...
31223 Aug 2013 @ 03:31 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Jana,   The SessionInfo view only shows currently logged on sessions.   All utility sessions are logged in the DBC.EventLog which is also accessible via the DBC.LogonOff view.  N...
31121 Aug 2013 @ 10:44 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Jana,   I'm glad that you resolved the issue about the max session counts being honored.   You may see fewer sessions than your session management rules specify on some lo...
31016 Aug 2013 @ 08:42 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Saurabh,   Once you are on 14.0 you can query the StatsTbl in the data dictionary.  The IndexID field in that table will = 1 for the primary index fields(s).    There is ...
30914 Aug 2013 @ 02:48 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Raj,   When you collect stats on a volatile tables, those stats are held in the memory of the parsing engine.  They are not written to the data dictionary.   They can be viewe...
30812 Aug 2013 @ 04:18 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hari Krishna,   You can include the calculation as a column in the select list of the SQL statement and give it a name with the "AS" clause:   (bf+basic)  as sumup &nb...
30709 Aug 2013 @ 11:16 PDTcarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.Prior to Teradata 14.0, a user that is not DBC must have INDEX or DROP privileges on an object in order to collect statistics on it.  So you would need to issue a GRANT statement giving the us...
30608 Aug 2013 @ 08:00 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0No, it is not possible to collect stats on spool files in any release. There is no interface available that would support that.   Thanks, -Carrie
30505 Aug 2013 @ 08:24 PDTcarrie's blogRecommended Dictionary Statistics to Collect in Teradata 14.0Just for future refence, the best place to post a general question such as this is on the Teradata Forum.  That will give the question exposure to the broadest audience.&nb...
30401 Aug 2013 @ 09:48 PDTcarrie's blogTASM State Changes are Streamlined in Teradata 14.0Interesting question.   This should work for you by just adding a new planned environment that is for the first 6 days of each month.   At each TASM event interval...
30301 Aug 2013 @ 09:41 PDTcarrie's blogAre AMP Worker Tasks used by FastExport in Response Mode?Velu,   BYNET buffers only hold a small portion of the data being returned when it is a very large data set involved.  In the case of FastExport in spool mode, AMP worker tasks are rele...
30201 Aug 2013 @ 09:38 PDTcarrie's blogUtility Throttles – You Won’t Regret It!Mauricio,   The solution is to use two levels of throttles:  Utility throttles for all users, then workload throttles on workloads that only specific users classify to.    T...
30131 Jul 2013 @ 11:23 PDTcarrie's blogUtility Throttles – You Won’t Regret It!Hi Mark,   If your client software and DBS software is both on 13.10, then you should be able to use load utility throttles just fine.  You do not want to try to use system throttles as...
30031 Jul 2013 @ 10:36 PDTcarrie's blogIndex Maintenance During Mini-Batch ProcessingRaja,   I am sorry if have not fully understood the question you are asking.  A minibatch process would include both Phase I and Phase II of FastLoad and both phases would operate on th...
29931 Jul 2013 @ 10:32 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Unfortunately, a "large number of AMPs" is arbitrary.  If the number of sessions you would have to specify in order to get one session per AMP becomes unwieldly, too large a num...
29830 Jul 2013 @ 10:43 PDTcarrie's blogUsing the ResUsageSAWT table to Monitor AMP Worker TasksIn your formula, the 4 should be a 10 (total number of AWTs in the expedited reserve pool).   There are 3  reserve pools set up for expedited work:  Work08, Work09, Work10. You ...
29724 Jul 2013 @ 10:26 PDTcarrie's blogControlling the Flow of Work in TeradataGeeta,   You're more likely to get a response if you post Viewpoint-related questions somewhere people knowedgeable about Viewpoint will see them.  I don't think Gary reads the&...
29624 Jul 2013 @ 10:15 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Jaison,   Assuming the configuration has a moderate or low number of AMPs (as your example does), ARC is most efficient when there is 1 session per AMP since each session can only process 1 ...

Pages