#DateWhereItemComment
17026 Sep 2012 @ 08:24 PDTcarrie's blogAutomated Demotions on the Appliance: What are Query Milestones?You are very welcome! Thank you for the kind feedback. -Carrie
16926 Sep 2012 @ 08:09 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10DBQL provides a series of predefined tables and views that can store historical records of queries and their duration, performance, and target activity based on rules you specify. You control whe...
16824 Sep 2012 @ 08:29 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Anil, Sorry, but I do not have such a script. You can post the question on one of the forums and see if anyone else does. You can also look at mtmoura's blog on Developer Exchange, he has an ...
16724 Sep 2012 @ 08:28 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Anil, PDCR is a performance and capacity reporting offering from Teradata Professional Services that I believe is offered as part of a service. You should contact your Teradata Account Team or y...
16619 Sep 2012 @ 10:22 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Sam, I have tried to respond to your questions below: Q) COLLECT STATS statement do i need to use INDEX COLUMN NAME OR COLUMN COLUMN NAME A) You can use either INDEX OR COLUMN syntax w...
16504 Sep 2012 @ 02:14 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Both ProcID and QueryID do indeed appear in the two views that you mention. I checked this on one of my 13.10 systems. If you are finding that information from those two views do not correlate th...
16431 Aug 2012 @ 11:06 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10In releases earlier than 13.10, the DelayTime column in DBQL reflects time delayed by either a system throttle or a workload throttle, but not the combination. In pre-13.10, DBQL only account...
16329 Aug 2012 @ 11:22 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Ian, Because DBQL tables contain a large number of fields, and efficiency in logging data has been a priroity, the philosophy has always been to not make the effort of logging a field if it is ...
16229 Aug 2012 @ 11:14 PDTcarrie's blogNew opportunities for statistics collection in Teradata 14.0Padhia, here are responses to your questions: 1. First, you have to re-issue statistics collections individually when you get on 14.0 using the grouped (multiple collections in one statement) ...
16123 Aug 2012 @ 09:00 PDTcarrie's blogIntrepreting DBQL DelayTime in Teradata 13.10Etienne, Counters are always decremented at the time of a query's demotion. The reason that is done is to ensure that the concurrent number of queries active in that workload is accurately ref...
16022 Aug 2012 @ 10:42 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Rommel, By design, load jobs from both mainframe and network attached clients should be treated the same in regards to session management in the database. This assumes that both client platform...
15907 Aug 2012 @ 04:03 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Hi Keith, I now see that you were indeed on the correct navigation path, I just did not continue on down the path as far as you did. Navigating deeper, I can now see you where the Viewpoint...
15802 Aug 2012 @ 09:00 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Hi Keith, I think you might be taking a wrong turn in Workload Designer. When you first get into Workload Designer you will see the various category icons at the top, among them one titled "S...
15701 Aug 2012 @ 11:05 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsAlvie, First, query band exclusion only works starting in 13.10. You want to disqualify by query band on any workload that has a workload throttle where the auxiliary SQL within a utility mig...
15601 Aug 2012 @ 10:34 PDTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandAndrew, When calculating past usage, CPU usage is accounted against what is currently being consumed. If the system is only consuming 40% CPU, then everything is calculated as if that 40% were a...
15527 Jul 2012 @ 01:53 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsAlvie, On your comment left one day ago... Yes, creating another workload without a throttle for that purpose is a reasonable thing to do in those cases. Good idea. Thanks, -Carrie
15427 Jul 2012 @ 01:47 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsThere is another option to prevent auxiliary session SQL from mainframe utilities being controlled by utility throttles. That is to use query band exclusion on the system throttle. You must be ...
15326 Jul 2012 @ 10:18 PDTcarrie's blogPenalty Box Over-Population Hi Shanker, There is no mechanism for delaying queries that have already begun execution. When a query is demoted into a penalty box workload from another workload, that query is already active,...
15225 Jul 2012 @ 03:45 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsParsim, You can create workloads that have load utility type as part of their classification, and that also classify by user and/or by application. That way the loads will run under the contro...
15125 Jul 2012 @ 03:42 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsAlvie, What you describe above will work, as an alternative approach to using system throttles with exclusion. I am still investigating if there are ways to manage the auxiliary session statem...
15018 Jul 2012 @ 11:08 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations I am only guessing, but it may be possible that the NUSI sample code is not recognizing the diagnostic percentage. Once you set the diagnostic as you did, it should effect all stats collections in...
14916 Jul 2012 @ 08:16 PDTcarrie's blogFlow Control and Spawned WorkActually, your math is not quite right. You say: ....so the total unreservered awts are 80-24+3+3=64... The correct math is: 80 - 24 = 56; ...
14811 Jul 2012 @ 03:45 PDTDatabaseStatistics Collection Recommendations for Teradata 12In terms of join columns, if these are single-column join constraints, it is a good idea to collect statistics if the column is not unique. If the single column join column is defined as a unique ...
14709 Jul 2012 @ 08:10 PDTcarrie's blogChanges to the TASM AMP Worker Task Event in Teradata 13.10Lords, Unfortunately, your question is not related to the topic of this posting, and is not an area that I have experience in. I would suggest you post your question on Teradata Forum. http:...
14603 Jul 2012 @ 08:39 PDTDatabaseStatistics Collection Recommendations for Teradata 12Shrey, My responses are below your questions: 1. What are stale statistics? Stale statistics come about when statistics have been collected in the past, but the table has grown since the s...

Pages