#DateWhereItemComment
1317 Aug 2016 @ 04:02 PDTViewpointOverview of Teradata Viewpoint 15.10Hi We have found the issue. Need to fill the new TimeZone field under: Monitored Systems->Setup->General System Details Cheers
1216 Aug 2016 @ 08:10 PDTViewpointOverview of Teradata Viewpoint 15.10  Hi Shirty   We have just setup viewpoint 15.11, database is at 15.00. I'm trying to setup the Query Log data collector, and after granting permisson to PDCRDATA, we ...
1128 Jun 2016 @ 09:51 PDTToolsTransitioning from SQL Assistant to Studio Express "New Teradata Studio Administration User Experience" POST: Randy, I am seeing the statement fails with [3606 : 42000] Syntax error: Invalid SQL Statement when the comment comes befor...
1028 Jun 2016 @ 09:30 PDTToolsTransitioning from SQL Assistant to Studio ExpressHi Francine I'm creating a fairly simple stored procedure in Studio.  When I compile it, if there are errors, it doesn't display the line numbers like SQLA does, so not easy to debug,...
921 Jun 2016 @ 12:23 PDTRama.Korlapati's blogIncremental Planning and Execution QueryBand    NumFragments Elapsed time  EstProcTime AMPCPUTime ParserCPUTime TotalIOCount SpoolUsage =S> DynamicPlan=SYSTEMX  2 ...
817 Apr 2016 @ 05:31 PDTcarrie's blogBeing Smart About Using Workload Classification Hi Carrie Thanks for the article. I have question, what happens if we want a workload to define on a table AND a database, as currently they are OR'd as you mentioned.  Consider the...
706 Mar 2016 @ 03:00 PSTcarrie's blogThings that Run in the Session WorkloadThanks Carrie, I didn't have a Teradata Sytem available to check the actual settings. Cheers
601 Mar 2016 @ 08:14 PSTcarrie's blogThings that Run in the Session WorkloadHi Carrie Thanks the article, very informative as always. Do you think we could classify the "Call" stored procedure statement in the parsing only workload as AMPCPUTime is usually 0, o...
515 Feb 2016 @ 09:16 PSTToolsCreating a Simple Java User Defined Function using the Teradata Plug-in for EclipseHi JS.. Just wondering if we have to use Eclipse or other GUI's to setup Java UDF's and XSP's, or can we write the code natively as have the JRE installed.  It would mean writing ...
402 Dec 2015 @ 07:54 PSTcarrie's blogExpediting Express RequestsHi Carrie Thanks for your detailed reply. Yes, we are on SLES10 TD13.10, will upgrade to SLES11 sometime in the new year, after the 15.0 upgrade. I have found the Orange book you mentioned, very...
329 Nov 2015 @ 05:42 PSTcarrie's blogExpediting Express RequestsHi Carrie I'm currently working on a 13.10 system, which is due to be upgraded to 15.0 at the end of the year.  We are using Viewpoint 15.0 The system is currently CPU bound and frequent...
216 Feb 2012 @ 01:49 PSTcarrie's blogPenalty Box Over-Population Hi Carrie I would like to create a penalty box under it's own resource partition in TDWM, however there is a limit of 5 resource partitions, and I already have 5 (3 different business groups with ...
105 Feb 2012 @ 09:50 PSTcarrie's blogIf You’re Not Collecting Statistics on Your Dictionary Tables, Do It. Now.Hi Carrie I have started to collect stats on my customers system, and analysis of DBQL queries advised stats on DBC.DATABASESPACE. This is one of the tables you said can't be collected on because...