13 | 17 Aug 2016 @ 04:02 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Hi
We have found the issue.
Need to fill the new TimeZone field under: Monitored Systems->Setup->General System Details
Cheers
|
12 | 16 Aug 2016 @ 08:10 PDT | Viewpoint | Overview 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 ... |
11 | 28 Jun 2016 @ 09:51 PDT | Tools | Transitioning 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... |
10 | 28 Jun 2016 @ 09:30 PDT | Tools | Transitioning from SQL Assistant to Studio Express | Hi 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,... |
9 | 21 Jun 2016 @ 12:23 PDT | Rama.Korlapati's blog | Incremental Planning and Execution |
QueryBand NumFragments Elapsed time EstProcTime AMPCPUTime ParserCPUTime TotalIOCount SpoolUsage
=S> DynamicPlan=SYSTEMX 2 ... |
8 | 17 Apr 2016 @ 05:31 PDT | carrie's blog | Being 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... |
7 | 06 Mar 2016 @ 03:00 PST | carrie's blog | Things that Run in the Session Workload | Thanks Carrie, I didn't have a Teradata Sytem available to check the actual settings.
Cheers
|
6 | 01 Mar 2016 @ 08:14 PST | carrie's blog | Things that Run in the Session Workload | Hi 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... |
5 | 15 Feb 2016 @ 09:16 PST | Tools | Creating a Simple Java User Defined Function using the Teradata Plug-in for Eclipse | Hi 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 ... |
4 | 02 Dec 2015 @ 07:54 PST | carrie's blog | Expediting Express Requests | Hi 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... |
3 | 29 Nov 2015 @ 05:42 PST | carrie's blog | Expediting Express Requests | Hi 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... |
2 | 16 Feb 2012 @ 01:49 PST | carrie's blog | Penalty 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 ... |
1 | 05 Feb 2012 @ 09:50 PST | carrie's blog | If 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... |