#DateForumTypeThreadPost
1610 Aug 2016 @ 08:20 PDTPrivate Forum
1530 Oct 2013 @ 07:41 PDTDatabaseReplyTotal number of AWTsMaxAMPWorkerTasks in DBSCONTROL Internal fields provides what you are looking for.
1429 Oct 2013 @ 09:41 PDTGeneralReplyDIAGNOSTIC Command - Need helpIn TD13, Teradata improved the performance of aggregations.  One of the primary things in this group of aggregation enhancements was work to improve the performance of Distinct and Group by, a...
1312 Nov 2012 @ 11:07 PSTPrivate Forum
1210 Jul 2012 @ 07:58 PDTPrivate Forum
1110 Feb 2012 @ 07:44 PSTPrivate Forum
1010 Feb 2012 @ 06:50 PSTPrivate Forum
908 Dec 2011 @ 05:07 PSTPrivate Forum
809 Nov 2011 @ 12:32 PSTDatabaseReplyHigh Skewness Run something like these to see where the skew is coming from.   sel hashamp(hashbucket(hashrow(prod_cd,ord_date,prod_name))), count(*) FROM product_region_2 group by 1 order by...
709 Nov 2011 @ 06:57 PSTDatabaseReplyHigh Skewness Can you attach DDL for the two tables?
628 Oct 2011 @ 02:41 PDTDatabaseReplyWhat is the difference between a YNET and BYNET? The "B".   heh heh.  Come on.  As you read this, you know you wanted to say it. . . .
528 Oct 2011 @ 02:37 PDTDatabaseReplyLogging SYSTEMFE. The scripts require it. As part of the process, the scripts included in that document will disable DBQL logging and re-enable DBQL logging on SYSTEMFE.  The sole purpose of this is to f...
411 Oct 2011 @ 12:46 PDTDatabaseReplyResource Partition Weight for Default partition in Priority Scheduler in TASM. It is still best to have a fair amount of weight in the Default RP -- Generally, it should be given a weight equal to or slightly higher than the highest weighted non-tactical RP on the system. ...
303 May 2011 @ 12:00 PDTDatabaseReplyHiga charts?Just stumbled upon this. Those should work on TD13. Let me know if they don't and what issue you have with them.
203 Mar 2010 @ 06:43 PSTUDAReplyTrying to Identify Logons that are not assigned to a the person whom it belongs to.Another thing to consider looking at is the ClientID column in the DBQLOGTBL table. This typically will have the network ID for the user that is logging onto the system.
110 Dec 2009 @ 01:16 PSTDatabaseReplywhere would I find information about PDCRYes, PDCR is the next generation of PMCP. These are commonly called the Performance Data Collection and Reporting service. You should contact your Teradata Account Team to find out more about t...